READING EMPTY EXCEL SHEET FROM VB.NET
I am trying to make excel automation in VB.NET. The problem is when I read an empty excel sheet it will return F1,F2 ..... as cell headings where the cells are blank. Similarly if I have cells with heading H1, H2, H3 , H4, H5 , H6 , H7 when I read this excel sheet it will return H1 - 7 as column headings, but if H5-H7 are deleted from excel. My Application get H1,H2,H3,H4, and then F6,F8 where these cells are empty.
Please reply early.