Man illustrationFlower illustration

Clear sheet

Estimated reading: 2 minutes 235 views

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


*Excel nameThe reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet nameName of the sheet to work in Excel, if not added it takes the first sheet by default.
Sheet indexIndex of the sheet to work in Excel. If not added, it takes the first sheet by default.
RangeExcel sheet range from which to clear data is written.
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 Sheet index as shown in the example.

5

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 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.

Share this Doc

Clear sheet

Or copy link

CONTENTS
Chat Icon Close Icon