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?
...
| Wiki Markup |
|---|
h1. FAQ h2. 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. |
...
In addition to the earlier suggestion for older versions of SAP2000 (i.e. exporting only a portion of the model at a time), you could also export the data to Access database, which does not have this limit on the number of rows. h2. I am not able to export table to Excel when doing interactive database editing. Please try the following on the machine that is giving problem: (1) unregister DAO by clicking "Start, Run", copy and paste the following, and click OK {code} regsvr32 /U "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.dll" {code} (2) Re-register the DAO by clicking "Start, Run", copy and paste the following, and click OK {code} regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.dll" {code} {hidden-content} Relevant emails: * {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} |