Excel Data File Description

Microsoft Excel .XLS, .XLSX, and .XLSM files contain data and retain some cell formatting in MapViewer. Some information, such as formulas, is ignored. Excel files can preserve all formatting information available in the Golden Software worksheet.

 

MapViewer supports the import of .XLS, .XLSX, and .XLSM Excel files. MapViewer supports the export of .XLS and .XLSX files.

 

Excel .XLS

Excel .XLS files are Microsoft Excel documents. Worksheet cell data and some cell formatting are retained with this format. Other types of information, such as formulas, are ignored.

 

Excel .XLS format files can preserve all formatting information available in the Golden Software worksheet. This format has a 65,536-row limit and a 256-column limit in Excel 97 and greater. Therefore, this format cannot be used to store very large data sets.

 

Excel .XLSX

Excel .XLSX files are Microsoft Excel 2007 XML spreadsheets. Worksheet cell data and some cell formatting are retained with this format. Other types of information, such as formulas, are ignored.

 

Excel .XLSX format files can preserve all formatting information available in the Golden Software worksheet. This format has a 1,048,576-row limit and a 16,384-column limit in Excel 2007 and greater.

 

Excel .XLSM

Excel .XLSM files are Microsoft Excel 2007/2010 XML spreadsheets. XLSM files can contain macros and VBA scripts. Worksheet cell data and some cell formatting are retained with this format. Other types of information, such as formulas, are ignored.

 

Excel .XLSM format files are not saved in MapViewer.

 

Use Caution when Saving Excel Files!

A file can be saved in an Excel format from MapViewer worksheet, but only one worksheet can be saved. MapViewer does not allow for saving multiple worksheets in a single Excel document. If a multi-worksheet Excel file is opened and saved as an .XLS or .XLSX file from the MapViewer worksheet, be aware that only the single worksheet is saved in the document. If the existing file is overwritten, all the unused worksheets are destroyed. In this case, a warning message is issued. The message reads: Saving this worksheet will destroy all but one of the sheets in the existing *.xls, *.xlsx file. To overwrite the file, click OK. To choose a different file name, click Cancel.

 

Special Characters Used in Excel Files

There are a number of special characters that can be contained in an Excel file that the worksheet cannot handle in the same way as Excel. For these characters, MapViewer substitutes a reasonable representation so the value displayed in the cell will look similar to what was displayed in Excel.

 

Import Options Dialog

See Excel XLS Import Options Dialog and Excel XLSX Import Options Dialog

 

Import Automation Options

See Import Automation Options String.

 

Export Options

See Excel Export Options Dialog.

 

Export Automation Options

See Export Automation Options String

 

Sheet Names

The sheet name of an Excel file is listed in the gridding report, cross validation report, and data statistics report.

 

 

 

See Also

Data File Formats

Opening Worksheet Files

Saving Worksheet Files

Special XLS Characters

Import Automation Options String

Export Automation Options String

File Format Chart