Excel File Destination

Astera Excel File Destination provides the functionality to write data to Microsoft Excel workbooks. Excel File Destination does not need Microsoft Excel to be installed on the machine. Excel File Destination enables you to specify worksheet and starting cell where the write actually begins.

Appending to Existing Files and Worksheets

You can choose to append to an existing worksheet or create a new worksheet. You can also choose to write to an existing file or create a new file. If you choose to create a new file, any existing file will be overwritten.

Writing to Multiple Excel Worksheets

Astera enables you to write to multiple Excel worksheets from within a single dataflow. When you specify the same file in multiple Excel destinations, Astera creates a single file with multiple worksheets and writes all data to that file.

Steps

Adding an Excel File Destination object allows you to write to an Excel file. An example of what an Excel file destination object looks like is shown below:

To configure the properties of an Excel Destination object after it was added to the dataflow, right-click on it and select Properties from the context menu.

Note: To ensure that your dataflow is runnable on a remote server, please avoid using local paths. Using UNC paths is recommended.

Field Layout

The Field Layout screen is available in the properties of most objects on the dataflow to help you specify the fields making up the object. The table below explains the attributes you can set in the Field Layout screen:

The table below provides a list of all the attributes available for a particular layout type:

Last updated

© Copyright 2023, Astera Software