Excel extractors

Revision as of 21:49, 24 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

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.

Excel sheet extractor

Extractors described above process all sheets in the spreadsheet file. Some times this is not a good idea. Different sheets may have different cell layout. Excel sheet extractor is a meta extractor that collects all other extractors under a single interface and allows the user to decide which extractor is applied to which spreadsheet sheet. User can also skip sheets.

Spreadsheet cell topics

Previous chapters described different Excel extractors. Wandora creates a topic out of each non-empty spreadsheet cell. By default topic's subject identifier is created out of cell value by attaching a prefix http://www.wandora.org/si/excel/cell/ into the url encoded cell value. Unmodified cell value is used as topic's basename. Each cell topic is typed with a special cell type topic. Cell type topic's subject identifier is http://www.wandora.org/si/excel/cell and basename Excel cell.

See also

• Wandora features also a Simple CSV association extractor that resembles the Excel adjacency list extractor but doesn't interpret the first row columns as association roles.
• Adjacency list export
• Adjacency matrix export