web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to merger 2 column...

Small and medium business | Business Central, N...

Suggested answer

How to merger 2 columns in excel buffer in business central

(0) Share

Report

Report

Posted on by Nilam Bhor

153

Hi guys,

How to merge two columns in using excel buffer.

Is any way to do this. or any sample example

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

liki 5 on at

Like (0)

Report

How to merger 2 columns in excel buffer in business central

Hi,

i would write extension where

// Retrieve the values from the two columns
string column1Value = ExcelBuffer.GetValueByCellName("A1");
string column2Value = ExcelBuffer.GetValueByCellName("B1");

// Merge the values with a separator
string mergedValue = column1Value + " " + column2Value;

// Write the merged value to a specific cell
ExcelBuffer.WriteCellValue("C1", mergedValue);

Example -> https://yzhums.com/4223/ and https://learn.microsoft.com/en-us/dynamics365/business-central/application/base-application/table/base-application-table-excel-buffer

Was this reply helpful? Yes No
Suggested answer

tanya07 1,638 on at

Like (0)

Report

How to merger 2 columns in excel buffer in business central

Hi,

You can also calculate C1 value before like ..

A1:=0;

B1:=0;

C1:=0;

C1 := A1 + B1;

and then use -

ExcelBuf.AddColumn(A1, FALSE, '', FALSE, FALSE, FALSE, '#,##0.00', ExcelBuf."Cell Type"::Number);

ExcelBuf.AddColumn(B1, FALSE, '', FALSE, FALSE, FALSE, '#,##0.00', ExcelBuf."Cell Type"::Number);

ExcelBuf.AddColumn(C1, FALSE, '', FALSE, FALSE, FALSE, '#,##0.00', ExcelBuf."Cell Type"::Number);

Regards,

TK

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Rishabh Kanaskar 3,401

#2

Sumit Singh 2,692

#3

YUN ZHU 1,935 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans