Lotus spreadsheet files

Lotus spreadsheets come in several flavors:

♦ WKS files are single-sheet files used by 1-2-3 Release 1..x for DOS. Excel can read and write these files.

Excel can also open Microsoft Works 2.0 files, which also have a WKS extension.

♦ WK1 files are single-sheet files used by 1-2-3 Release 2..x for DOS. The formatting for these files is stored in *.all files (produced by the Allways add-in) or FM1 files (produced by the WYSIWYG add-in). Excel can read and write all these files. When you save a file to the *.wk1 format, you can choose which (if any) type of formatting file to generate.

♦ WK3 files are generated by 1-2-3 Release 3.x for DOS, 1-2-3 Release 4.x for DOS, and 1-2-3 Release 1.x for Windows. These files may contain more than one sheet. The formatting for these files is stored in *.fm3 files (produced by the WYSIWYG add-in). Excel can read and write WK3 files with or without the accompanying FM3 file.

♦ WK4 files are generated by 1-2-3 Release 4.x for Windows and 1-2-3 Release 5.x for Windows. (Lotus finally got its act together and eliminated the separate formatting file.) These files may contain more than one sheet. Excel can neither read nor write these files. If you need to read a WK4 file into Excel, your only option is to use 1-2-3 Release 4 for Windows (or later) and save the file in WK3 format, which Excel can read.

♦ 123 files are generated by 1-2-3 97 and 1-2-3 Millennium Edition. These files may contain more than one sheet. Excel can neither read nor write these files. If you need to read a 1-2-3 file into Excel, your only option is to use 1-2-3 and save the file in WK3 format, which Excel can read.

Quattro Pro files also exist in several versions:

♦ WQ1 files are the single-sheet files generated by Quattro Pro for DOS Versions 1, 2, 3, and 4. Excel can read and write these files.

♦ WQ2 files are generated by Quattro Pro for DOS Version 5. Excel can neither read nor write this file format.

♦ WB1 files are generated by Quattro Pro for Windows Versions 1 and 5. (Note: There are no Versions 2 through 4.) Excel can read, but not write, this file format.

♦ WB2 files are generated by Quattro Pro for Windows Version 6. Excel can neither read nor write this file format.

0 0

Post a comment