Merging cells in Excel using Excel Buffer

Archy · 2006-12-05

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:

damir · 2006-12-05

You should add new function to Excel Buffer table and call it after CreateSheet. This function will contain xlRange.Merge command

Archy · 2006-12-05

I have added such a function - it works! \:D/
But there is one problem - it merges cells, but do not center content in this new big cell. :-k Any ideas?

kine · 2006-12-05

You need to set correct property for that cell... try to record the macro and look into it.

keshavopk · 2009-10-22

Hello,

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

Hanen · 2009-11-30

I'm using this code and it works perfectly :

XlBook := XlApp.Workbooks.Open(FileName);

//Transfering Data to Microsoft Excel:
XlSheet:= XlApp.ActiveSheet;
XlSheet.Range('A1:A2').Cells.Merge;
XlSheet.Range('A1').HorizontalAlignment :=  -4108;

I hope it can helps!!!

johanna · 2012-03-01

Hanen,

Thank you so much! Your code works perfectly

sushilhc · 2020-05-09

Dear Hanen,

Please help. How to set the variables. Please define in detail.

Thanks & Regards,
Sushil Chaudhari

RockWithNAV · 2020-05-15

It's possible,I remember I did long for one of the Project.

The caption part they wanted to Merge. I guess I used some Automation Variables.

Howdy, Stranger!

Quick Links

Categories

Merging cells in Excel using Excel Buffer

Comments