public NH_Sheet(string path, string sheetName) { HSSFWorkbook wb = NPOIHssfEx.ToWorkBook(path); HSSFSheet hsheet = NPOIHssfEx.GetSheet(wb, sheetName); DoInit(wb, hsheet); this.pathFile = path; }
public HSSFRow GetRow(int rowIndex, bool isNew = false) { HSSFRow ret = NPOIHssfEx.GetRow(m_sheet, rowIndex); if (isNew && ret == null) { ret = NPOIHssfEx.CreateRow(m_sheet, rowIndex); } return(ret); }
public HSSFWorkbook ToWorkbook(bool isNew = false) { this.m_preWb = this.m_wb; if (isNew) { this.m_wb = new HSSFWorkbook(); this.m_sheet = NPOIHssfEx.CreateSheet(this.m_wb, this.sheetName); } int lens = m_tableList.Count; for (int i = 0; i < lens; i++) { SaveValueToExcel(m_tableList[i]); } return(this.m_wb); }
public HSSFCell GetCell(int rowIndex, int columnIndex, bool isNew = false) { HSSFCell ret = null; try { ret = NPOIHssfEx.GetCell(m_sheet, rowIndex, columnIndex); } catch (System.Exception ex) { Debug.LogError("rIndex = " + rowIndex + ",cIndex = " + columnIndex + "\n" + ex); } if (isNew && ret == null) { HSSFRow row = GetRow(rowIndex, isNew); ret = NPOIHssfEx.CreateCell(row, columnIndex); } return(ret); }
public NH_Sheet(HSSFWorkbook wb, string sheetName) { HSSFSheet hsheet = NPOIHssfEx.GetSheet(wb, sheetName); DoInit(wb, hsheet); }
public NH_Sheet(HSSFWorkbook wb, int sheetIndex) { HSSFSheet hsheet = NPOIHssfEx.GetSheet(wb, sheetIndex); DoInit(wb, hsheet); }