Skip to content
Novus Examples
xlsx6.3 KB

Juniper Workspace Cloud: Register of members workbook

Register of members workbook for Juniper Workspace Cloud. A two-sheet workbook holding the register and the capitalisation table. The register sheet has no total row and the cap table sheet does, so a reader that assumes the last row of a sheet is data on one and a total on the other gets both wrong.

Rendered preview of Juniper Workspace Cloud: Register of members workbook

Rendered preview of the xlsx file (6.3 KB). Download above for the original.

Specifications

Document Set
corporate
Industry
software
Source Kit
saas-subscriptions
Entity
Juniper Workspace Cloud
Synthetic
true
As Of
2026-09-08
Sheets
2
Members Rows
4
Cap Table Rows
5
Cap Table Has Total Row
true

Testing contract

Expected to pass
Scenario
Read both sheets and decide for each whether its last row is a data row.
Expected result
Members has 4 data rows and no total; Cap table has 4 data rows and a total row whose member_id and class cells are empty.

What is a .xlsx file?

XLSX is the default Microsoft Excel format, an Office Open XML spreadsheet stored as a ZIP archive containing worksheet XML, shared strings, styles, and formulas. It supports multiple sheets, cell formatting, charts, and calculated values. It is the standard for editable tabular workbooks.

How to use this file

Use an example XLSX to test spreadsheet parsing, formula and multi-sheet handling, shared-string extraction, and pipelines that read or generate Excel workbooks.

How to use this file for testing

“Juniper Workspace Cloud: Register of members workbook” is a deterministic Novus Examples fixture for Data import. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.

Documented properties for this file: 2 sheets. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.

Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.

Document fixtures list their internal structure (pages, fields, tracked changes, embedded objects) in the spec table. Test extractors, converters, and OCR against that known structure, and compare searchable↔scanned or format-twin companions when present.

Code examples

from openpyxl import load_workbook

wb = load_workbook("register-of-members.xlsx")
ws = wb.active
print(ws.title, ws.max_row, ws.max_column)

Generated by generation/industry_documents_two.py. Free for any use, no attribution required, license.