Created by Frends Editor on Jul 05, 2017
Reads Excel file and converts it to XML or CSV according to the task input parameters. Task can read both .xslx and .xsl files. Images are not read. Only result values are red from cells containing a equation. Task does not check whether or not all specified sheets are read, or if all worksheet has same number of columns while converting to CSV. This kind of conditions have to be checked outside of task, e.g. with XSLT or schema.
path- Path of the Excel file to be read.
OutputFileType- Format output string as XML or CSV.
ReadOnlySheets- Specifies worksheets to be read. If none is specified task will read all sheets.
Output Result
String- Returns a string containing read information.
Example output of two worksheets
<workbook workbook_name="ExcelTestInput1.xlsx">
<worksheet worksheet_name="Sheet1">
<row row_header="1">
<column column_header="A">Foo</column>
<column column_header="B">Bar</column>
<column column_header="C">Kanji 働</column>
<column column_header="D">Summa</column>
</row>
<row row_header="2">
<column column_header="A">1</column>
<column column_header="B">2</column>
<column column_header="C">3</column>
<column column_header="D">6</column>
</row>
</worksheet>
<worksheet worksheet_name="OmituinenNimi">
<row row_header="1">
<column column_header="A">Kissa kuva</column>
<column column_header="B">1</column>
<column column_header="C">2</column>
<column column_header="D">3</column>
</row>
<row row_header="15">
<column column_header="A">Foo</column>
</row>
<row row_header="16">
<column column_header="B">Bar</column>
</row>
</worksheet>
</workbook>
Example output of one worksheet
Kissa kuva,1,2,3
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
,,,
Foo,,,
,Bar,,
Images of example Excel file
