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.