You’re offline. This is a read only version of the page.
420
Hope you are doing good,
I am working on one requirement form one of my client which is to export data from ax to Excel through X++ code. But there is one tricky condition to group excel columns while exporting data. Please let me know if you have any idea/solution related to this.
Regards
Anjaneya
*This post is locked for comments
Hi,
My Excel export works but I cannot find the good syntax to use method Range.group(...).
For example, method merge works fine:
rangeCOM = _sysExcelWorkSheet.cells().range("A1:A2").comObject();
rangeCOM.merge();
rangeCOM.horizontalAlignment(#xlRight);
That's why I would like to see exact syntax to use group(...) method.
Regards,
Mikaël Pires
Hi,
I try to use method sysExcelRange.comObject().group(...) but i always receive this error "Group method of range class is failed".
I have tried with several parameters calls, several ranges, etc...
Can you show me how you call this method please?
I am in AX2009 SP1 with office 365.
Regards,
Mikaël P.
Hi Rustem/Crispin,
Thanks for reply but its not merging of columns but the data grouping feature available on path (Excel sheet >> Data >> Group >>Rows/Columns)..
Please let me know if i m still not clear.
Hi!
The "group excel columns while exporting data" - it's mean merge columns?
Can you provide more information, please.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (