Excel File Formatting

Get Help & Discuss
, ,
1

How can we format the excel output file in specific format ??

2

To format the Excel output file in a specific format in AutomationEdge, you can use a pre-formatted template approach

Step 1: Create a Pre-Formatted Template

  1. Create an Excel file manually.

  2. Apply the required formatting:

    • Header font (bold, size, color)

    • Background color

    • Borders

    • Column width

    • Alignment

    • Number/date format

  3. Save the file as a template, e.g., Salary_Template.xlsx.

Step 2: Use Microsoft Excel Writer in Process Studio

Add the Microsoft Excel Writer step and configure it as follows:

Template Name:
Provide the full path of the formatted template file.
Example:
C:\AutomationEdge\Templates\Salary_Template.xlsx

Template Sheet Name:
Specify the exact sheet name from the template.
Example:
Sheet1 or SalaryReport

Start Writing Cell:
Mention the cell from where data should be written.
Example:
A2 (if row 1 contains formatted headers)

Write Header:

  • Yes – if headers need to be written dynamically

  • No – if headers are already present in the template

Output File Path:
Provide the final path where the formatted output file should be generated.