PDF4me ExcelInstall

Summary

Delete specified rows from an Excel file's worksheet(s) by providing the file via binary data, base64 string, or URL, specifying the row ranges to remove, and output the modified file in binary form.

Inputs

• Excel File Input Method (required) — Choose how to provide the Excel file for processing: from previous node binary data, base64 string, or download from URL.
• Binary Data Property Name (required) — Name of the binary property containing the Excel file (required if input method is binary data).
• Base64 Encoded Excel Content (required) — Base64 encoded string of the Excel file data (required if input method is base64).
• Excel File URL (required) — Public URL to download the Excel file from (required if input method is URL).
• Worksheet Name — Name of the worksheet to delete rows from; leave empty to delete rows from all worksheets.
• Row Ranges (required) — Comma-separated row indices or ranges to delete (e.g., "1-5,10,15-20").
• Output File Name — Filename for the resulting Excel file with rows deleted.
• Source Document Name — Name representing the original Excel file for reference during processing.
• Output Binary Data Name — Name to assign to the output binary data property containing the modified Excel file.

Output shape

binary data of the Excel file with specified rows deleted

The output file is returned as binary data, accessible via the specified output binary data name. If worksheet name is omitted, deletion applies to all worksheets. Errors halt execution unless 'Continue On Fail' is enabled.

Examples

Example 1: Delete rows 1-5 and 10 from 'Sheet1' of an Excel file passed as binary data from a previous node and output the modified file as 'excel_rows_deleted.xlsx'

Set input method to 'From Previous Node (Binary Data)', specify binary property name, set worksheet name to 'Sheet1', row ranges to '1-5,10', output file name to 'excel_rows_deleted.xlsx'