Try this :-)
SysExcelApplication SysExcelApplication;
SysExcelWorksheet SysExcelWorksheet;
SysExcelWorksheets SysExcelWorksheets;
SysExcelWorkbooks SysExcelWorkbooks;
SysExcelWorkbook SysExcelWorkbook;
SysExcelRange SysExcelRange;
SysExcelCell SysExcelCell;
SysExcelCells SysExcelCells;
COMVariant COMVariant1;
#excel
;
sysExcelApplication = SysExcelApplication::construct();
sysExcelApplication.visible(false);
sysExcelWorkbooks = sysExcelApplication.workbooks();
COMVariant1 = new COMVariant();
COMVariant1.bStr(xinfo::directory(directoryType::Appl) + 'your filename.xls');
sysExcelWorkbook = sysExcelWorkbooks.add(COMVariant1);
SysExcelWorksheets = sysExcelWorkbook.worksheets();
SysExcelWorksheet = SysExcelWorksheets.itemFromNum(1);
SysExcelRange = SysExcelWorksheet.cells().range(#ExcelTotalRange);
SysExcelCell = SysExcelWorksheet.cells().item(1,1);
SysExcelCell.value("put in you value here");
Best regards
Mikael Dalgaard
-----Oprindelig meddelelse-----
Fra: [email protected] [mailto:[EMAIL PROTECTED] På vegne af cod
Sendt: 20. marts 2006 21:33
Til: [email protected]
Emne: Re: [development-axapta] Working with Excel through Axapta
On 20/03/06, Satish <[EMAIL PROTECTED]> wrote:
>
> Hi guys,
>
> I have a situation where i need to open,edit and save excel files
> through forms in Axapta.
>
> I need to allow Excel to do the processing of the data, and then store
> the computed values in Axapta tables.
>
> Thanks in anticipation.
You can import into AXAPTA external COM object of Excel ... try with google
to get example on how invoke excel methods..
cod
[Non-text portions of this message have been removed]
Yahoo! Groups Links
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
