|
• | 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. |