I am using the latest Aspose.dll
I would like to create an excel file from a text file and save it.
The code below created a spreadsheet with the correct values in the cells.
When it saves the excel file, the file/spreadsheet is empty.
Here is the code:
Dim outsheet As New Spreadsheet(physicalPathTxt)
outsheet.Save(physicalPathXls) .
Public Sub New(ByVal fileName As String)
Dim loadOps As TxtLoadOptions = New TxtLoadOptions(LoadFormat.TabDelimited)
loadOps.ConvertNumericData = False 'do not strip leading zeros
workbook = New Workbook(fileName, loadOps)
Dim cells As Cells = workbook.Worksheets(vcurrentSheet).Cells
Dim maxcell = cells.MaxRow 'gives correct number of rows
Dim maxcolumn = cells.MaxColumn 'gives correct number of column
Dim firstcell = cells(0, 0).StringValue 'gives correct value
End Sub
Thank you