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);
}
