Thanx a lot for ur help!
However, I'm unable to use the COMVariant part of ur code;
especially the part where
COMVariant1.bStr(xinfo::directory(directoryType::Appl)
+ 'C:\\SatishExcelTest.xls);
The compilation of this line was giving a syntax error. I'm really
new to Axapta, so i couldn't get it cleared... :(
Can u suggest a remedy for this? :)
Thanks,
Satish
--- In development-axapta@yahoogroups.com, Mikael Dalgård (GPV
International A/S) <[EMAIL PROTECTED]> wrote:
>
> Hi there
>
> 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: development-axapta@yahoogroups.com [mailto:development-
[EMAIL PROTECTED] På vegne af cod
> Sendt: 20. marts 2006 21:33
> Til: development-axapta@yahoogroups.com
> 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.