• Introduction
    • 0.1. XBRL
    • 0.2. Cell stores
    • 0.3. Cell store vocabulary
    • 0.4. Analogy with spreadsheets
  • 1. The REST API
    • 1.1. Endpoints
    • 1.2. Output formats
    • 1.3. Common parameters
    • 1.4. Language bindings
  • 2. Entities
    • 2.1. List entities
    • 2.2. Identify entities
    • 2.3. Entity metadata
    • 2.4. Add an entity
    • 2.5. Delete an entity
    • 2.6. API reference
  • 3. Archives
    • 3.1. List archives
    • 3.2. Look up an archive
    • 3.3. Archive metadata
    • 3.4. Available periods
    • 3.5. Add an archive
    • 3.6. Delete an archive
    • 3.7. API reference
    • 3.8. API reference (copy archives)
    • 3.9. API reference (periods)
  • 4. Taxonomies
    • 4.1. API reference
  • 5. Sections
    • 5.1. List sections
    • 5.2. Identify sections
    • 5.3. Section metadata
    • 5.4. Add a section
    • 5.5. Delete a section
    • 5.6. API reference
  • 6. Components
    • 6.1. List components
    • 6.2. Identify components
    • 6.3. Component metadata
    • 6.4. Component by data points
    • 6.5. API reference
  • 7. Report elements
    • 7.1. Kinds of report elements
    • 7.2. List report elements
    • 7.3. Identify report elements
    • 7.4. Report element metadata
    • 7.5. Add a report element
    • 7.6. Delete a report element
    • 7.7. API reference
  • 8. Facts
    • 8.1. List facts
    • 8.2. Hypercube queries
    • 8.3. Slicers and dicers
    • 8.4. Aggregation
    • 8.5. Default dimension values
    • 8.6. Other fields
    • 8.7. Labels
    • 8.8. Facts
    • 8.9. Facts API reference
    • 8.10. API reference (fact table for component)
    • 8.11. API reference (fact table for report)
  • 9. Model Structures
    • 9.1. Hierarchies
    • 9.2. Get a model structure
    • 9.3. Model structure metadata
    • 9.4. Add a model structure
    • 9.5. Delete a model structure
    • 9.6. API reference
  • 10. Labels
    • 10.1. List labels
    • 10.2. Identify labels
    • 10.3. Label metadata
    • 10.4. Add a label
    • 10.5. Delete a label
    • 10.6. API reference
  • 11. Rules
    • 11.1. List rules
    • 11.2. Rule metadata
    • 11.3. API reference
  • 12. Spreadsheets
    • 12.1. View a spreadsheet
    • 12.2. Select or eliminate cells
    • 12.3. Validating cells
    • 12.4. Slicing and dicing
    • 12.5. API reference (spreadsheet for component)
    • 12.6. API reference (spreadsheet for report)
  • 13. Data points
    • 13.1. API reference
  • 14. Complete API Reference
  • 15. Changelog
  • 16. Installation
    • 16.1. CURL
    • 16.2. Docker
    • 16.3. Platform
    • 16.4. Portal
    • 16.5. Infoset Generator
    • 16.6. CellStore
    • 16.7. CellStore Manager
  • Published with GitBook

Cell Store Documentation v26.8.0

View a spreadsheet

A spreadsheet can be generated given a component or a report with the same parameters as those that identify a component.

For example, this displays a balance sheet:

[Public datalake] Spreadsheet viewing

curl -X GET "http://secxbrl.28.io/v1/_queries/public/api/spreadsheet-for-component?aid=S1004KWM-2&format=html§ion=http%3A%2F%2Fdisclosure.edinet-fsa.go.jp%2Frole%2Fjppfs%2Frol_BalanceSheet&hypercube=jppfs-cor%3ABalanceSheetTable&token=c3049752-4d35-43da-82a2-f89f1b06f7a4"

By default, English is displayed. With the language parameter, we can switch to Japanese:

[Public datalake] Spreadsheet viewing

curl -X GET "http://secxbrl.28.io/v1/_queries/public/api/spreadsheet-for-component?aid=S1004KWM-2&format=html§ion=http%3A%2F%2Fdisclosure.edinet-fsa.go.jp%2Frole%2Fjppfs%2Frol_BalanceSheet&hypercube=jppfs-cor%3ABalanceSheetTable&language=ja&token=c3049752-4d35-43da-82a2-f89f1b06f7a4"