SHARING INFORMATION WITH OTHER APPLICATIONS

Exporting view data into spreadsheet files
You can export view data to a Lotus 1-2-3 spreadsheet file. When you export a view to a spreadsheet, each line in the view becomes a row in the spreadsheet and each view column becomes a spreadsheet column. Any text visible in the view becomes spreadsheet cell contents. Column titles become column labels in the spreadsheet.

Tip To export to a Microsoft Excel file, export the view as a Lotus 1-2-3 spreadsheet, and then save the file in 1-2-3 as a Microsoft Excel file.

Exporting from a view does not remove documents from the view, but simply copies the data into a new file.

Notes can export the file in either .WKS or .WK4 format. The .WK4 format is newer; use it unless you plan to use a very old release of 1-2-3 to work with the file.

Caution Do not change the extension of the exported file in the operating system before opening the file in Lotus 1-2-3, or you may have problems saving attributes. To convert the file to another release of 1-2-3, open the file in 1-2-3, choose File - Save As, and select the file format you want.

To export into a Lotus 1-2-3 spreadsheet file

1. In a view, select the documents you want to export.

2. Choose File - Export.

3. In the Export dialog box, select "Lotus 1-2-3" in the "Save as type" list.

4. In the "File Name" box, either create a new file by typing a name and extension, or replace data in an existing file with the exported data by selecting the file. Use either .WKS or .WK4 as the extension.

5. Click Export.

6. If you select a file that already exists in the directory, click "Replace" to overwrite that file, or "Cancel" to return to the Export dialog box so you can enter a new filename.

7. Select to export "All documents" or "Selected documents."

8. To include the view titles in the exported file, check "Include View titles."

9. Click OK.