span8
span4
span8
span4
Hi,I have hit the maximum row limit for an excel spreadsheet with the excel output writer (1,048,576 rows).
Is there an easy option to overflow the rows into another spreadsheet?
Should I use a row counter and tester to overflow the data to another spreadsheet?
Using the XLS file extension has a maximum number of rows.
As far as I know the XLSX file extension does not.
Have you tried writing to a XLSX file?
Hi@thiru,assuming that an attribute named "_count" contains the feature count number (0-based sequential number),this math expression returns 0-based index for each group of 1048576 rows.
@int(@Value(_count)/1048576)
I think you can configure destination feature type name (i.e.Excel sheet name) based on this value.
Problem with exporting to Excel8 Answers
Excel Writer unlocking protected worksheets1 Answer
Writing Attributes to Excel3 Answers
Using template in excel writer2 Answers
Excel Writer,how to write Attribute Name in first row3 Answers
© 2019 亚搏在线Safe Software Inc |法律