Excel操作之 导出生成多个sheet页面

使用NPOI创建Excel
本文介绍了一种利用NPOI库在C#中创建Excel文件的方法。文章详细阐述了如何初始化工作簿、创建多个工作表、设置表头以及填充数据。此外,还提供了完整的示例代码供读者参考。
首先需要下载一个NPOI.dll  
下载地址:http://download.youkuaiyun.com/detail/president810/9503038

using
System; using System.Collections.Generic; using System.IO;
//引用NPOI
using NPOI.HSSF.UserModel; using NPOI.SS.UserModel; namespace Sola.ExportTakeClass { public class ExportToExcelUtil { private string _excelPath = ""; private IWorkbook workbook; private ISheet sheet; private int row = 0; private IList<string> sheetList = new List<string>(); public ExportToExcelUtil(string excelPath,IList<string> sheetList) { _excelPath = excelPath; this.sheetList = sheetList; ExcelFormat(); } /// <summary> /// 遍历sheet 并添加到excel /// </summary> private void ExcelFormat() { try { workbook = new HSSFWorkbook(); foreach (var sheetname in sheetList) { workbook.CreateSheet(sheetname); } } catch { GC.Collect(); GC.Collect(1); } } /// <summary> /// 将头部列表添加至 指定的sheet页 /// </summary> /// <param name="titleList"></param> /// <param name="sheetName"></param> public void SetHead(IList<string> titleList,string sheetName) { row = 0; sheet = workbook.GetSheet(sheetName); IRow headerRow = sheet.CreateRow(row); int col = 0; foreach (string t in titleList) { headerRow.CreateCell(col).SetCellValue(t); col++; } } /// <summary> /// 将数据写入指定的 sheet页 /// </summary> /// <param name="valueList"></param> /// <param name="sheetName"></param> public void WriteExcel(IList<string> valueList, string sheetName) { int col = 0; sheet = workbook.GetSheet(sheetName); row++; IRow itemRow = sheet.CreateRow(row); foreach (string v in valueList) { itemRow.CreateCell(col).SetCellValue(v); col++; } } public void Close() { try { FileStream file = new FileStream(_excelPath, FileMode.Create); workbook.Write(file); file.Close(); workbook.Clear(); } finally { GC.Collect(); GC.Collect(1); } } } }

 

转载于:https://www.cnblogs.com/president/p/406bac494dab3ca04f704e27e4aed3ae.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值