Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
755
Problem importing Excel data with empty Cells
posted

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, 

Parents Reply Children
No Data