|NAME||EXCEL (DATA PARSE)|
|SEND LAST FIELD DELIMITER?||YES|
|FILE HEADER||W $$DPXCEL^DDXPLIB(DDXPXTNO)|
Use the EXCEL-DATA PARSE format to export data to the EXCEL spreadsheet program running on the Macintosh or under windows. Exported data is fixed length. The first line output is a guide for use by EXCEL's Data Parser to place data into columns. Maximum record length is 255 characters.
To import a file created in this format into Excel, choose the Open command on the File menu and select the file. Each record will be put into a single cell. Select the column that has the data, including the first record which will contain the guide for data parsing. Then, choose Parse from the Data menu. Press the GUESS button and then press OK. The data will be put into correct columns. You may need to adjust column widths.
|RECORD LENGTH FIXED?||YES|
|MAXIMUM OUTPUT LENGTH||255|