Skip to main content
Question

excel sheet writer


franco69
Contributor
Forum|alt.badge.img+6

How can i manipulate a Excel spreadsheet when i want to write exactly 500 features each sheet?

Greetz

Franco

7 replies

davideagle
Contributor
Forum|alt.badge.img+21
  • Contributor
  • January 26, 2016

A little maths should sort you out. The attached creates a unique id for each feature, then using the floor function puts every feature into a group of 500 features. You then use that attribute group id as part of your sheet name so that you can fanout sheets by groups of 500.

Hope that helps, Dave

assigngroupsof500.fmw


franco69
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • January 26, 2016

Thanx Dave!


franco69
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • January 26, 2016

One Question again...

I want to insert a fixed line (with fixed attrbs) on first line on first sheet under the column row

but only on the first sheet!

like this

how can I do this?

Greetz

Franco


davideagle
Contributor
Forum|alt.badge.img+21
  • Contributor
  • January 26, 2016
franco69 wrote:

One Question again...

I want to insert a fixed line (with fixed attrbs) on first line on first sheet under the column row

but only on the first sheet!

like this

how can I do this?

Greetz

Franco

So, 501 records is allowable on Sheet1 or must it be 500 including the fixed record?


davideagle
Contributor
Forum|alt.badge.img+21
  • Contributor
  • January 26, 2016
franco69 wrote:

One Question again...

I want to insert a fixed line (with fixed attrbs) on first line on first sheet under the column row

but only on the first sheet!

like this

how can I do this?

Greetz

Franco

You could do it like this, Creators allow you to send the feature before the main flow. If this doesn't work you could perhaps sort the features.

assigngroupsof500.fmw


franco69
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • January 26, 2016

i have a column line also.....(component, Nominal Diameter,....)

 

so now i have 501 on each sheet

 

and i needed it on 501 incl. new line

 

Greetz

Franco


franco69
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • January 26, 2016

thanx dave ids start at 1 and the insert line id is 0

 

 

Great

Greetz

 

Franco

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