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 display only a ...

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

Suggested Answer

How to display only a certain number of rows in Excel

(0) Share

Report

Report

Posted on by Community member

4

Hi Guys,

How to display only a certain number of rows in Excel using an Excel buffer?

However, I want to split the 400 rows into two Excel so that 200 rows of data will show up in one Excel and 200 rows in the other Excel in Business Central. I created a Processing report that uses an Excel buffer to Export excel.

Let me know if there 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 (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 98,421 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, I think you can use For-to loop.

Or add a count to break out of the loop after reaching your number.

The following is an example of inserting data in Excel:

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 1,857 Super User 2026 Season 1

#2

YUN ZHU 1,047 Super User 2026 Season 1

#3

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans