基于UniExcel插件,封装了一个属于自己的类,来实现对于Excel表格的...

来自 : www.voidcn.com/code/p-padebbgk 发布时间：2021-03-24

FileStream MyAddressRead = new FileStream(path, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite); HSSFWorkbook MyWorkbookRead = new HSSFWorkbook(MyAddressRead); HSSFSheet Sheet = (HSSFSheet)MyWorkbookRead.GetSheet(\"Sheet1\"); for (int row = 0; row Sheet.LastRowNum; row++) { IRow RowRead = Sheet.GetRow(row); List rows = new List (); for (int cell = 0; cell RowRead.LastCellNum; cell++) { rows.Add(RowRead.GetCell(cell).ToString()); } table.Add(rows); } return table; } /// /// 用于编辑Excel 97-2003(.xls)类型文件 /// ///

Excel文件路径 ///

要修改的Excel表格单元所在行 ///

要修改的Excel表格单元所在列 ///

修改后的值 public static void EditExcelXls(string path,int row,int col,string value) { FileStream MyAddressEdit=null; MyAddressEdit = new FileStream(path, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite); HSSFWorkbook MyWorkbookEdit = new HSSFWorkbook(MyAddressEdit); HSSFSheet Sheet = (HSSFSheet)MyWorkbookEdit.GetSheet(\"Sheet1\"); HSSFRow Row = (HSSFRow)Sheet.GetRow(row); HSSFCell cell = (HSSFCell)Row.GetCell(col); cell.SetCellValue(value); MyAddressEdit = new FileStream(path, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite); MyWorkbookEdit.Write(MyAddressEdit); MyWorkbookEdit.Close(); } /// /// 创建Ecxel 97-2003(.xls)类型文件 /// ///

Excel文件路径 ///

用于创建的数据 public static void CreateExelXls(string path, List table) { HSSFWorkbook MyWorkbookCreate = new HSSFWorkbook(); HSSFSheet Sheet = (HSSFSheet)MyWorkbookCreate.CreateSheet(\"Sheet1\"); for (int row = 0; row table.Count; row++) { HSSFRow Row = (HSSFRow)Sheet.CreateRow(row); for (int col = 0; col table[row].Count; col++) { HSSFCell cell = (HSSFCell)Row.CreateCell(col); cell.SetCellValue(table[row][col]); } } FileStream MyAddressCreate = new FileStream(path, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite); MyWorkbookCreate.Write(MyAddressCreate); MyAddressCreate.Close(); } /// /// 获取Ecxel 97-2003(.xls)类型文件中的具体一个单元格 /// ///

Excel文件路径 ///

单元所在行 ///

单元所在列 /// 单元格的内容转为string类型输出 public static string GetExcelXlsCell(string path,int row, int col) { FileStream MyAddressRead = new FileStream(path, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite); HSSFWorkbook MyWorkbookRead = new HSSFWorkbook(MyAddressRead); HSSFSheet Sheet = (HSSFSheet)MyWorkbookRead.GetSheet(\"Sheet1\"); HSSFRow Row = (HSSFRow)Sheet.GetRow(row); HSSFCell cell = (HSSFCell)Row.GetCell(col); return cell.ToString(); } }