Skip to main content
Solved

Split Excel at specific Number


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.

Best answer by bartjannink

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.

View original
Did this help you find an answer to your question?

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+49

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


Forum|alt.badge.img
  • Best Answer
  • August 19, 2020

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings