Skip to main content
  • EN

I have a Excel with 290 Rows and i want to Split that Excel at row 42 into different Pages. Result would be 42 Rows at Page 1. Next 42 Rows Page 2 and so on.

I thought i could do it with a loop like count till 42 and then count again and filter by <= 42 but its not working.

There's a Grouper custom transformer on the FME Hub that you can use to do that.

In the excel writer as a sheet name use:

Page@Evaluate(@floor(@Count()/42)+1)

It will create sheets called Page1, Page2 etc... with 42 rows each.

Reply


Community Stats

30,162
Posts
114,483
Replies
37,810
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.