Excel

Elo

Hi Everybody,

I would like to create an Excel file from Axapta. I made a dialog to ask users some information and the file name.
Before this modification, I made a TXT file. I declared it as this:
ClassDeclaration:
ASCIIO fichier
Filename nomFichier
Run:
fichier = new ASCIIO(nomfichier + ".txt", "w").

Now, I would like to obtain an excel file. How can I do to declare this file?

Thank you,

Elo

vijaybhat

ELO ! it is not clear whether you want to create an Excel file or export/import from Axapta to Excel!! if it is only Export/Import of Axapta to Excel . Check the option under Administration/Periodic- Data Import/Export

kgaurav

Hi Elo,

Please clarify that if your requirement is excel or a ascii text file , because AsciiIo or CommaIo are used for text file, If you need to create a excel file you will require to create it throgh COM and COMVariant classes.

Hope it will help

Kgaurav

Harish

Hi Elo,

As other users posted, I am not clear what you are trying to achieve here. May be you would like to check the few jobs that are there in my website -

http://www.harishm.com/Navision/Code.html

Regards,

Harish Mohanbabu