Programmatically Reading an Excel Sheet
-
Hi, I have an excel sheet with some data. I need to read these data elements from a VC++ application. How do I do this? What I need to know specifically are: - What component to use for getting access to an excel sheet? - What are the methods exposed by this component which will be useful for this purpose? Any suggestions are welcome. Sample code or URL for the same will be appreciated as well. With best regards, Sayan Mukherjee Email:sayanmukherjee@indiatimes.com
-
Hi, I have an excel sheet with some data. I need to read these data elements from a VC++ application. How do I do this? What I need to know specifically are: - What component to use for getting access to an excel sheet? - What are the methods exposed by this component which will be useful for this purpose? Any suggestions are welcome. Sample code or URL for the same will be appreciated as well. With best regards, Sayan Mukherjee Email:sayanmukherjee@indiatimes.com
I use (Excel) Automation. You can also use ODBC, but I have not personally tried that method.
-
I use (Excel) Automation. You can also use ODBC, but I have not personally tried that method.
If you use ODBC, make sure that you set the cells as a named range in Excel.