Mathematica 9 is now available
 CalculationCenter / Getting Started / Working with Notebooks  /

Importing and Exporting Data

CalculationCenter 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 you can save the data by setting the file type to "Text (Tab delimited)".

2. In CalculationCenter , type the command ImportData[ " file" , "Table"] , then evaluate it by pressing .

To write out a matrix to a file:

In CalculationCenter , 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 Microsoft Excel, the Text Import Wizard helps you to interpret rows and columns in the file.

To import a bitmap image and manipulate it in CalculationCenter :

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

Use ListDensityPlot [%] to display the graphic in CalculationCenter .

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 CalculationCenter 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:

  • the entries for ImportData and Export in the Built-in Functions category of the Help Browser.
  • the Technical Support FAQs at

  • T I P

  • 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 Save as Special HTML menu command.

    CalculationCenter 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:

    Simply give a link to the notebook file whose name has the standard .nb extension. Most web browsers can open any file with the extension .nb and view the notebook with CalculationCenter .
    If your web browser cannot open notebooks by default, use the following settings to make CalculationCenter a helper application:

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

    Any questions about topics on this page? Click here to get an individual response.Buy NowMore Information