Export to Excel

Vineeth.R

Hai Friends,

when exporting to excel using commands like
excelbuff.addcolumn() i want to combine 2 cells of excel to 1 and show value, is it possible
if yes pls provide the code.

like my heading will be "January amount" (1st row)

in lines i have 2 values Actual and Expected in 2 columns

so header i want to combile 2 cells to show "january amount" so that the lines wil be shown under my header.

Please provide the solution

Sog

I haven't worked before with the excel buffer, but you should get the cell value of each cell you want to combine.
something like
excel.activeworkbook.activeworksheet.range(address of your first cel).value :=
format(excel.activeworkbook.activeworksheet.range(address of your first cel).value) + ' ' + format(excel.activeworkbook.activeworksheet.range(address of your second cel).value);