web

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

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to iterate excel h...

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

Suggested Answer

How to iterate excel header name using excel buffer in business central

(0) Share

Report

Report

Posted on by Nilam Bhor

153

Hi Guys,

I want to iterate my Qty & value column names in header part of excel using excel buffer.

Is any way to do this

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Gerardo Rentería Ga... 27,621 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Maybe this can help

https://www.youtube.com/watch?v=jalKh9tSAjg
Suggested answer

YUN ZHU 103,294 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, after TempExcelBuffer.NewRow(), you can add a loop, such as For-to, so that you can insert the same header multiple times in the same row.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-al-control-statements

More info about How to use Excel Buffer to Export data

https://yzhums.com/4180/

Hope this helps.

Thanks.
ZHU

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 796 Super User 2026 Season 2

#2

YUN ZHU 481 Super User 2026 Season 2

#3

AndrewThomas81 377 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans