Home » Categories » Solutions by Business Process » System Features

Output to Microsoft Excel 2007

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

 

Custom Fields
  • Release ID: 6.3
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Customer / Product History Enquiry
Viewed 3395 times since Tue, Jun 12, 2012
User-Definable Ledger Enquiry Applications
Viewed 20680 times since Tue, Jun 12, 2012
Data Interchange - Import Large Text Strings
Viewed 1137 times since Fri, Oct 26, 2012
Ledger Enquiry – Improved Scans Option
Viewed 482 times since Wed, Jun 13, 2012
Windows 10 1803 Update / Windows Defender
Viewed 322 times since Wed, May 30, 2018
Output to Excel Pivot Table
Viewed 22853 times since Tue, Jun 12, 2012
Extra Secondary Indexes
Viewed 487 times since Wed, Sep 21, 2016
Order Enquiry - Allow Label Print from Order Details
Viewed 942 times since Mon, Jun 11, 2012
Display Price Item Names
Viewed 554 times since Fri, May 20, 2016
F4-Search - Default Item
Viewed 921 times since Fri, Jun 8, 2012