Microsoft OOXML Excel 2007+

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets >

Microsoft OOXML Excel 2007+

MapForce can read data from and write data to Microsoft Excel 2007+ workbooks, in the default Office Open XML (OOXML) format. This format was first introduced in Microsoft Office 2007 and, in case of Excel workbooks, is associated with the default .xlsx extension. In the MapForce interface, and in this documentation, Microsoft Excel 2007 and later files are generically referred to as "Excel 2007+" files.

 

Microsoft Office 2013 added support for Strict Open XML Spreadsheet format (ISO/IEC 29500 Strict). The Strict Open XML Spreadsheet format also has the .xlsx extension; however, technically this is a distinct format which adheres to stricter validation rules.

 

The following table illustrates how reading and writing data from/to Excel 2007+ workbooks is supported across MapForce transformation languages. Notice the differences between Office Open XML and Strict Open XML Spreadsheet formats.

 

Microsoft Excel Format

MapForce Language

Reading Support

Writing Support

Office Open XML

BUILT-IN

Yes

Yes

C#

Yes

Yes

Java

Yes

Yes

XSLT2

Yes

No

Strict Open XML Spreadsheet

BUILT-IN

Yes

No

C#

Yes

No

Java

Yes

No

XSLT2

Yes

No

 

If you need to convert any Office Open XML files generated by MapForce to Strict Open XML Spreadsheet format, open the workbook in Excel 2013, and then save it as Strict Open XML Spreadsheet.

xls_save_as_strict_zoom25

Saving to Strict Open XML Spreadsheet format

As mapping components in MapForce, Excel 2007+ files have the following general behavior:

 

You can map data from Excel 2007+ to any component supported in MapForce, and vice versa, including XBRL taxonomy files (see Excel to XBRL example).
If Microsoft Excel 2007 or later is installed on your computer, you can preview the transformation output immediately in the Output tab of the mapping window, and you can save it to a file. If you don't have Excel 2007 or later, you can still map to or from Excel 2007+ files. In this case, you cannot preview the result in the Output tab, but you can still save it, by clicking Save Output File on the Output menu.
The generated Excel 2007+ output does not contain any formatting, only data. If you need to format the Excel output generated by MapForce, you can reference the generated cell ranges from another Excel sheet and apply formatting in the referencing (not the referenced) sheet. For further information, see Example: Supplying Data to Preformatted Excel Sheets.
As an alternative to generating and saving the output manually, you can compile the mapping design to a MapForce Server execution file, or deploy it to a FlowForce Server, and execute it as and when required through FlowForce Server jobs. For further information, see Compiling a MapForce mapping and Deploying a MapForce mapping, respectively.
You can generate mapping code (see the supported languages above) and execute the mapping from Visual Studio 2008, 2010, 2013, 2015, 2017 or from your custom application. For more information, see Code Generator.

© 2019 Altova GmbH