Versions Compared

Old Version 5

changes.mady.by.user Mike Abell

Saved on

compared with

New Version Current

changes.mady.by.user Ondrej

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
{info} This page is devoted to *frequently asked questions* (FAQ) related to export. {info} \\ {on-this-page} h2. Is there a limit on the number of rows that can be exported to Excel? *Extended Question:* Some of the results tables I have for a bridge model are cut-off around 65,000 rows when exported to Excel. Is there an explanation for this limitation? *Answer:* Excel versions before 2007 are limited to 256 columns and 65,536 rows. With the release of Excel 2007, these limits expanded to 16,385 columns and 1,048,576 rows. If Excel 2007 (or a later version) is installed, {new-tab-link:http://www.csiberkeley.com/}CSI{new-tab-link} Software will automatically use the enhanced data handling when creating Excel files. Additional suggestions include export to Access database, which does not limit the number of rows, or incrementally export smaller portions of the model. h2. Why can't I export a table to Excel when doing interactive database editing? To resolve this issue, commonly reported as error # 430, please complete the following process: # Unregister DAO by selecting Start > Run, copy and paste the line below, then select OK \\ \\ {code} regsvr32 /U "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.dll" {code} \\ # Re-register DAO by selecting Start > Run, copy and paste the line below, then select OK \\ \\ {code} regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.dll" {code} {hidden-content} *Relevant email:* * {email:to=ok|from=rs|date=11/8/2010|subject=Unable to export to Excel|comment=Re-registering the relevant DLL may resolve the problem|id=6357124} {hidden-content}
Wiki Markup
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"