How can i manipulate a Excel spreadsheet when i want to write exactly 500 features each sheet?
Greetz
Franco
+14
- Contributor
- 577 replies
-
26 January 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
+6
- Contributor
- 164 replies
-
26 January 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
+14
- Contributor
- 577 replies
-
26 January 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
So, 501 records is allowable on Sheet1 or must it be 500 including the fixed record?
+14
- Contributor
- 577 replies
-
26 January 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
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.
+6
- Contributor
- 164 replies
-
26 January 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
+6
- Contributor
- 164 replies
-
26 January 2016
thanx dave ids start at 1 and the insert line id is 0
Great
Greetz
Franco
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.