C# dataGridView数据导出Excel 单元格格式设置-求哥哥姐姐们教教小弟我

C# dataGridView数据导出Excel 单元格格式设置------求哥哥姐姐们教教我

        /// DataGridView中绑定的是一个DataTable

        /// </summary>

        /// <param name="grid">DataGridView</param>

        /// <param name="ExcelTitle">Excel标题</param>

        public static void ToExcel(DataGridView grid)

        {

            //System.Data.DataTable mytable = (System.Data.DataTable)grid.DataSource;

            System.Data.DataTable mytable = (grid.DataSource as DataSet).Tables[0];

            try

            {

                Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass();

                int rowIndex, colIndex;

                rowIndex = 1;

                colIndex = 0;

                Microsoft.Office.Interop.Excel.Workbook xlBook = xlApp.Workbooks.Add(true);

                if (grid.Rows.Count > 0)

                {

                    foreach (DataGridViewColumn colu in grid.Columns)

                    {

                        if (colu.Visible)

                        {

                            colIndex = colIndex + 1;

                            xlApp.Cells[1, colIndex] = colu.HeaderText;

                        }

                    }

                    for (int row = 0; row < mytable.Rows.Count; row++)

                    {

                        rowIndex = rowIndex + 1;

                        colIndex = 0;

                        for (int col = 0; col < grid.Columns.Count; col++)

                        {

                            if (grid.Columns[col].Visible)

                            {

                                colIndex = colIndex + 1;

                                if (grid.Columns[col].CellType.Name == "DataGridViewComboBoxCell")

                                    xlApp.Cells[rowIndex, colIndex] = grid.Rows[row].Cells[col].FormattedValue;

                                else