public static void TestCodeGen()
{
string fileName = Application.dataPath + "/Tests/Editor/Test1.xlsx";
IWorkbook workbook = ExcelHelper.Load(fileName);
EDReader reader = new EDReader(workbook);
ISheet dataSheet = workbook.GetSheetAt(0);
Debug.Log(dataSheet.FirstRowNum + "," + dataSheet.LastRowNum);
IRow row = dataSheet.GetRow(0);
Debug.Log(row.FirstCellNum + "," + row.LastCellNum);
row = dataSheet.GetRow(1);
Debug.Log(row.FirstCellNum + "," + row.LastCellNum);
row = dataSheet.GetRow(2);
Debug.Log(row.FirstCellNum + "," + row.LastCellNum);
}
public static void TestCell()
{
string fileName = Application.dataPath + "/Tests/Editor/Test.xlsx";
IWorkbook workbook = ExcelHelper.Load(fileName);
EDReader reader = new EDReader(workbook);
ISheet dataSheet = workbook.GetSheetAt(0);
IRow row = dataSheet.GetRow(0);
for (int i = row.FirstCellNum; i < row.LastCellNum; ++i)
{
ICell cell = row.GetCell(i);
if (cell.Hyperlink != null)
{
Debug.LogFormat("Hype:{0},{1},{2},{3},{4},{5}", cell.Hyperlink.Label, cell.Hyperlink.Address, cell.Hyperlink.FirstRow, cell.Hyperlink.FirstColumn, cell.Hyperlink.LastRow, cell.Hyperlink.LastColumn);
}
Debug.LogFormat("Cell:{0},{1}", cell.CellType, cell.ColumnIndex);
}
}