Skip to main content

​
What is Stru Excel API?

The Stru Excel API enables dynamic generation of complex Excel calculation sheets and reports with an intelligent layout engine that automatically handles cell referencing. Build professional spreadsheets programmatically without managing specific cell addresses. Base URL: https://api.stru.ai/v1 Authentication: Bearer token (API key from app.stru.ai)

​
Core Concepts

Dynamic Generation

Create complete Excel workbooks from scratch by defining logical content blocks instead of specific cell ranges.

Intelligent Layout

The API automatically determines cell positions and formulas. Define =INPUT_A * FACTOR_B and the API resolves to =C5 * D10.

Template Support

Populate existing company templates with data using named ranges or dynamic generation.

Async Jobs

All operations run asynchronously. Submit a job, receive a job ID, poll for the generated .xlsx download URL.

​
Key Features

  • Intelligent Layout Engine: Define formulas logically (=INPUT_A * 2) without worrying about cell addresses
  • Multi-Sheet Support: Create workbooks with multiple sheets
  • Chart Generation: Automatically generate charts and graphs from data
  • Template Population: Fill existing templates with dynamic data
  • Formula Writing: Write Excel formulas as text (calculation happens when user opens the file)
  • Data Extraction: Parse existing .xlsx files to extract data
  • Secure Downloads: Generated files via time-limited signed URLs (24-hour retention)

​
Quick Start

1

Get Your API Key

Sign in to app.stru.ai and generate an API key.
2

Create a Spreadsheet Job

Submit a job to generate an Excel file.
curl -X POST https://api.stru.ai/v1/excel/jobs \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "operation": "create_spreadsheet",
    "workbook_name": "Project Summary",
    "sheets": [
      {
        "name": "Calculations",
        "blocks": [
          {
            "type": "header",
            "content": "Beam Design Summary"
          },
          {
            "type": "data_table",
            "headers": ["Parameter", "Value", "Unit"],
            "rows": [
              ["Span", 20, "ft"],
              ["Load", 2, "kip/ft"]
            ]
          }
        ]
      }
    ]
  }'
3

Poll and Download

Check status and download the generated .xlsx file.

​
Content Blocks

Build spreadsheets using these logical block types:

Headers

Add titles and section headers
{
  "type": "header",
  "content": "Project Summary"
}

Data Tables

Create formatted tables with headers
{
  "type": "data_table",
  "headers": ["Item", "Qty", "Cost"],
  "rows": [[...], [...]]
}

Formula Blocks

Add calculated values
{
  "type": "formula",
  "label": "Total",
  "expression": "=SUM(QUANTITIES)"
}

Charts

Generate charts from data
{
  "type": "chart",
  "chart_type": "bar",
  "data_range": "TABLE_1"
}

​
Common Workflows

Create project-specific dashboards tailored with exact data and charts needed.Use Case: Generate unique dashboards for each project/client
Generate detailed bill-of-materials from design model data.Use Case: Automated quantity extraction from ETABS/SAP2000
Automate custom-branded professional reports with calculations, tables, and charts.Use Case: Weekly progress reports, design summaries

​
Best Practices

Use named blocks - Reference blocks by name in formulas for automatic cell resolution
Structure logically - Organize sheets and blocks in a logical flow
Let the API handle layout - Don’t specify cell positions; let the intelligent layout engine optimize placement

​
Next Steps

Data Models

Understand request and response schemas

Create Spreadsheet

Learn how to generate .xlsx files