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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Gerardo Rentería Ga... 27,054 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Maybe this can help

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,775 Super User 2026 Season 1 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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

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

#1

OussamaSabbouh 2,497 Super User 2026 Season 1

#2

YUN ZHU 1,778 Super User 2026 Season 1

#3

AndrewThomas81 1,507

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans