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

Question

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 VBNetBut 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

dharmendr · Accepted Answer

Hi DorababuRefer below linkSolved Empty cells skipped ignored while reading data from Excel to DataTable in ClosedXML

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

Read and Import Excel without using OELDB in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us