more quick actions
minimize quick actions
Provider Excel – UDC PcVue
Why Use the Excel Provider?
The Excel file format is essential in IT and automation, widely used for human-readable data exchange:
- Report data: Import Excel data into PcVue archives or display them in reports
- Third-party tools: Import/export data or configurations
Provider Overview
- Name : Excel
- Category : File System
- Global Features : Read / Write / Modify / Delete cells value
Write formula - Query Language : Simple Query Language (SQL)
- Works with: : 15.2
Key Advantages of the Excel Provider
- Saves time during application development
- Popular data exchange format (report data, third-party tools)
- No code to Read / Write Excel files (no bug, easy to evolve, best performances)
- Smart data extract (filtering, ordering, grouping)
- Perform calculations on data (min, max, sum, average…)
- Can write formulas that will be interpreted by Excel
- Support named cells and purpose smart cells selection
- Support for .xlsx, .xlsm, .xltx, .xltm, .xlsb, xlam files
- Do not need Excel installation/license to query Excel files