Excel extractors
| Line 8: | Line 8: | ||
* Excel topic names extractor | * Excel topic names extractor | ||
* Excel sheet extractor | * Excel sheet extractor | ||
| + | |||
| + | == Excel deep topic extractor == | ||
| + | |||
| + | Excel deep topic extractor interprets each spreadsheet cell into a topic and associates the topic with property-topics derived from cell's properties. Transformed cell properties include cell's location i.e. coordinates in the spreadheet, cell's format, cell's formula, cell's comment and cell's color. | ||
| + | |||
| + | Reader should note that the Excel deep topic extractor doesn't associate topics created out of different spreadsheet cells. | ||
| + | |||
| + | == Excel adjacency list extractor == | ||
| + | |||
| + | Excel adjacency list extractor interprets each spreadsheet row as an association. First row specifies association role types. Each column represents one player in the association. If column has no value, the player is ignored. Association type is a default Excel association type topic. | ||
| + | |||
| + | == Excel adjacency matrix extractor == | ||
| + | |||
| + | Excel adjacency matrix extractor interprets the spreadsheet as a matrix where first row and first column are topics. Whenever a spreadsheet cell has a value, Wandora creates an association between column and row topics. | ||
| + | |||
| + | == Excel topic tree extractor == | ||
| + | |||
| + | Excel topic tree extractor interprets the spreadsheet as a vertical list of topics where indented topics are associated with the previous outer topic. For example, topics created from B2 and B3 are associated with the topic created from A1. More over, a topic created from C4 is associated with the topic created from B3. | ||
| + | |||
| + | == Excel topic occurrences extractor == | ||
| + | |||
| + | Excel topic occurrences extractor assumes spreadsheet's first column contains occurrence carrier topics. First row contains occurrence types. All other cells in the spreadsheet contain occurrence values. | ||
| + | |||
| + | == Excel topic names extractor == | ||
| + | |||
| + | Excel topic names extractor is similar to the Excel topic occurrence extractor but creates variant names. Extractor assumes spreadsheet's first column contains named topics. First row contains scope topics i.e. language topics. All other cells in the spreadsheet contain names. | ||
Revision as of 21:59, 23 September 2013
Excel is a spreadsheet application created by Microsoft. Excel saves spreadsheets in XSL file format. Wandora contains several Excel extractors that read and transform XSL files into a topic maps format. Wandora's Excel extractors locate under menu File > Extract > Excel. Available Excel extractors are
- Excel deep topic extractor
- Excel adjacency list extractor
- Excel adjacency matrix extractor
- Excel topic tree extractor
- Excel topic occurrences extractor
- Excel topic names extractor
- Excel sheet extractor
Contents |
Excel deep topic extractor
Excel deep topic extractor interprets each spreadsheet cell into a topic and associates the topic with property-topics derived from cell's properties. Transformed cell properties include cell's location i.e. coordinates in the spreadheet, cell's format, cell's formula, cell's comment and cell's color.
Reader should note that the Excel deep topic extractor doesn't associate topics created out of different spreadsheet cells.
Excel adjacency list extractor
Excel adjacency list extractor interprets each spreadsheet row as an association. First row specifies association role types. Each column represents one player in the association. If column has no value, the player is ignored. Association type is a default Excel association type topic.
Excel adjacency matrix extractor
Excel adjacency matrix extractor interprets the spreadsheet as a matrix where first row and first column are topics. Whenever a spreadsheet cell has a value, Wandora creates an association between column and row topics.
Excel topic tree extractor
Excel topic tree extractor interprets the spreadsheet as a vertical list of topics where indented topics are associated with the previous outer topic. For example, topics created from B2 and B3 are associated with the topic created from A1. More over, a topic created from C4 is associated with the topic created from B3.
Excel topic occurrences extractor
Excel topic occurrences extractor assumes spreadsheet's first column contains occurrence carrier topics. First row contains occurrence types. All other cells in the spreadsheet contain occurrence values.
Excel topic names extractor
Excel topic names extractor is similar to the Excel topic occurrence extractor but creates variant names. Extractor assumes spreadsheet's first column contains named topics. First row contains scope topics i.e. language topics. All other cells in the spreadsheet contain names.
