Write Data-list to Excel File
The write data-list to excel file command will take any data-list and write to an excel file starting from cell A1.
|Header options||text||manual-only||true||Allows you to write the fields as headers, remove the headers completely or keep the existing header values of the file and just write the values|
|Fields||data-field||link-manual||true||Fields are the header values that will be written to the first row of the sheet when the header option is
|File path||text||link-manual||true||The path to the excel file you want to write to|
|Worksheet name||text||link-manual||true||The sheet name inside of the excel file you want to target|
|Data rows||data-list||link-manual||true||The data-list you want to write to the file|
- The user has a data-list that contains anything and wants to write the values inside of the data-list to an excel file.
- The user has a data-list that contains anything and wants to write values without the headers to an excel file.
- The user has a data-list that contains anything and wants to keep the current headers in the excel file and just write the data-list values to the excel file.
What does the header options do
|No headers||This will remove what ever is inside of the first row and overwrite it with the values inside the data-list|
|Skip headers||This will keep what ever is inside of the first row and write the values inside the data-list starting from cell
- Header options:
name, text; surname, text;
- File path:
- Sheet name:
- Data rows:
- If the
file pathvalue is empty, the process will stop and provide you with this error
Excel file path is required
- When the
file pathcannot be found, the file will be created at the specified path with the file name specified with the path
- When the
sheet namecannot be found, the sheet name will be created throught the process
- When the headers are there but there are no values underneath the headers, make sure that your
Fieldsand data-items inside of your
Data rowsare the same
write values to excel