摘要: using Excel = Microsoft.Office.Interop.Excel; Excel.Application excelapp = new Excel.Application(); Excel.Workbook wb = excelapp.Workbooks.Open(excelP 阅读全文
posted @ 2019-11-20 10:58 PrintY 阅读(826) 评论(0) 推荐(0) 编辑
摘要: 1 string filePath = @"C:\Users\yangqinglin\Desktop\test.xlsx"; 2 IWorkbook wk = null; 3 string extension = System.IO.Path.GetExtension(filePath); 4 FileStream fs = File.OpenRead(filePath); 5 if (exten 阅读全文
posted @ 2019-11-20 10:41 PrintY 阅读(1705) 评论(0) 推荐(0) 编辑
摘要: 1 IWorkbook workbook = new XSSFWorkbook(); 2 ISheet sheet = workbook.CreateSheet("-"); 3 IRow row = sheet.CreateRow(0);//标题 4 5 IRow titleRow = row.CreateCell(0); 6 Row.SetCellValue("标题列1"); 7 8 IRow 阅读全文
posted @ 2019-11-20 09:33 PrintY 阅读(1255) 评论(0) 推荐(0) 编辑