PDF4me Excel icon

PDF4me Excel

Revolutionize Excel workflows with intelligent automation: dynamically manipulate spreadsheets, merge data seamlessly, secure files with enterprise-grade encryption, and extract insights through advanced row operations - all powered by cutting-edge PDF4me API technology

Delete Worksheet

AI-generated

Summary

Delete specified worksheets from an Excel file provided via binary data, base64 string, or URL, and output the modified Excel file with the selected worksheets removed.

Inputs

  • Excel File Input Method (required) — Specify how to provide the Excel file to process: from a previous node as binary data, as a base64 encoded string, or from a publicly accessible URL.
  • Binary Data Property Name (required) — If using binary data input, indicate the binary property name containing the Excel file.
  • Base64 Encoded Excel Content (required) — If using base64 input, provide the Excel file content as a base64 encoded string.
  • Excel File URL (required) — If using URL input, provide the publicly accessible web URL to download the Excel file.
  • Delete By (required) — Choose whether to delete worksheets by their names or by their index positions (1-based).
  • Worksheet Names — If deleting by names, provide a comma-separated list of worksheet names to delete.
  • Worksheet Indexes — If deleting by index, provide a comma-separated list of 1-based worksheet indexes to delete.
  • Output File Name — Specify the file name for the modified Excel file output after worksheet deletion.
  • Source Document Name — Name of the original Excel file for reference during processing.
  • Output Binary Data Name — Name to assign to the binary data property in the node output for accessing the processed Excel file.

Output shape

a single binary file containing the modified Excel file with the specified worksheets deleted

The output includes the processed Excel file as binary data under the specified output binary data name. If multiple input items are processed, the output is an array of binary files respectively. No additional JSON data is returned beyond the binary content and associated metadata.

Discussion