/// <summary>
        /// 導(dǎo)出Excel方法：Excel導(dǎo)出模式，支持綁定下拉選擇
        /// </summary>
        /// <param name="msg">執(zhí)行返回的消息胁出，非空時(shí)執(zhí)行失敗</param>
        /// <param name="dt">導(dǎo)出的數(shù)據(jù)</param>
        /// <param name="customColumnName">導(dǎo)出需要用到的自定義列名型型，如果為空，取數(shù)據(jù)源的表名</param>
        /// <param name="ExportName">導(dǎo)出的文件名</param>
        /// <param name="dicDropdown">哪一列需要綁定默認(rèn)下拉值全蝶；字典Dictionary<int, string> 類型闹蒜，int是需要綁定的列；string是需要綁定的下拉抑淫，多個(gè)值用逗號(hào)隔開</param>
        /// <returns></returns>
        public static bool OutputToExcel1(out string msg, System.Data.DataTable dt, string customColumnName = "", string ExportName = "", Dictionary<int, string> dicDropdown = null)
        {
            bool result = true;
            msg = "";
            try
            {
                System.Windows.Forms.SaveFileDialog dlg = new System.Windows.Forms.SaveFileDialog();  //保存文件對(duì)話框
                dlg.Filter = "*.xls|*.xls";                 //過濾文件類型
                dlg.CreatePrompt = false;                   //提示創(chuàng)建文件
                dlg.FileName = ExportName;
                if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();//表示Excel應(yīng)用程序
                    if (xlApp == null)
                    {
                        msg = "可能您的機(jī)子未安裝excel绷落，無法創(chuàng)建excel對(duì)象！";
                        return false;
                    }
                    Workbooks workbooks = xlApp.Workbooks;  //workbook對(duì)象的集合
                    Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet); //表示一個(gè)workbook
                    Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1]; //返回workbook的第一個(gè)worksheet 

                    Microsoft.Office.Interop.Excel.Range allRange = worksheet.Range[worksheet.Cells[1, 1], worksheet.Cells[1 + dt.Columns.Count, 1 + dt.Rows.Count]];
                    allRange.NumberFormatLocal = "@";//文本格式
                    allRange.EntireColumn.AutoFit(); //全部列自適應(yīng)寬度
                    allRange.EntireRow.AutoFit();    //全部行自適應(yīng)高度
                    allRange.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;//水平居中
                    allRange.VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter; //垂直居中
                    

                    //設(shè)置下拉選擇
                    if (dicDropdown != null)
                    {
                        foreach (var item in dicDropdown)
                        {
                            //設(shè)定一定范圍內(nèi)單元格的格式
                            Microsoft.Office.Interop.Excel.Range myrange = worksheet.Columns[item.Key]; //worksheet.Range[worksheet.Cells[2, i], worksheet.Cells[2 + i, i]];   //第二行開始始苇，到記錄總數(shù)
                            //worksheet.Cells[1, 1 + i] = titleList[i];//為單元格賦值
                            myrange.Validation.Modify(Microsoft.Office.Interop.Excel.XlDVType.xlValidateList, Microsoft.Office.Interop.Excel.XlDVAlertStyle.xlValidAlertStop, Type.Missing, item.Value, Type.Missing);
                        }
                    }

                    //設(shè)置標(biāo)題
                    List<string> titleList = customColumnName.Split(',').ToList();
                    for (int i = 0; i < titleList.Count; i++)
                    {
                        //設(shè)定一定范圍內(nèi)單元格的格式
                        Microsoft.Office.Interop.Excel.Range myrange = worksheet.Range[worksheet.Cells[1, 1 + i], worksheet.Cells[1, 1 + i]];
                        worksheet.Cells[1, 1 + i] = titleList[i];//為單元格賦值
                    }


                    //插入數(shù)據(jù)
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        for (int j = 0; j < dt.Columns.Count; j++)
                        {
                            //設(shè)定一定范圍內(nèi)單元格的格式
                            Microsoft.Office.Interop.Excel.Range myrange = worksheet.Range[worksheet.Cells[2 + i, 1 + j], worksheet.Cells[2 + i, 1 + j]];

                            worksheet.Cells[2 + i, 1 + j] = dt.Rows[i][j].ToString();//為單元格賦值
                        }
                    }
                    
                    //保存及退出
                    workbook.Saved = true;
                    workbook.SaveCopyAs(dlg.FileName);
                    xlApp.Quit();

                    GC.Collect();//強(qiáng)行銷毀 
                    Process.Start(dlg.FileName); //打開EXCEL
                }
            }
            catch (Exception ex)
            {
                msg = ex.Message;
                result = false;
            }
            return result;
        }

        /// <summary>
        /// 導(dǎo)出Excel方法：數(shù)據(jù)流方式砌烁，已文本方式導(dǎo)出
        /// </summary>
        /// <param name="dt">導(dǎo)出的數(shù)據(jù)</param>
        /// <param name="customColumnName">導(dǎo)出需要用到的自定義列名，如果為空催式，取數(shù)據(jù)源的表名</param>
        /// <param name="ExportName">導(dǎo)出的文件名</param>
        /// <returns></returns>
        public static bool OutputToExcel2(System.Data.DataTable dt, string customColumnName = "", string ExportName = "")
        {
            //if (dt == null || dt.Rows.Count == 0) return false; 支持導(dǎo)出空模版
            bool flag = false;

            System.Windows.Forms.SaveFileDialog dlg = new System.Windows.Forms.SaveFileDialog();  //保存文件對(duì)話框
            dlg.Filter = "*.xls|*.xls";                 //過濾文件類型
            dlg.CreatePrompt = false;                   //提示創(chuàng)建文件
            dlg.FileName = ExportName;
            if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                //獲取流對(duì)象
                Stream myStream = dlg.OpenFile();
                //獲取流寫入器對(duì)象
                StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
                string columnTitle = "";
                try
                {
                    //寫入列標(biāo)題 
                    if (customColumnName != "")
                    {
                        columnTitle = customColumnName.Replace(",", "\t");
                    }
                    else
                    {
                        for (int i = 0; i < dt.Columns.Count; i++)
                        {
                            if (i > 0)
                            {
                                columnTitle += "\t";
                            }
                            columnTitle += dt.Columns[i].ColumnName;
                        }
                    }
                    sw.WriteLine(columnTitle);
                    //寫入列內(nèi)容 
                    for (int j = 0; j < dt.Rows.Count; j++)
                    {
                        string columnValue = "";
                        for (int k = 0; k < dt.Columns.Count; k++)
                        {
                            if (k > 0)
                            {
                                columnValue += "\t";
                            }
                            if (dt.Rows[j][k] == null)
                                columnValue += "";
                            else
                                columnValue += dt.Rows[j][k].ToString().Trim();
                        }
                        sw.WriteLine(columnValue);
                    }
                    sw.Close();
                    myStream.Close();
                    flag = true;
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
                finally
                {
                    sw.Close();
                    myStream.Close();
                }
            }
            return flag;
        }