
Hello.
I am trying to retrieve some values from the Excel table in XML format and need some help.
The values under the Table section, such as "ExpandedColumnCount" and "ExpandedRowCount", can be obtained:
Dim spreadSheet = New System.Data.DataSet
spreadSheet.ReadXml(CType(data.GetData("XML Spreadsheet"), System.IO.Stream))
Dim rowCount As Integer = CInt(Int(spreadSheet.Tables("Table").Rows(0)("ExpandedRowCount")))
Dim columnCount As Integer = CInt(Int(spreadSheet.Tables("Table").Rows(0)("ExpandedColumnCount")))
However, I am having trouble accessing the row height values under the Table section.
I am aware that there will be no assigned values unless the height for each row is customized.
So, assuming that the first row has the customized height, how can I retrieve this value?
Thanks in advance.