DAO.net基础（二）——导出Excel文件

来源：互联网发布：java继承和多态例子编辑：程序博客网时间：2024/05/24 01:42

以下代码是为了搞定将datagridview中数据导出为Excel文件，而封装的类：

namespace TEST{    class DaoChuExcel    {        public static void ExportExcel(DataGridView myDGV,string sheetName)        {            SaveFileDialog sfd = new SaveFileDialog();            sfd.Filter = "Excel文件|.xls";            if (sfd.ShowDialog() != DialogResult.OK)            {                return;            }            string filename = sfd.FileName;            HSSFWorkbook workbook = new HSSFWorkbook();            ISheet sheet1 = workbook.CreateSheet(sheetName);            //以下三行代码实现Excel表单第一行标题；            IRow header = sheet1.CreateRow(0);            header.CreateCell (0,CellType.STRING).SetCellValue("编号");            header.CreateCell (1,CellType.STRING).SetCellValue("分类");            header.CreateCell (2,CellType.STRING).SetCellValue("地址");            //将datagridview空间的数据转化为datatable；            DataTable goodinfos = myDGV.DataSource as DataTable;            //初始化每一行的索引；            int rowIndex = 1;            foreach (DataRow row in goodinfos.Rows)            {                IRow goodinfo = (HSSFRow)sheet1.CreateRow(rowIndex);                foreach (DataColumn column in goodinfos.Columns)                {                    goodinfo.CreateCell(column.Ordinal).SetCellValue(row[column].ToString());                }                rowIndex++;            }                        using(Stream stream =File.OpenWrite(filename))            {                workbook.Write(stream);            }        }    }}

0 0