Spreadsheet Options

Spreadsheet options allow you to configure how Excel, CSV, and other spreadsheet formats are processed during parsing.

Available Options

Detect Sub-Tables

Find and extract sub-tables within spreadsheet cells. This is useful for spreadsheets that contain multiple logical tables within a single sheet.

{
  "input_options": {
    "spreadsheet": {
      "detect_sub_tables_in_sheets": true
    }
  }
}

Force Formula Computation

Re-compute spreadsheet cells containing formulas instead of using cached values. This ensures you get the most up-to-date calculated results.

{
  "input_options": {
    "spreadsheet": {
      "force_formula_computation_in_sheets": true
    }
  }
}

Performance Note: Enabling formula computation may impact performance for spreadsheets containing many formulas, as each formula needs to be re-evaluated.

Combined Configuration

You can combine multiple spreadsheet options:

{
  "input_options": {
    "spreadsheet": {
      "detect_sub_tables_in_sheets": true,
      "force_formula_computation_in_sheets": true
    }
  }
}

Complete API Request Example

cURL

curl -X 'POST' \
  'https://api.cloud.llamaindex.ai/api/v2/parse' \
  -H 'Accept: application/json' \
  -H 'Content-Type: application/json' \
  -H "Authorization: Bearer $LLAMA_CLOUD_API_KEY" \
  --data '{
    "file_id": "<file_id>",
    "tier": "agentic_plus",
    "version": "latest",
    "input_options": {
      "spreadsheet": {
        "detect_sub_tables_in_sheets": true,
        "force_formula_computation_in_sheets": true
      }
    }
  }'

Python

from llama_cloud import LlamaCloud

client = LlamaCloud(api_key="LLAMA_CLOUD_API_KEY")

result = client.parsing.parse(
    upload_file="example_file.xlsx",
    tier="agentic_plus",
    expand=["markdown"],
    input_options={
        "spreadsheet": {
            "detect_sub_tables_in_sheets": True,
            "force_formula_computation_in_sheets": True
        }
    }
)

TypeScript

import fs from "fs";
import { LlamaCloud } from "llama_cloud";

const client = new LlamaCloud({
  apiKey: "LLAMA_CLOUD_API_KEY",
});

const result = await client.parsing.parse({
  uploadFile: fs.createReadStream("example_file.xlsx"),
  tier: "agentic_plus",
  expand: ["markdown"],
  input_options: {
    spreadsheet: {
      detectSubTablesInSheets: true,
      forceFormulaComputationInSheets: true,
    },
  },
});