WOLFRAM

Wolfram Language & System Documentation Center

DIF (.dif)

Background & Context

    • DIF spreadsheet format.
    • Standard file format for spreadsheets and other tabular data.
    • Used as an exchange format for spreadsheet applications.
    • DIF is an acronym for Data Interchange Format.
    • Plain text format.
    • Stores a single spreadsheet.
    • Developed in 1980 as part of the VisiCalc spreadsheet software.

Import & Export

  • Import["file.dif"] imports a DIF file, returning a list of lists representing the rows and columns stored in the file.
  • Import["file.dif",elem] imports the specified element.
  • Import["file.dif",{elem,suba,subb,…}] imports a subelement.
  • The import format can be specified with Import["file","DIF"] or Import["file",{"DIF",elem,…}].
  • Export["file.dif",expr] creates a DIF file from expr.
  • Supported expressions expr include:
  • {v1,v2,…}a single column of data
    {{v11,v12,…},{v21,v22,…},…}lists of rows of data
    arrayan array such as SparseArray, QuantityArray, etc.
    tseriesa TimeSeries, EventSeries or a TemporalData object
    Dataset[…]a dataset
    Tabular[…]a tabular object
  • Export["file.dif",expr] uses the InputForm of non-numeric table elements.
  • See the following reference pages for full general information:
  • Import, Exportimport from or export to a file
    CloudImport, CloudExportimport from or export to a cloud object
    ImportString, ExportStringimport from or export to a string
    ImportByteArray, ExportByteArrayimport from or export to a byte array

Import Elements

  • General Import elements:
  • "Elements" list of elements and options available in this file
    "Summary"summary of the file
    "Rules"list of rules for all available elements
  • Data representation elements:
  • "Data"two-dimensional array, representing the rows and columns stored in the DIF file
    "Grid"table data as a Grid object
    "Tabular"table data as a Tabular object
  • Import and Export use the "Data" element by default.

Examples

open all close all

Basic Examples  (3)

Import tabular data from a DIF sample file, formatting it as a table:

Summary of a DIF file:

Export a Tabular object to a DIF file:

Import Elements  (2)

Data Representation  (2)

"Data"  (1)

Import a DIF file as lists of values:

This is also the default element:

"Tabular"  (1)

Import a DIF file as a Tabular object: