News and Announcements icon

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:

Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

tanya07 1,554 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
liki 50 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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans