How to import Excel data using C++?

0 ⤊

How to import Excel data using C++?

2006-07-12 00:30:12 · 2 answers · asked by anurag g 1 in Computers & Internet ➔ Programming & Design

Not sure if a C# sol will do... send what you have... Will come back for help if this doesnt work...

2006-07-12 01:14:28 · update #1

2 answers

You can create an OleDb connection string for an Excel file by doing something like this:

string ConnStr = "Provider=" +
"Microsoft.Jet.OLEDB.4.0;Data"
+ " Source=" + ExcelFilePath +
";Extended " +
"Properties=\"Excel " +
"8.0;HDR=Yes;IMEX=2\"";

....where "ExcelFilePath" is the physical path to the file. Then just populate a DataTable like you would with any other ado.net data source.

2006-07-12 01:41:34 · answer #1 · answered by evolver 6 · 0⤊ 0⤋

would a c# solution be acceptable???

2006-07-12 00:37:15 · answer #2 · answered by ralphd42 2 · 0⤊ 0⤋