For the attached file
Sheet.Cells.Columns.Count is always 0.
Can you please help me with that?
As I have 3 columns in the file.
But still somehow I can read my data.
I tried with latest dll for Aspose.Cells.
(And sorry for fake name for my account)
Thanks for your posting and using Aspose.Cells.
Please use Sheet.Cells.MaxColumn property instead,. It will give you correct column count.
But I need enumerator/Collection for Columns.
And funny thing is Sheet.Cells.Columns.Count works for some files.
Another question is that does MaxDataRow property works fine?
And last question what should I do to remove trailing empty rows?
DeleteBlankRows() does not delete trailing rows. (I guess it loops through MaxDataRow not MaxRow)
Do you have any known issues with that?
Sorry To say but, if I keep pressing enter after the last row MaxRow get increased for me.
If I have data in row 10(index 10) and i press enter 3 times it increases MaxRow to 13.
You are Right, My Bad.
But when I add border and use DeleteBlankRows()
It does not delete trailing empty rows.
Please See the attachments.(Values for MaxRow and MaxDataRow)
But that doesn’t help developers.
Doesn’t matter where is the blank row DeleteBlankRows should delete all the blank rows(Keeping in mind the formatting)
Then Why It Deletes Cells From middle of the table.
I have Border over there too.
It makes no sense.
Please Reply Soon…