Sunday, September 23, 2012 3:18 PM
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
- Edited by Alok c Shahi Monday, September 24, 2012 5:03 AM
Tuesday, September 25, 2012 6:07 AMModerator
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
Bob Wu [MSFT]
MSDN Community Support | Feedback to us
- Marked As Answer by Mike Dos ZhangMicrosoft Contingent Staff, Moderator Tuesday, October 09, 2012 9:05 AM
- Unmarked As Answer by Alok c Shahi Sunday, October 14, 2012 5:57 PM
- Marked As Answer by Alok c Shahi Sunday, October 14, 2012 5:59 PM
Sunday, October 14, 2012 5:58 PM
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