Microsoft Dynamics AX (Archived)

X++ code for merging excel cells

(0) Share

Report

Posted on by Dileep kumar.B

Hi all,

Any one kindly explain the steps for developing the merging excel cells functionality in Microsoft Dynamics AX 2012.

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

5400 7,162 on at

Like (0)

Report

Please check for same.

community.dynamics.com/.../106232

Was this reply helpful? Yes No
Verified answer

Bashir Ahmad 5,248 on at

Like (0)

Report

sysExcelRange.comObject().MergeCells(1);

Was this reply helpful? Yes No
Dileep kumar.B on at

Like (1)

Report

Thank you for your responce.

SysExcelRange = SysExcelWorkSheet.cells().range(range); sysExcelRange.comObject().MergeCells(1); SysExcelRange.horizontalAlignment(#xlCenter);

its working fine.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

SysExcelRange.comObject().mergeCells(1);

Hi Expert's,

I'm facing Warning msg "The variable is not of the type CLASS." when I use above code. can any one help me how to overcome warning message.

Thanks in advance !!!

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

If You don't want this warning, You must change range from SysExcelRange on COM .

Example :

COM range;

range = SysExcelWorkSheet.cells().range("A1:C1").comObject();

range.MergeCells(1);

Was this reply helpful? Yes No