How to merge cells in Excel

Hanen

Hello,

I have a report to export in Excel and I have to merge two cells.
Any one knows how can I do that???
Thanks for your help :thumbsup:

Luc_VanDyck

pcodCell := 'A1:C1';
autXWorksheet.Range(pcodCell).Cells.Merge;

Hanen

[/code]I'm using the Buffer Excel Table table I'm not workind directly with the report
How can I deal with that problem???
Do you have an idea?
I'll be greatful for the answer.

ExcelBuf.NewRow;
ExcelBuf.AddColumn('No Customer,FALSE,'',TRUE,FALSE,TRUE,'');
ExcelBuf.AddColumn('Customer Name',FALSE,'',TRUE,FALSE,TRUE,'');

Luc_VanDyck

That functionality is not available.
You'll have to make your hands dirty and add some code to this Excel Buffer table in order to merge cells.

PS: Why did you marked this topic as [Solved], while it isn't?

Hanen

Good morning
It works now but I need to center my data is there a way to do that??? :oops:
Thanks for your help :thumbsup:

Luc_VanDyck

codCell := 'A1';
intAlign := -4108;
autXWorksheet.Range(codCell).HorizontalAlignment := intAlign;

Next time, visit http://msdn.microsoft.com/en-us/library/bb213535.aspx to explore the Excel Object Model.

Hanen

Thanks :thumbsup: