|
That's a good example, but you don�t have code for
open and working with an existing excel worksheet ??
Regards
----- Original Message -----
Sent: Wednesday, April 21, 2004 2:24
PM
Subject: [development-axapta] Re: COM
Excel.Application
Custtable ct;
int
row = 1;
COM excelApp, workbooks, excelCell,
excelWorkSheet, workbook;
;
excelApp = new
COM("Excel.Application");
if
(excelApp)
{
workbooks =
excelApp.Workbooks();
workbooks.add();
excelWorkSheet =
excelApp.ActiveSheet();
while select
ct
{
excelCell = excelWorkSheet.Range(StrFmt("A%1",
row));
excelCell.value(StrFmt("%1",ct.AccountNum));
excelCell = excelWorkSheet.Range(StrFmt("B%1",
row));
excelCell.value(ct.Name);
row++;
}
}
workbook =
excelApp.ActiveWorkbook();
workbook.SaveAs("c:\\temp\\test.xls");
workbooks.close();
--- In [EMAIL PROTECTED],
"gonzalo_edo" <[EMAIL PROTECTED]>
wrote:
> Does anybody know where can
I find any documentation about using
> Excel.Application COM
>
> Or anybody has an example to connect Excel with Axapta
>
> Regards
Yahoo! Groups Links
|
