حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Read Empty (Blank) cell data from Excel using OpenXML in C#

sachin1234

sachin12...

SOLVED CLOSED ACTIVE ANSWERED
User: sachin1234
Posted: on Jun 21, 2019 07:30 AM
Forum: Data Controls
Replies: 2
Views: 17466

// how to find Empty cell data

foreach (Cell cell in row.Descendants<Cell>())
{
    dt.Rows[dt.Rows.Count - 1][i] = GetValue(doc, cell);
    i++;
}

Download FREE API for Word, Excel and PDF in ASP.Net

pandeyism

pandeyis...

0 1

Reply
User: pandeyism
Replied: on Jun 21, 2019 07:47 AM
Report

I will get back soon.

pandeyism

pandeyis...

0 2

Reply
User: pandeyism
Replied: on Jun 21, 2019 08:20 AM
Report

Refer below links -

https://stackoverflow.com/questions/36100011/c-sharp-open-xml-empty-cells-are-getting-skipped-while-getting-data-from-excel

https://social.msdn.microsoft.com/Forums/office/en-US/290c0818-1fdd-4e7b-9a35-229d6d00ce83/while-exporting-excel-data-into-c-datatable-using-documentformat-assembly-ignores-blank-cells?forum=oxmlsdk

https://stackoverflow.com/questions/3837981/reading-excel-open-xml-is-ignoring-blank-cells/3981249

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

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.