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 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 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 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.
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.
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.
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
Import Automation Options String