Webmaster Forum - View Single Post

SuperDooper · 12-19-2003, 06:26 AM

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.

12-19-2003, 06:26 AM	#1 (permalink)
SuperDooper Junior Member Join Date: 10-21-03 Posts: 5 iTrader: 0 / 0% Latest Blog: None	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.