How to display only a certain number of rows in Excel

(0) Share

Report

Posted on by Community member

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:

Business Central

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 72,941 Super User 2024 Season 2 on at

Like (0)

Report

How to display only a certain number of rows in Excel

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