Hi,
I am using aspose cells V4.8.0.4.
I wanted to delete blank rows and columns in excel sheet. So i used oExcelSheet.Cells.DeleteBlankRows() and oExcelSheet.Cells.DeleteBlankColumns() methods. But it deletes the data in excel sheet.
Herewith i have attached sample xls file and the output xls (NFLX0049_00001850.nor.xls) file.
code snippet:
Dim oExcelBook As Workbook = New Workbook
oExcelBook.Open(strinput)
Dim inti As Int32
For inti = 0 To oExcelBook.Worksheets.Count - 1
Dim oExcelSheet As Worksheet = oExcelBook.Worksheets(inti)
oExcelSheet.UnFreezePanes()
oExcelSheet.Cells.DeleteBlankRows()
oExcelSheet.Cells.DeleteBlankColumns()
Next
oExcelBook.Save(strOutPath)
Regards,
Karthik