Hi all!
I have made a report, using Excel Buffer. But I need to merge cells in report header row. It seems, that is impossible to merge cells using excel buffer.
I found in previous topics one way to do it:
xlSheet.Range('A1:C1').Merge;
The only way I can imagine is to complitely modify my report and do not use Excel Buffer table. But it is so complicated!
May be someone could advise some other way? :oops:
Comments
But there is one problem - it merges cells, but do not center content in this new big cell. :-k Any ideas?
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Can anyone help on merging of Cell, I am trying to call a new function which has a command xlRange.Merge('A1:A2') (calling this after function CreateSheet
for Export to excel). but I am getting following Automation error
Microsoft Dynamics NAV
This message is for C/AL programmers:
This Automation variable has not been instantiated.
You can instantiate it by either creating or assigning it.
OK
and if I try to Initialize it then it show some other error
Microsoft Dynamics NAV
This message is for C/AL programmers:
An exception was raised in method Merge. The OLE control or Automation server has returned error (HRESULT) -2147352567.
The component did not provide the exception description.
OK
is anyone have correct syntex of it then pls let me know. Your co opration shall be appriciated highly.
Thanks
I hope it can helps!!!
Hanen TALBI
Thank you so much! Your code works perfectly
Johanna
Please help. How to set the variables. Please define in detail.
Thanks & Regards,
Sushil Chaudhari
The caption part they wanted to Merge. I guess I used some Automation Variables.
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/