Hello,
I am trying without success to import an excel document where cells may or may not contain data.
It appears that the importing process completely skips empty cells rather than import them as such, meaning any kind of index based traversal of the data is impossible..
Could you please advise me on how I can maintain the structure of my excel data to retain empty cells, or maybe give an example of the best practice to shift the excel data into a DataTable or other data representation that can be used.
I am using Documents.Excel 12.1
Thanks,
This does not work - rows[index].Cells.Count() returns only the amount of populated cells in the row. How did you resolve this?
Matt,
I have submitted this idea to our Product Management team. Our product team chooses new product ideas for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products, so as trends appear in requested features, we can plan accordingly. Let us know if you have further questions.
Excellent thankyou!
I agree. It would probably be easier to have a method in which you specify how to enumerate the items, such as:
foreach (WorksheetRow row in worksheet.Rows.GetItems(GetRowItems.AllRowsWithData)) { // ... }
I have forwarded this post to the Developer Support Manager to create a feature request on your behalf.
OK i removed the foreach loops and replaced with indexed for loops taking the count of rows and rows[0].cells.Count() as the column count, and it works fine now.
It feels like a bit of a dirty/fuzzy workaround though, and would love to see a more transparent and easier to use method of unpacking excel data in a future update, as I find the excel functions incredibly useful and powerful except for this issue..
But its working which is the main thing,
Thanks for your assistance!!