Convert Excel to XML
To convert an Excel file to XML select Tools > Convert Excel to XML... and choose the path or URL of the Excel file to convert.
NOTE: Tools > Convert Excel to XML... is disabled if Microsoft Excel is not installed.
Click the Next > button.
Click the New button to create a new scenario. Click the Edit button to edit the scenario. Click the Convert button to run the scenario.
|
| • | Worksheet -- Choose one of the available worksheets. |
| • | Headers in row -- Specifies the row where the headers are to be found. |
| • | Data starts in row -- Specifies which row the data starts on. |
| • | Data ends in row -- Specifies which row the data ends on. |
| • | Values -- The first 5 rows in the Excel file are displayed in tabular form. |
| • | Template -- The template determines how the Excel worksheet is converted into XML. The text between {repeat} and {endrepeat} is repeated as many times as the number of rows in the Excel worksheet. The template supports these variables: $header_1, $header_2, etc. and $column_1, $column_2, etc. and $index. Variables are escaped according to XML rules, if you don't want to escape your data use $header_1_unescaped, $column_1_escaped, etc. Text between {script} and {endscript} is executed as JavaScript. For instance: {script}$column_3.toUpperCase(){endscript} inserts "hello" in the output if the value of $column_3 is "Hello". |
| • | Preview -- An example of what the generated XML will look like. |
See Also
Welcome!