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

Free Support Forum - aspose.com

Spreadsheet created from file with hidden rows

The code below created a spreadsheet from a file.
The rows with data were hidden so I added code to unhide the rows. It did not help and the rows remain hidden. Why did it create the rows of data as hidden rows?

Here is the constructor code that creates the spreadsheet:

Public Sub New(ByVal fileName As String)
Dim loadOps As TxtLoadOptions = New TxtLoadOptions(LoadFormat.TabDelimited)
loadOps.ConvertNumericData = False 'do not strip leading zeroes from numeric data stored as text
workbook = New Workbook(fileName, loadOps)
Dim maxrow As Integer = workbook.Worksheets(vcurrentSheet).Cells.MaxDataRow
Dim rowheight As Double = workbook.Worksheets(vcurrentSheet).Cells.GetRowHeight(1)

    Dim I As Integer
    For I = 0 To workbook.Worksheets(vcurrentSheet).Cells.MaxDataRow
        workbook.Worksheets(vcurrentSheet).Cells.UnhideRow(I, 15)
    Next I
End Sub

Thank you.


Please share your input file and output Excel file. Your sample code is not complete, we do not know how you are saving the file, so please share your complete sample code to generate the output file. We will check your issue soon.

PS. please zip the files prior attaching.


Please try our latest version v22.3, the issue should be fixed.