This is documentation for an obsolete product.
Current products and services

Importing and Exporting Data

Mathematica CalcCenter can import and export text, data, and graphics in a wide variety of formats. Here are examples of a few common operations.

To import data from a spreadsheet:

  • 1. Save the data from your spreadsheet to a file where row entries are separated with spaces or tabs. Numbers should be written in C or Fortran-like "E" notation. For example, in Excel 2000 you can save the data by setting the file type to "Text (Tab delimited)".
  • 2. In Mathematica CalcCenter, type the command ImportData["file", "Table"], then evaluate it by pressing ShiftKeyKeyBarEnterKey.
  • To export a matrix to a file:

    Evaluate Export["file", expr, "Table"]. The file will have spaces between row entries. Numbers are written in C or Fortran-like "E" notation, usually with six-digit precision.

    The file can be read into a spreadsheet. For example, when you open the file in Excel, the Text Import Wizard helps you to interpret rows and columns in the file.

    To import a bitmap image and manipulate it in Mathematica CalcCenter:

    Evaluate ImportData[ "file"]. The result will be a Mathematica CalcCenter expression that represents the graphic in the specified file.

    Use ListDensityPlot[%] to display the graphic in Mathematica CalcCenter.

    To export an image:

    Evaluate Export["file.ext", expr].

    If you are exporting an image that includes mathematical notation and is not in bitmap format, you should include the Mathematica CalcCenter fonts with the image. Otherwise these fonts will not be available when viewing or printing the image on another machine.
    If the fonts are installed on your machine, the operating system will locate them and download them to the printer as needed.

    For more information, see:
    Bullet the entries for ImportData and Export in the Functions category of the Help Browser.
    Bullet the Technical Support FAQs at

    T I P
    Bullet ImportData and Export support a wide variety of text, graphics, and sound formats. You can view a complete list of supported formats in the Help Browser.

    To convert a notebook to HTML for direct display on the web:

    Use the File RightTriangle Save as Special RightTriangle HTML menu command.

    Mathematica CalcCenter converts any graphic to a GIF image and creates the appropriate reference to the image in the HTML file. By default, closed cell groups are converted to links and the contents of the closed cell are saved as a separate HTML file.

    To link to a notebook from a web page:

    Give a link to the notebook file with the standard .nb extension. Most web browsers can open any file with the .nb extension and view the notebook with Mathematica CalcCenter.
    If your web browser cannot open notebooks, use the following settings to make Mathematica CalcCenter a helper application:

  • For colleagues without Mathematica CalcCenter, a free application for viewing notebooks, MathReader, can be downloaded from You can provide a link to MathReader with your notebook.