How to read excel file of 2003,2007,2010 in 32 bit or 64bit windows operating system?

Question

i want to write a single code to read data from excel file.Code must support 32 bit and 64 bit operation system both and it should support all version of excel i.e 2003,2007,2010 too.

so please help me to write this code or give me any code that will satisfy my conditions.Is there any open source code or application that read excel files without any problem?

i want this code either in vb.net or C#. It is urgent

Answer 1

Hi Alok,

There are many ways to read a excel file. For example, you can JET OLEDB provider or ACE OLEDB provider.

Both of these two providers support excel 2003,2007 and 2010.

You can set the target platform to x86, so the application will run as 32bit application on both 32bit and 64bit operating system.

For more details, see 

http://blogs.msdn.com/b/farukcelik/archive/2010/06/04/accessing-excel-files-on-a-x64-machine.aspx

http://www.codeproject.com/Articles/8500/Reading-and-Writing-Excel-using-OLEDB

http://www.microsoft.com/en-us/download/details.aspx?id=13255

http://msdn.microsoft.com/en-us/library/ms175866%28v=sql.105%29.aspx

Best Regards,

---

Bob Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Bob 

it works but i am unable to publish my exe using click once because i am using few dlls targeted to any cpu platform. and my current application targeting to x86 any suggestion