Exporting to Excel

Overview

The export to Excel instruction allows a user to export data from a Managed Table to an Excel worksheet.

For the purposes of this article we are going to use a simple and fictitious Managed Table named “AirlineInfo”. You will want to replace this Table with one of your own.

Before we get started

Please further create a ‘Manipulate a file’ or ‘Multiple file manipulations’ action step so that you can add and use instructions.

The Managed Table has the following design:

The target file that we are going to use is a standard fresh Excel workbook which contains 3 empty worksheets.

Steps

1. Create an ‘Export to Excel’ instruction.

2. Link the Managed Table named “AirlineInfo” as the source.

3. Tick the box for the ‘Include column headings?’ rule.

4. Link the file named “Target” as the target file.

5. Use Sheet1 from the target file.

6. Use cell address A1 from Sheet1.

8. Save and run the step.

9. After the step finishes running, download and open the target file. As you can see, the Table has been completely re-designed to match the structure of the Excel data:

Leave a Reply

Latest Tweets

Free eBook: 10 Tips for sourcing good data yucalc.com/2017/02/17/fre…

reply · retweet · favorite

Newsletter

By signing up, you agree to our Terms of Service and Privacy Policy.

Address

Suite 1506, Westfield Tower 2, 101 Grafton St Bondi Junction NSW 2022 Australia

View Larger Map

Contact Us

AUS: +61-2-9386-0202
UK: +44-20-8123-1251
Send us an email

ContactUs.com
WordPress Image Lightbox