Reading an Empty Excel Row

Hello,

I have devoloped a Class wich allow read and write an Excel 2007 file(Using OpenXml). The issue is when empty cells values come into the file, openxml methods ignore that cell. i.e: I have the follwing Excel Structure:
A1=Empty
B1=0
C1=Empty

A2=0
B2=Empty
C2=0

When openxml method(worksheetPart.Worksheet.Descendants(Of Row)().Where(Function(r) i = r.RowIndex).FirstOrDefault()) read the row, the result is cell B1 for the first row and cells A2 and C2 for the sencond.

I will apreciate your help.

Allis Montenegro
Computer System Engineer

I found the solution. If someone has the same problem feel free to post here the question and I will response as quick as I can.

Allis

Please provide the solution of this problem. I have been facing the same issue.

Thanks in advance !!

hi there,
i did a post from that. You can visit here:
http://openxmldeveloper.org/forums/post/8696.aspx. Let me know if it was useful or if you have doubts.

Thanks alot, it worked.