hi johannes,
There are 2 ways to convert Axapta data into Excel format.
1)First u can give the file format to HTML and u'll have to give the extension of the file name .xls.Then u'll get a excell file on HTML background.Copy this data and paste into a new excel file.This will solve ur problem.
2)You can give the extension of the file name .xls and let the file format be ASCII.It'll give u the excel file on excel background but in a hapazered manner.It'll create the problem in distinguish the field values with field name.
So u can use both methods.
Vishnu
slees32 <[EMAIL PROTECTED]> wrote:
Hello,
There was a reply to this about using html with a .xls extension. I
cannot find that post. But wanted to ask a question.
It was a great solution.
But when the document is opened in excel, the default background
grid does not exist. So you just have a white background and cannot
see the cells.
I cannot find any way to reinstate this default background.
Is it possible.
Thankyou - Steve
--- In Axapta-Knowledge-Village@yahoogroups.com, "Opitz Johannes"
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> I want to export Data from Axapta into an formatted Microsoft
Excel file. I know that there are several COM - Objects but i am not
sure if there is enough functionallity to realise my problems.
>
> Does anybody know where i can find a tutorial or a documentation
about it ?
>
> mit freundlichen Grüßen/kind regards
> Johannes Opitz
>
> TeleTEK
> Telekommunikation-Service GmbH & Co KG
> Eitnergasse 6
> A-1230 Wien
>
>
> Fax +43-1-866 49 188
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> www.teletek.at <http://www.teletek.at/>
Sharing the knowledge on Axapta.
Too much spam in your inbox? Yahoo! Mail gives you the best spam protection for FREE!
http://in.mail.yahoo.com
Sharing the knowledge on Axapta.
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
