windows automation Sitemap | About us | Contact | Affiliates  
 Automate your repetitive tasks with ease Home Features Download Purchase Support  

Example Job: Copy Data from one Excel file to another  (view all examples)

This job reads a list of products from an Excel workbook and copies them to a new workbook by dividing the products in different worksheets based on their availability.

The downloadable zip archive contains the excel file Inventory.xls along with the actual example job.


Download this example job


(The example job is the XML file included in the zip file.
To import a job and run it in WinAutomation you must choose File -> Import Job
from the WinAutomation Console's main menu)

The example Excel file that contains the Products List (Inventory.xls):

example excel file for read write

The new Excel workbook generated by the job:
(Note that the products are written in different sheets depending on their availability)


The Job:

automate excel read write example


Variables used in this example:

automate excel read write variables


Related Examples:

 

download windows automation windows scripting

Total Automation Support

Have your automation jobs built for free! Check our Total Automation Support now.

Read more

 
Video Tutorials

Check our complete series of video tutorials to find out how easy it is to automate your repetitive tasks using WinAutomation

WinAutomation Automation Software Tutorials

View Tutorials

  © 2005-2008 - Softomotive - All rights reserved