span8
span4
span8
span4
Why is reading or writing Microsoft Excel more complex than other formats?Because Excel has no limits on its data structure.Most tabular-based formats have a single data type per column;but in Excel the data type can be set on each cell,making it a very flexible format for use with FME.
You might use FME to process data because you need to:
FME provides read and write access to Excel spreadsheets,which are also known as workbooks.Excel spreadsheets may contain multiple worksheets,and each worksheet may optionally contain specifically named cell ranges called ‘Named Ranges'.
There are a few important definitions to be aware of before we begin working with Excel in the FME Environment.Use the following table to familiarize yourself with how FME represents the various data elements found in Excel:
Excel Term | FME Term / Representation |
Spreadsheet & Workbook |
Spreadsheet & Workbook |
Worksheet | Worksheet or Named Range |
Column,in a worksheet or named range |
Attribute |
Worksheet or Named Range |
Feature Type |
Row | Feature |
The most important reference source when working with Excel data in FME is theMicrosoft Excel Reader and Writer documentation页.The Excel writer documentation provides usage notes,and in-depth details on functionality and parameters.
For more information on the use of Microsoft Excel in FME,including several quick conversion tutorials,please continue along to the following resources:
Learn the basics of Viewing and Inspecting Excel data through FME.
The basic steps for how to read from an Excel spreadsheet.
The basic steps for how to write to an Excel spreadsheet.
Viewing and Inspecting Excel Data
Example scripts for deleting Excel files prior to writing (FME 2013 SP1 and earlier)
Overview of Excel Reader Parameters
Overview of Excel Writer Parameters
Using a Template File when Writing Excel Data
How to Convert CSV to Microsoft Excel
© 2019 亚搏在线Safe Software Inc |Legal