Categories

XLSX Append Incremental

Append new rows incrementally and emit next processing cursor based on time or primary-key column

Incrementally append new records into an existing workbook.

  • Filter incoming rows by cursor column and last cursor value
  • Supports time cursor or primary-key cursor
  • Emits updated workbook + cursor JSON in one ZIP package

Example Results

1 examples

Append Incremental Data and Emit Next Cursor

Append rows newer than last cursor and return updated workbook with cursor JSON in ZIP

xlsx-append-incremental-example1.zip View File
View input parameters
{ "baseWorkbookFile": "/public/samples/xlsx/workbook-sales.xlsx", "incrementalWorkbookFile": "/public/samples/xlsx/workbook-sales.xlsx", "targetSheetName": "Tools API", "cursorMode": "primary-key", "cursorColumn": "id", "lastCursorValue": "5" }

Click to upload file or drag and drop file here

Maximum file size: 200MB Supported formats: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel

Click to upload file or drag and drop file here

Maximum file size: 200MB Supported formats: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel

Key Facts

Category
Format Conversion
Input Types
file, text, number, select
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

Incrementally append new records into an existing workbook. - Filter incoming rows by cursor column and last cursor value - Supports time cursor or primary-key cursor - Emits updated workbook + cursor JSON in one ZIP package

When to Use

  • Use it when you need to process xml, xlsx content quickly in the browser.
  • Helpful for format conversion workflows that need repeatable inputs and fast results.
  • A good fit when you want to test with real files before running the same workflow in code or API calls.

How It Works

  • Provide Base Workbook, Incremental Workbook, Target Sheet Name, Header Row as input to the tool.
  • The tool processes the request and returns a file result.
  • For file workflows, start with representative samples such as xml, xlsx test files to verify edge cases and output quality.

Use Cases

Process xml, xlsx data during debugging or QA.
Validate expected output before using the API or automation flows.
Test the workflow with representative sample files and edge cases.

Try with Samples

xml, xlsx, xls

Related Hubs

FAQ

What does XLSX Append Incremental do?

XLSX Append Incremental helps you process xml, xlsx content online without setting up a separate local script or app.

When should I use this tool?

Use it when you need a quick process workflow, want to verify output, or need a browser-based utility for format conversion tasks.

Can I try this tool with sample data?

Yes. This page can recommend related sample files so you can test the workflow immediately.

What inputs does XLSX Append Incremental accept?

XLSX Append Incremental accepts Base Workbook, Incremental Workbook, Target Sheet Name, Header Row and supports file uploads for 2 fields.

Is there an API for XLSX Append Incremental?

Yes. The tool page includes an API endpoint so you can move from manual testing to scripted usage.

API Documentation

Request Endpoint

POST /en/api/tools/xlsx-append-incremental

Request Parameters

Parameter Name Type Required Description
baseWorkbookFile file (Upload required) Yes -
incrementalWorkbookFile file (Upload required) Yes -
targetSheetName text No -
headerRow number No -
cursorMode select No -
cursorColumn text Yes -
lastCursorValue text No -

File type parameters need to be uploaded first via POST /upload/xlsx-append-incremental to get filePath, then pass filePath to the corresponding file field.

Response Format

{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}
File: File

AI MCP Documentation

Add this tool to your MCP server configuration:

{
  "mcpServers": {
    "elysiatools-xlsx-append-incremental": {
      "name": "xlsx-append-incremental",
      "description": "Append new rows incrementally and emit next processing cursor based on time or primary-key column",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=xlsx-append-incremental",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

Supports URL file links or Base64 encoding for file parameters.

If you encounter any issues, please contact us at [email protected]