DataGrid accessing and Excel 11.0 Object Library
Does anyone know how to export DataGrid, DataView, or DataSet data into an excel spreadsheet using the Microsoft Excel 11.0 Object Library? I saw the guide on how to do it with the 9.0 on the site, but 11.0 is different. If you cant tell me how to do it with 11.0, do you know if it is illegal to use the file EXCEL9.OLB if I didnt purchase excel 2000? (the project is for work)
If nobody can tell me how to export data using 11.0, can you at least tell me how to do this with a DataGrid, DataSet, or DataView:
1. Get total number of columns and rows
2. Get cell color and cell text color in a DataGrid
3. Access individual columns in a DataGrid by an index. I.E. if it was in a for loop: dataGrid.Column[i] (obviously incorrect syntax)