SaveAsNewExcelFile

SaveAsNewExcelFile

What to use it for

Prerequisites for usage

Essential options to set

Use SaveAsNewExcelFile as an Activity to save an object that you have in memory (i.e. stored in a variable) to an Excel file.

 Read more
  • Use SaveExcelFile in case you want to save changes to an existing Excel file that you are processing.
  • Use SaveAsNewExcelFile in case you want to either:
    • Save data that did not originate from an Excel file.
    • Leave an existing Excel file untouched, by saving the processed Excel data to a new Excel file.

More documentation about open office xml excel package can be found here.

None.
  • Path
  • Object

Misc

OptionWhat is itHow to use it
Path

 

Path is the path to an Excel file.

Enter an absolute path, using file name and extension. You can use path in two ways:

  • Path to an existing file.
  • Path to where you want to create a new file.
    • Use this option in combination with the next option.
Excel object

 

Option to get the file contents from a variable, to save to the Excel file.

Enter the name of a variable that currently holds the data.

Excel Activities