facebooktwittermenuarrow-up

GemBox Support Forum

Possible to get string version of ExcelRow?

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,

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