Possible to get string version of ExcelRow?

GemBox.Spreadsheet
1

we’re iterating through the rows of an GemBox.Spreadsheet.ExcelWorksheet object.

For Each objRow As GemBox.Spreadsheet.ExcelRow In objExcelWorksheet.Rows

it was loaded from a tab/csv delimited file. is it possible to get the string representation of that line:
i.e. field1,field2,field3 as a string? looking to output the text version of the line for error reporting.

thanks,

2

Hi Anthony,

Hi,

No, that information is not stored in the ExcelRow object.

You could perhaps try recreating it, like this:

Dim line As String = String.Join(","c, objRow.AllocatedCells.[Select](Function(c) c.Value?.ToString()))

I hope this helps.

Regards,
Mario