NPOI
湾头逮虾户
这个作者很懒,什么都没留下…
展开
-
NPOI按模板导出Excel
public void ExportPrjToExcel(int prjId, string excelPath,bool showBox) { IWorkbook wk = null; string templateExcelPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "template.xlsx"); string extension =...原创 2020-08-04 13:58:50 · 710 阅读 · 0 评论 -
NPOI读取数据并导入数据库
记录些平时工作时遇到的问题,如有问题,欢迎指出~~~ public void ImportPrjFromExcel(int prjId, string excelPath) { IWorkbook wk = null; string extension = System.IO.Path.GetExtension(excelPath); try { FileStream fs = File.OpenRead(ex原创 2020-07-27 16:24:27 · 349 阅读 · 0 评论 -
NPOI查询sheet中的某个单元格的值
private string GetOtherSheetStringValue(IWorkbook wk, String sheetName, String location) { ISheet sheet = wk.GetSheet(sheetName); var cr = new CellReference(location); var row = sheet.GetRow(cr.Row);原创 2020-07-27 16:00:24 · 1189 阅读 · 1 评论