Skip to main content
PDF4me APIIntegrationsKnowledge BaseExtensionsAPI TesterBlog

Delete Worksheet from Excel - Workbook Cleanup for Make

What this module does

PDF4me Delete Worksheet from Excel removes one or more worksheets by names and/or indexes from Excel workbooks within Make scenarios, with automatic safety validation ensuring at least one worksheet always remains. Uses union logic when both names and indexes are provided, handles duplicate selections gracefully, and processes template cleanup, calculation sheet removal, and rolling archive maintenance workflows. Works with Google Drive, Dropbox, SharePoint, and cloud storage platforms.

Names and indexes combine with union logic

When you provide both Worksheet Names and Worksheet Indexes, the module deletes the union of all worksheets matched by either selector. Duplicate overlaps (a name that refers to the same tab as an index) are handled automatically with no error. Leave both fields empty and the module will error — at least one selector must be provided, and at least one worksheet must survive deletion.

Worksheet indexes are 1-based in this module

Worksheet Indexes uses 1-based numbering — worksheet 1 is the first tab, 2 is the second. Provide a comma-separated string like "1,3" to delete the first and third worksheets. This differs from the Add Text Watermark module which uses 0-based indexing, so always verify index conventions when building multi-module Excel scenarios.

Build dynamic deletion lists for rolling archive maintenance

For rolling 12-month workbooks, use a Set Variable step to build a comma-separated list of worksheet names older than the retention window (e.g., "Jan2024,Feb2024") and map it to Worksheet Names. This enables fully automated monthly archive maintenance without hardcoding worksheet names, keeping file size and performance optimal as new month sheets are added.

Authenticating Your API Request​

To access the PDF4me Web API through Make, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Make scenarios and PDF4me's Excel worksheet management services.

Get your API Key
Delete Worksheet Excel Make

Key Features​

  • Delete by Names or Indexes with union selection logic
  • Multiple Worksheets in one operation
  • Safety Validation to prevent deleting all worksheets
  • Flexible Selection: Combine names and indexes for comprehensive targeting
  • Graceful Duplicate Handling: Duplicate selections automatically resolved

Parameters​

Complete list of parameters for the Delete Worksheet from Excel module. Configure these parameters to control worksheet deletion behavior.

Important: Parameters marked with an asterisk (***) are required and must be provided for the module to function correctly. At least one worksheet must remain after deletion.

ParameterTypeDescriptionExample
File Name***StringExcel Document Name
• Filename with .xlsx or .xls extension
• Used for output identification
• Supports dynamic naming from scenario variables		data.xlsx
Document***BufferExcel File Content
• Map from previous module (Drive/Dropbox/HTTP)
• Binary Excel document for worksheet deletion
• Workbook must contain at least 2 worksheets		[Buffer]
Worksheet NamesStringDeletion by Name
• Comma-separated list of worksheet names to delete
• Exact case-sensitive matching required
• Example: "Temp,Draft,Old" deletes three worksheets
• Combined with Worksheet Indexes via union logic		Temp,Draft,Old
Worksheet IndexesStringDeletion by Index (1-based)
• Comma-separated list of worksheet indexes
• 1 = first worksheet, 2 = second, etc.
• Example: "1,3" deletes first and third worksheets
• Combined with Worksheet Names via union logic		1,3

Output​

The PDF4me Delete Worksheet from Excel module returns comprehensive output data for seamless Make scenario integration:

Table View

Response data in a structured table format:

ParameterTypeDescription
NameStringOutput Excel filename
Doc DataBufferExcel workbook with specified worksheets deleted

Scenario Examples​

The PDF4me Delete Worksheet from Excel module in Make provides comprehensive scenario templates designed for real-world workbook management needs:

Automated Template Sample Worksheet Removal Workflow

Prepare distribution-ready templates by removing sample worksheets automatically:

Complete Scenario Steps:

  1. Trigger: Template marked ready for distribution in content management system
  2. Get Master Template: Retrieve template workbook with sample worksheets from library
  3. Identify Sample Worksheets: Worksheets named "Sample Data", "Example", "Instructions"
  4. Delete Sample Worksheets: Remove "Sample Data,Example,Instructions" by name
  5. Preserve Core Worksheets: Main worksheets ("Template", "Reference") retained
  6. Verify Worksheet Count: Ensure at least one worksheet remains after deletion
  7. Upload Clean Template: Save distribution-ready template to public folder
  8. Email Users: Notify team of new clean template availability with download link
  9. Archive Sample Version: Store template with samples in archive for reference
  10. Update Template Registry: Mark template as distributed in content registry

Business Benefits:

  • Prepares 20+ templates monthly for distribution automatically
  • Removes sample worksheets preventing user confusion
  • Reduces template file size by 30-50% on average
  • Saves 20 minutes per template in manual worksheet cleanup

Industry Use Cases & Applications​

  • Client Report Finalization: Remove internal calculation and assumption worksheets from client financial reports
  • Budget Template Cleanup: Delete previous year worksheets from budget templates for new fiscal year
  • Audit File Preparation: Remove draft and working paper worksheets before audit file archival
  • Rolling Forecast Maintenance: Delete obsolete month worksheets from 12-month rolling forecast workbooks
  • Consolidation Cleanup: Remove individual entity worksheets after consolidation sheet creation

Get Help​

Make IntegrationGet your API KeyMake Documentation