Excel and Lotus DIF File Differences

SUMMARY

A DIF (Data Interchange Format) file created by Microsoft Excel
differs from one created by Lotus 1-2-3. This may pose a problem for
those programs such as Charting Gallery, which require imported data
to be Lotus DIF compatible.

MORE INFORMATION

All parts of Lotus and Excel DIF files are similar except for the
VECTORS and TUPLES entries. The following table would create the
respective VECTORS and TUPLES entries in a DIF file:


ABCD
1198919881987
2MARY1085
3SAM986


EXCELLOTUS
VECTORS0,30,4
TUPLES0,40,3


In order to make the Microsoft Excel DIF file compatible with the
Lotus format, use a text editor and swap the VECTORS and TUPLES number
entries.


속성

문서 ID: 60997 - 마지막 검토: 2017. 2. 14. - 수정: 1

Microsoft Excel 95 Standard Edition

피드백