0004 How to read a single excel cell value
A practical Advanced ETL Processor example for building, testing, and adapting one automation workflow.
Use this example to build one working automation package, test it safely, and then adapt it to your own files, folders, or data rules. Start small. Automation is helpful; automated mistakes are just faster mistakes.
This Example Demonstrates how to read a single Excel cell value and email it
- Download and install Advanced ETL Processor [Link]
- Download and Unzip example [Link]
- Create a new package and open .wfp file
- Double click on Excel Operation Action Properties and change the file name, sheet and cell address
- Check cell variable (note variable #TOTAL_SALES# name)
- Select existing or create a new SMTP connection.
- Update email text (note #TOTAL_SALES# variable)
- Run the package by pressing the green arrow.
More Information
Related Advanced ETL Processor resources
For more automation examples, review the Advanced ETL Processor tutorials, read the WIKI, or download the Advanced ETL Processor Enterprise trial.