We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Creating excel sheet from text file and saving

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

@shif,

Thanks for the details.

Please zip and attach your input text file and output Excel file, we will check it soon.

Attached is the zipped text file. The output file is just an empty excel file
.Test file.7z (8.6 KB)

Thank you

It’s working correctly now. Thank you.

@shif,

Thanks for the input text file.

I did test your scenario/case using latest Aspose.Cells for .NET version by simply opening your text file and saving to XLSX file format via Aspose.Cells APIs, it works fine. The output XLSX is fine tuned and is not empty.

It looks like your issue is sorted out now. In the event of further queries or issue, feel free to write us back.