How can i manipulate a Excel spreadsheet when i want to write exactly 500 features each sheet?
Greetz
Franco
Question
excel sheet writer
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+22- Contributor
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
+10- Contributor
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
+22- Contributor
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?
+22- Contributor
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.
+10- Contributor
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