Man illustrationFlower illustration

Docy

Clear sheet

Estimated reading: 1 minute 68 views

Clear sheet activity performs the process of deleting a page in an Excel file or the desired area in the page.


*Excel nameThe name of the Excel file that was opened or created before is selected.
Sheet nameName of the sheet to work in Excel, if not added it takes the first sheet by default.
RangeExcel sheet range from which to fetch data.
Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name file name as shown in the example.

Sheet1

You can use the Range name as shown in the example

A1:C5

If it is desired to delete a certain range in the page rather than a page in the Excel file, the range is given. If the range is not given, the entire inside of the sheet is deleted.

If the first page of the excel files will be processed, the sheet name fields do not have to be filled. Otherwise, it must be filled.

CONTENTS