Vertical Alignment of Text in Vertically Merged cells of Excel Sheet by X++

(0) Share

Report

Posted on by Hamza Bin Mushtaq

160

Hello Guys!
I have created a custom report which writes all the retrieved data in an excel sheet and shows it.
I want to align the text vertically in middle of the vertically merged cells. As show in the attached imaged.
Please help me out in solving this issue.
E.G. The text "Item Number" should be in the middle of the cell instead of bottom.

Thank you,
Regards,
Hamza

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Mea_ 60,284 on at

Like (0)

Report

RE: Vertical Alignment of Text in Vertically Merged cells of Excel Sheet by X++

Hey Hamza Mushtaq,

All AX classes that works with Excel are just a wrappers over COM object.

There is simple way to deal with all excel formatting. You can record VB macro from excel www.excel-easy.com/.../macro-recorder.html and then call same methods on COM object.

Was this reply helpful? Yes No
Hamza Bin Mushtaq 160 on at

Like (1)

Report

RE: Vertical Alignment of Text in Vertically Merged cells of Excel Sheet by X++

Thank you once again Ievgen.

That solved my problem.

Cheers!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Vertical Alignment of Text in Vertically Merged cells of Excel Sheet by X++

Hello , can you tell me how merge excel cells vertically ? Because I can merge them horizontally , but in vertical doesn't work. Thank You

Was this reply helpful? Yes No
Hamza Bin Mushtaq 160 on at

Like (0)

Report

RE: Vertical Alignment of Text in Vertically Merged cells of Excel Sheet by X++

Hi Vitomir,

Please check, I have marked the above answer as correct and it helped me to achieve what I wanted.

Regards,

Hamza

Was this reply helpful? Yes No