I have a question about Excel application/ Axapta.
As in the source code included down below - I'm able to set data into a Excel cell - but how can I get data from a Excel cell into Axapta ????
I would be very pleased, if you could give me an example
br. Mikael Dalgård
----
static void Job2(Args _args)
{
PurchTable purchtable;
PurchLine purchline;
InventTable inventtable;
VendTable vendtable;date DateVar; Container L1; int i,j; str OutPutStr, OutPutFileName,OutPutMailFrom;
SysExcelApplication SysExcelApplication; SysExcelWorksheet SysExcelWorksheet; SysExcelWorksheets SysExcelWorksheets; SysExcelWorkbooks SysExcelWorkbooks; SysExcelWorkbook SysExcelWorkbook; SysExcelRange SysExcelRange; SysExcelCell SysExcelCell; SysExcelCells SysExcelCells;
COMVariant COMVariant1;
#excel SysMailer mailer = new SysMailer(); ;
sysExcelApplication = SysExcelApplication::construct();
sysExcelApplication.visible(true);
sysExcelWorkbooks = sysExcelApplication.workbooks();
// for filename
COMVariant1 = new COMVariant();
COMVariant1.bStr("D:\\temp\\excel\\input.xls");
sysExcelWorkbook = sysExcelWorkbooks.add(COMVariant1);
SysExcelWorksheets = sysExcelWorkbook.worksheets();
SysExcelWorksheet = SysExcelWorksheets.itemFromNum(1);
SysExcelRange =
SysExcelWorksheet.cells().range(#ExcelTotalRange);
i = 5;
SysExcelCell = SysExcelWorksheet.cells().item(i,2);
SysExcelCell.value(10);
}Yahoo! Groups Sponsor ADVERTISEMENT
click here
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
