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

How to add sum on last row using excel buffer in business central

(5) Share

Report

Posted on by Test user

321

Hi Guys,

I need to add total of rebate column at the end of row data using excel buffer in business central.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Vahid Ghafarpour 12,228 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

I hope this article help you

https://www.microsoft.com/en-us/dynamics-365/blog/no-audience/2012/10/04/excel-buffer-using-open-xml-instead-of-excel-automation-part-1-of-2/

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Correct and reliable approach is to calculate the total in AL and then write it as the last row.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Please check this too: https://www.dynamicsuser.net/t/sum-of-all-columns-in-a-row-in-export-to-excel-application/35519

Was this reply helpful? Yes No
Test user 321 on at

Like (2)

Report
Copy link

Link copied!

Hi @Khushbu Rajvi.

I need to calculate this credit column sum.

I have stored sum in one variable.

This is makeexcelbody procedure,how to add this to a last data line row in excel?

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

I think you must add one extra row after the loop finishes. Something like below.

// Inside loop (data rows)
repeat
ExcelBuf.NewRow;
ExcelBuf.AddColumn(credit, false, '', false, false, false, '', ExcelBuf."Cell Type"::Number);
TotalRebate += Round(credit);
until Rec.Next() = 0;

// AFTER loop – add last row
ExcelBuf.NewRow;
ExcelBuf.AddColumn('Total', false, '', true, false, false, '', ExcelBuf."Cell Type"::Text);
ExcelBuf.AddColumn(TotalRebate, false, '', true, false, false, '', ExcelBuf."Cell Type"::Number);

Was this reply helpful? Yes No
Suggested answer

Aman Kakkar 2,977 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You can just wrap up the code suggested by Khushbu inside a begin-end, and it should work fine. That's how we generally store the sum in RDLCs or Excels by calculating them in AL itself.

Hope this helps.

Aman K

Was this reply helpful? Yes No