Read data from excel sheet

Hi Friends

I need to read data from excel sheet. The issue is that the first few rows of the excel sheet are images and buttons...and the data I need to read is start from the 6th row. And also the column names are dates...

I tried oledb object to read data but it’s not worked since the data in the excel sheet are not in the table format... shall I read the data from excel row by row? Is there any solution for my issue? Pls help me

Thanks

Ammooss

re: Read data from excel sheet

I would suggest using Interop.

This should help get you started:
http://msdn.microsoft.com/en-us/libr...86(VS.80).aspx
It's about creating, not reading, but you should be able to figure out how to open a sheet.

http://support.microsoft.com/default.aspx/kb/302084
This might help too.