Clearing worksheets

Overview

The [highlight txt=’clear worksheet’] instruction allows a user to clear all the contents and the formatting of all cells within a particular Excel worksheet.

Before we get started

For the purposes of this article, it would be preferable if you can have at hand a Excel file containing data and formatting. Please also create a data step with a ‘File upload/download’ property and upload the file into the property. Please further create a ‘Manipulate a file’ or ‘Multiple file manipulations’ action step so that you can add and use instructions. The file that this article will refer to looks like this:

Steps

1. Create a ‘Clear worksheet’ instruction.

2. Link the file.

3. Select a worksheet. Here, we will select Sheet1.

6. Save and run the step.

7. If you open the file after the step finishes running, you will see that the worksheet is completely empty.

Recent Posts

Leave a Comment

Contact Us

To learn more about SolveXia, please use the form below to send us an email. One of our team members will contact you.

Not readable? Change text. captcha txt

Start typing and press Enter to search