随笔分类 -  Excel

摘要：NPOI helper 1 using System; 2 using System.Collections.Generic; 3 using System.Linq; 4 using System.Text; 5 using NPOI.SS.UserModel; 6 using System.IO 阅读全文

摘要：/// /// 读取EXCEL数据 /// /// /// public static System.Data.DataSet ExcelToDS(string Path) { s... 阅读全文

摘要：function ExportExcel() { var oXL = new ActiveXObject("Excel.Application"); //创建excel应用程序对象 var oWB = oXL.Workbooks.Add(); //创建工作簿 var oSheet = oWB.Act 阅读全文

摘要：Workbook workbook = new Workbook(); //工作簿 Worksheet sheet = workbook.Worksheets[0]; //工作表 sheet.Cells["A1"].PutValue("value", true); sheet.Cells["A1"] 阅读全文

摘要：把Excel 列号数字变成字母 private static string ToName(int index) { if (index chars = new List(); do { ... 阅读全文

摘要：public void ExportExcel() { Workbook workbook = new Workbook(); //工作簿 workbook.Worksheets.Clear(); workbook.Worksheets.Add("New Worksheet1");//New Work... 阅读全文