Open Excel by form button

(0) Share

Report

Posted on by VV-22040800-0

I'm having a button in the form and when i click that button it should open a excel (with headers) and there i can able to enter the value and then save it in any destination , so it's possible ?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Community Member on at

Like (0)

Report

Yes it's possible.

Was this reply helpful? Yes No
UmesH@ 810 on at

Like (0)

Report

Can you Please tell us how can we do it ?

Was this reply helpful? Yes No
Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

What exactly do you mean by "with headers"? And are you aware of the standard functionality for exporting to Excel?

By the way, please use more descriptive thread titles than "AX beginner".

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report

Headers is nothing but the header fields for the excel which is we going to open !

Was this reply helpful? Yes No
Verified answer

Ravikumar 325 on at

Like (0)

Report

I hope this helps.

learnax.blogspot.in/.../x-code-to-readwrite-dynamics-ax-data-to.html

Was this reply helpful? Yes No
Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

Which fields? All fields of a table, all fields from all tables in the form, all fields in a group, all fields in a grid, editable fields only...?

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report

all fields of a table

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

The link above shows how to use SysExcel classes. People also often use plain CSV files, which can be created by CommaTextIO class (for example).

To get names of table fields, use SysDictTable class. If it has fields() method, it will be the easiest way (it's possible that this particular method doesn't exist in AX 2009).

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report

yeah thank you so much !

Was this reply helpful? Yes No