Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

FAQ

Is there a limit on the number of rows that can be exported to Excel?

Extended Question: I ran a model of a bridge and want to export the result tables to Excel, but some of the tables have more than the 65000 or so rows, so the data is being cut off. I am using Excel 2007 which does not have this limitation but the rows are still being cut around 65,000. Could you help me with this problem?

Answer: The latest version of the program (V14.1.0) takes advantage of the change in Excel 2007. When compared to Excel version older than Excel 2007, the limit on number of columns and rows in Excel 2007 has gone up from 256 columns to 16,385 columns and from 65,536 rows to 1,048,576 rows. If Excel 2007 is installed on your machine, the program will automatically use the enhanced data handling when creating Excel files.

...

Info

Resources associated with export from CSI Software are typically product-specific. Articles in product spaces may be most useful.

Info

NOTE:

  • To copy only a portion of a model, then reproduce that section in another model, select the objects to be copied, then select Export > Text File. This will create a text file which may then be imported into the destination model when selected through Import > Text File.

See Also

Related Content

Articles

Child pages (Children Display)
alltrue
depth0
allChildrentrue
style
sortAndReverse
first0

Tutorials

Filter by label (Content by label)
showLabelsfalse
max500
maxCheckboxtrue
sorttitle
showSpacefalse
reversefalse
cqllabel = "tutorial" and label = "export"

Test Problems

Filter by label (Content by label)
showLabelsfalse
max500
maxCheckboxtrue
sorttitle
showSpacefalse
reversefalse
cqllabel = "test-problem" and label = "export"