Printable View
Iam trying to populate an Excel sheet using the COM MS Excel Lib10.0 using the following code:
Excel.Application a = new Excel.Application();
Excel.Workbook wb = a.Open ("C:\book1.xls");
Excel.Worksheet ws = wb.Worksheets.Item (1);
ws. Cells [2, 1].value = "YOUR STRING VALUE";
ws. Cells[ 2, 2].value = "YOUR STRING VALUE";
I get errors in the underlined lines. Help me out?
:eek:
On Pressing F5
There were builder errors, continue?
The following or the errors for the underlined lines >>
1. For a.open: Excel.Application does not contain a definition for open.
2. For Item: Provider Indexer or event item not supported by the language.
3. For Cells: Object does not contain a definition for values.
When I modified the last lines, I dont get the last error(3)
ws.Cells[2, 1] = "YOUR STRING VALUE";
ws.Cells[2, 2] = "YOUR STRING VALUE";
This is the recent code:
Excel.Application a=new Excel.ApplicationClass();
Excel.Worksheet ws=new Excel.WorksheetClass();
Excel.WorkbookClass wb;
Excel.Application a=new Excel.ApplicationClass();
wb = (Excel.WorkbookClass)a.Workbooks._Open("C:\\book1.xls",true,true,"mm","","",true,true,".",true,false ,true,true);
ws = (Excel.Worksheet)wb.Worksheets[1];
ws.Cells[2, 1] = "Date";
ws.Cells[2, 2] = "Location";]
I have a run-time error only in the underlined line:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in vcexcel1.exe
Additional information: COM object with CLSID {00020819-0000-0000-C000-000000000046} is either not valid or not registered.
Any help?