• Forums
• Home

Search Rate this topic:   Comments (optional) Sort Posts:  Oldest to newest Newest to oldest

05-09-2011, 10:26 AM danielwatts Joined on 05-09-2005 Posts 4 Is there a limit on the number of rows that can be exported to Excel? Hi, One of our users recently began to work with large cubes, and found that some of the exported Excel files couldn't be opened. Excel 2007 displays an error message when opening the .xls file: Excel found unreadable content in . Do you want to recover the contents of this workbook?" Selecting Yes to recover results in a second error message "Unable to read file." Trial-and-error testing shows that the Excel file can't be read if the # of rows in the cube is > 65535. This was a limit in older versions of Excel. Is it also a limit in Dynamicube? I have tried the latest release, Build: 3.3.0.1224 from Feb 2011. We are calling the ExportToExcel method with mostly the default parms: DCube1.ExportToExcel CommonDialog2.Filename The ExportToExcel method completes without errors. Thanks, Dan.    Report

05-10-2011, 12:49 AM Andrey - DD Joined on 08-01-2007 Russia, Novosibirsk Posts 671 Re: Is there a limit on the number of rows that can be exported to Excel? Dan, The DynamiCube's Excel export uses old format of Excel files with 65535 rows and 256 columns limitations. DynamiCube is discontinued product so, unfortunately, there are no plans for implementing new Excel export format. Thank you, Andrey T.    Report

GrapeCity » Product Support » DynamiCube Supp... » Is there a limit on the number of rows that can be exported to Excel?

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Join this community |- Forgot Password Product Support |- ActiveReports 6 Support |- GrapeCity ActiveAnalysis Support |- ActiveReports Developer 7 Beta Support |- Data Dynamics Analysis Support |- ActiveReports for .NET 3.0 Support |- ActiveReports for .NET 2.0 Support |- ActiveReports for .NET Support |- ActiveReports 2.0 (Visual Basic 6.0) Support |- ActiveBar Support |- ActiveSizer Support |- DynamiCube Support |- SharpGraph for .NET Support |- SharpGrid Support |- SharpUI for .NET Support |- Data Dynamics Reports Support Frequently Asked Questions |- ActiveReports 2.0 FAQ |- ActiveSizer FAQ |- DynamiCube FAQ |- SharpGrid FAQ |- ActiveReports for .NET FAQ |- ActiveBar FAQ |- SharpUI for .NET FAQ Announcements |- ActiveBar Announcements |- ActiveReports Announcements |- ActiveReports for .NET Announcements |- ActiveSizer Announcements |- Data Dynamics WebSite Announcements |- DynamiCube Announcements |- SharpGraph for .NET Announcements |- SharpGrid Announcements |- SharpUI for .NET Announcements |- Data Dynamics Reports Announcements |- GrapeCity ActiveAnalysis Announcements Knowledge Base |- KnowledgeBase for SharpUI for .NET |- KnowledgeBase for ActiveCube |- KnowledgeBase for ActiveReports |- KnowledgeBase for ActiveBar |- KnowledgeBase for ActiveReports for .NET |- KnowledgeBase for SharpGrid |- KnowledgeBase for ActiveSizer |- KnowledgeBase for DynamiCube |- KnowledgeBase for SharpGraph for .NET |- KnowledgeBase for Data Dynamics Reports Forum Archives |- ActiveReports for .NET 2.0 Visual Studio .NET 2005 Support |- ActiveBar 3.0 Beta Support |- support.activebar2.general |- support.activereports.general |- support.activereports2.stdedition |- support.activereports.net |- support.activereports2.proedition |- support.activesizer.general |- support.dcube.c++ |- support.announcements |- support.dcube.delphi |- support.dcube.ie |- support.dcube.misc |- support.dcube.vb |- support.dcube.vfp |- support.sharpgrid.general Product Downloads |- ActiveSizer Downloads |- SharpUI for .NET Downloads |- ActiveReports for .NET Downloads |- ActiveCube Downloads |- ActiveReports Downloads |- ActiveBar Downloads |- SharpGrid Downloads |- ActiveReports for .NET 2.0 Downloads |- SharpGraph for .NET Downloads |- DynamiCube Downloads |- ActiveReports for .NET 3.0 Downloads |- ActiveReports 6 Downloads |- Data Dynamics Reports Downloads Web Site Feedback |- Web Site Feedback Employment Opportunities |- Employment Opportunities