writing to excel file

[little_johny]

i have tried almost every possible way to write to an excel but no success
if anybody can guide where i am going wrong. here is the code. thanks

excel = new ActiveXObject("Excel.Application");
excel.Visible = true;
excel.Workbooks.Add();

// Bind to worksheet.
objSheet = excel.ActiveWorkbook.Worksheets(1);
objSheet.Name = "User Groups";

//objSheet.Cells.Item(2, 2).value = "Last Name"
//objSheet.ActiveSheet.Cells(1, 1) = "Last Name"
//objSheet.worksheets("User Groups").Range("A1").Value = "Last Name"
//objSheet.Range("A1").Value = "Last Name"
//objSheet.ActiveSheet.Range("A1").Value = "Last Name"

excel.ActiveWorkbook.SaveAs("c:\\test.xls");

excel.quit();

[SWFKit]

We will test it and try to resolve the problem.

[little_johny]

???

[SWFKit]

Please use the "value2" property instead. The "value" property has two parameters since excel 2002.

[little_johny]

i tried to use "value2" property also, but no results.
i would appreciate if you could post the edited the code for me.

thanks in advance

[SWFKit]

objSheet.Cells.Item(2, 2).value2 = "Last Name"

[little_johny]

thanks for this.

but now why this does not work

objSheet.Shapes.AddPicture("c:\\test.jpg", false, true, 160, 40, 70, 70);