FOR COLUMN B I like to calculate the last filled row or last row.
So I can do
sheet.Range["B4:B"+ last row].NumberFormat = "mm/dd/yyyy hh:mm:ss AM/PM";
string xlsPath = @"sample.xlsx";
Workbook workbook = new Workbook();
workbook.LoadFromFile(xlsPath);
Worksheet sheet = workbook.Worksheets[0];
// sheet.LastRow returns the last row of the sheet.
int lastFilledRow = sheet.LastRow;
for (int i = sheet.LastRow; i >=0; i--)
{
CellRange cr =sheet.Rows[i-1].Columns[1];
if (!cr.IsBlank)
{
lastFilledRow =i ;
break;
}
}
//to find the last filled row of this column
sheet.Range["B4:B"+ lastFilledRow ].NumberFormat = "mm/dd/yyyy hh:mm:ss AM/PM";
workbook.SaveToFile("12153.xlsx",ExcelVersion.Version2013);