Encodian – Excel Connector

CSV – Parse
Parses CSV data into a JSON array, supporting custom delimiters, text qualifiers, and encoding options for downstream automation.
CSV – Parse →

Excel – Add Image Header or Footer
Inserts an image into the header or footer of an Excel worksheet, configurable for position (left, center, right).
Excel – Add Image Header or Footer →

Excel – Add Rows
Adds one or more rows of data to an Excel worksheet, mapping values into defined columns.
Excel – Add Rows →

Excel – Add Text Headers and Footers
Adds text-based headers and footers to Excel worksheets with support for left, center, and right sections.
Excel – Add Text Headers and Footers →

Excel – Add Text Watermark
Applies a repeating text watermark across Excel worksheet pages with customizable font, size, and style.
Excel – Add Text Watermark →

Excel – Delete Rows
Removes rows from an Excel worksheet based on matching conditions or index range.
Excel – Delete Rows →

Excel – Delete Worksheets
Deletes one or more specified worksheets from an Excel workbook.
Excel – Delete Worksheets →

Excel – Extract Rows
Extracts rows matching defined filter criteria into a new dataset (JSON or Excel file).
Excel – Extract Rows →

Excel – Extract Worksheets
Splits an Excel workbook by extracting selected worksheets into standalone files.
Excel – Extract Worksheets →

Excel – Merge Files
Combines multiple Excel workbooks into a single workbook, consolidating worksheets.
Excel – Merge Files →

Excel – Merge Rows
Merges data from multiple rows from various files into a single worksheet, using a delimiter or aggregation rule.
Excel – Merge Rows →

Excel – Merge Worksheets
Merges the specified worksheets into a single worksheet.
Excel – Merge Worksheets →

Excel – Populate
Populates an Excel template with provided JSON data, dynamically inserting values into mapped cells.
Excel – Populate →

Excel – Remove Headers and Footers
Removes all text and image headers/footers from an Excel workbook.
Excel – Remove Headers and Footers →

Excel – Remove Text Watermark
Detects and removes text watermarks from Excel worksheets.
Excel – Remove Text Watermark →

Excel - Rename Worksheets
Renames specified worksheets within the workbook/file provided.
Excel - Rename Worksheets →

Excel – Replace Text
Finds and replaces text within Excel worksheets with support for match options (exact, partial, case-sensitive).
Excel – Replace Text →

Excel – Secure
Applies password protection and security restrictions (open, modify, print) to Excel files.
Excel – Secure →

Excel – Separate Worksheets
Splits a multi-worksheet Excel file into multiple workbooks, one per worksheet.
Excel – Separate Worksheets →

Excel – Unlock
Removes password protection and restrictions from secured Excel files (when password is provided).
Excel – Unlock →

Excel – Update Rows
Updates existing rows in an Excel worksheet by matching filter conditions and replacing specified cell values.
Excel – Update Rows →

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk