NPOI

来源：互联网发布：制作linux启动u盘编辑：程序博客网时间：2024/05/22 12:54

1、创建一个excel

            using (FileStream file = File.OpenWrite("test.xls"))            {                //创建一个工作薄                HSSFWorkbook workbook = new HSSFWorkbook();                //创建sheet                workbook.CreateSheet("第一个");                workbook.CreateSheet("第二个");                workbook.CreateSheet("第三个");                workbook.Write(file);            }

2、写入数据

            using (FileStream file = File.OpenWrite("test.xls"))            {                //创建工作薄                HSSFWorkbook workbook = new HSSFWorkbook();                //创建sheet                ISheet sheet = workbook.CreateSheet("mysheet");                //创建行                IRow row = sheet.CreateRow(4);                //创建列                ICell cell = row.CreateCell(3);                cell.SetCellValue(DateTime.Now.ToShortDateString());                workbook.Write(file);            }

3、导出数据到excel

            string sql = "select * from RoomInfo";            using (FileStream file = File.OpenWrite("test.xls"))            {                IWorkbook workbook = new HSSFWorkbook();                ISheet sheet = workbook.CreateSheet("RoomInfo");                using (SQLiteDataReader reader = SQLiteHelper.ExecuteReader(sql))                {                    for (int i = 0; reader.Read(); i++)                    {                        IRow row = sheet.CreateRow(i);                        for (int j = 0; j < reader.FieldCount; j++)                        {                            object o = reader[j];                            ICell cell = row.CreateCell(j);                            switch (o.GetType().Name.ToLower())                            {                                case "int16":                                case "int32":                                case "int64":                                case "byte":                                case "sbyte": cell.SetCellValue(Convert.ToInt64(o)); break;                                case "string": cell.SetCellValue(o.ToString()); break;                                default:                                    cell.SetCellValue(o.ToString());                                    break;                            }                        }                    }                }                workbook.Write(file);            }

0 0