CExcelClass
-
Hi , Whlie we have hot technology (the COM's, D-COM's etc etc) I am often need to simply take a MS-Excel spreadsheet and 'import' data to my application. There are a few articles on this, but in each it seems either Very 'complicated' eg setup odbc, or has limitations like having to hard-code the number of columns or having to name a range. What I really need is a class that .OpenXLS file and then you can .GetAt(Sheet,row,col) .SetAt(Sheet,row,col) Regards
-
Hi , Whlie we have hot technology (the COM's, D-COM's etc etc) I am often need to simply take a MS-Excel spreadsheet and 'import' data to my application. There are a few articles on this, but in each it seems either Very 'complicated' eg setup odbc, or has limitations like having to hard-code the number of columns or having to name a range. What I really need is a class that .OpenXLS file and then you can .GetAt(Sheet,row,col) .SetAt(Sheet,row,col) Regards
There's an article on working with excel com objects in the April 2000 edition of C/C++ Users Journal - looks like there are workbook and worksheet interfaces that would do what you need and more.