OpenXML ignoring blank cell valueI used the following code to convert excel to datatableRead and Import Excel without using OELDB in ASPNet using C and VBNet

[Solved] Empty cells skipped (ignored) while reading data from Excel in ASP.Net using OpenXML

Dorababu

OpenXML ignoring blank cell value

I used the following code to convert excel to datatable

But when I am having any empty cell value it is ignoring that, how to import the data as is even when the cell values are empty.

dharmend...

0 1

Refer below link.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html