Excel Offline
Excel Offline is a data source type supported by Pirivision's Port module that lets you upload .xlsx files directly to Pirivision for offline analysis.
No external server, database, or network connection is required. Once a file is uploaded, SQL-like queries can be written against its sheets in the Compass module.
Strengths
| Feature | Description |
|---|---|
| Zero Infrastructure | No server, database, or network connection required |
| Quick Start | Upload, save, query the file — no setup |
| Offline Use | Once uploaded, no external connection is needed |
| Sheet Support | Each sheet in the file is queryable as a separate table |
| Easy Update | Replace with a new version quickly via Edit → Change |
| Download as Excel | Download the uploaded file again from Edit mode |
| Auto Column Detection | The header row is automatically used as field names |
What You Can Do in Pirivision
| Action | Description |
|---|---|
| Sheet Querying | Write SQL-like queries against Excel sheets in Compass |
| Multiple Sheets | Define different sheets in a single file as separate queries |
| Filter and Aggregate | Filter and summarize data using WHERE, GROUP BY |
| Static Reference Tables | Add fixed product, plant, or parameter lists to dashboards |
| Periodic Updates | Refresh dashboard data by updating the Excel file |
| KPI Card | Push numeric summaries to a Cartography Text widget |
When To Use
- Monthly / Weekly Reports: Visualize production, energy, or quality reports received as Excel
- Reference Tables: Static parameters such as plant lists, product codes, target values
- Budget & Planning: Excel plans for target vs. actual comparisons
- Quick Prototype: Build a dashboard with Excel data before the database is ready
- Historical Data: Analyze past period data not yet imported into the system
Connection Requirements
| Information | Required | Description |
|---|---|---|
| Name | Yes | Data source display name |
| Excel File (.xlsx) | Yes | The file to upload |
| Description | No | Optional description |
Supported Format
Only .xlsx (Excel 2007 and above) is supported. .xls, .csv, or .ods files cannot be uploaded directly.
Guides
| Guide | Description |
|---|---|
| Add Excel Offline Data Source | Create a new Excel data source in the Port module |
| Edit Excel Offline Data Source | Update the uploaded file |
| Move Data Source | Move to a different folder |
| Duplicate Data Source | Copy with the same settings |
| Delete Data Source | Remove the data source |