Home » Categories » Solutions by Business Process » System Features |
Output to Microsoft Excel 2007 |
Article Number: 127 | Rating: 1/5 from 1 votes | Last Updated: Tue, Jun 20, 2023 at 6:23 PM
|
Datafile Software Output to Microsoft Excel 2007 Microsoft Excel 2003 has limits on the number of rows and columns that can be displayed within a spreadsheet which was increased for Excel 2007. By default when outputting to Excel from Datafile, either via reporting options or the database output tool, the system applies the Excel 2003 limitations for rows and columns. A setting, previously advised, within the DATAFILE.INI of EXCELMODE=2007 removed the limit on the number of records/rows that could be output to Excel but the limit on the number of columns remained (at 255). From this update the column limit is also increased to 321 – the maximum number on a Datafile database including the record number – allowing full database output were required. Installation No specific changes, over and above the EXCELMODE=2007 setting, are required for output of the extra columns. Note that the DATAFILE.INI is a shared system file applying to all users thus where Excel 2003 and 2007 are both in use by users on the Datafile system you should comment out the EXCELMODE setting within the DATAFILE.INI and instead update this setting to the DFWIN.INI
|
Attachments
![]() There are no attachments for this article.
|
Application Memos – Warning or Note
Viewed 1183 times since Wed, Jun 13, 2012
Landing Pages - Field Chooser Display Sequence
Viewed 544 times since Wed, Oct 23, 2024
Document Design Manager - Save and Exit
Viewed 4011 times since Wed, Jun 13, 2012
Document Design Manager - Page Set-up
Viewed 5048 times since Wed, Jun 13, 2012
Pick Lists - Increased No of Display Items
Viewed 2700 times since Wed, Sep 21, 2016
Ledger Enquiry - Prevent Auto Close of Associated File Folder on Enquiry
Viewed 464 times since Wed, Oct 23, 2024
Sales / Purchase – Transactions to be Displayed
Viewed 1212 times since Tue, Jun 12, 2012
Default Printer / Tray Settings
Viewed 2268 times since Wed, Jun 13, 2012
Ledger Enquiry - Additional History Enquiry Databases
Viewed 571 times since Tue, Oct 15, 2024
Documents to Email - Merge PDF Attachments
Viewed 4398 times since Mon, Jun 11, 2012
|