Description: A tool that allows you to import, manage, and display complex tables from Excel files directly on your website, offering advanced customization and interactivity options.
What is it for? (Practical examples)
This tool is essential for anyone who needs to present structured data clearly and functionally on their website:
- Product catalogs or price lists: Allows visitors to quickly sort and browse large lists of items.
- Business reports and statistics: Provides a professional display of complex numerical data while maintaining the original format integrity.
- Schedules or calendars: Enables insertion of tables with many rows, automatically managing pagination to avoid overloading the page.
Main features
The features are divided between data management in the control panel and block configuration on the site (Visual Builder).
- Data management:
- Uploading and saving Excel tables within the system.
- Displaying the active status of each table.
- Automatic view counting to monitor table usage.
- Interactivity on the site:
- Allows interactive sorting of data by clicking on column headers.
- Automatic pagination management to split long tables into defined pages.
- Option to keep the original Excel file’s graphic style (colors and formatting).
- Visual customization:
- Full control over background and text colors for headers and alternating rows.
- Ability to hide table borders.
- Application of predefined themes for a consistent look with the site.
How to configure it
Configuration takes place inside Visual Builder by selecting the "Excel Table" block.
Display options
| Option | Description |
|---|---|
| Select block | Allows choosing a previously uploaded Excel file managed in the admin panel. |
| Excel style | Maintains the original formatting (colors and styles) defined in the Excel file. |
| Header style | Applies a specific style to the table header. |
| Hide borders | Removes all visible cell and table borders. |
| Allow sorting | Enables functionality that lets users sort rows by clicking on column headers. |
| Maximum rows | Defines the maximum number of rows displayed per page (if sorting is enabled). The default value is 50. |
Color customization
You can define custom colors to override or complement the theme’s style.
| Area | Field | Description |
|---|---|---|
| Header | Header background | Background color of the table header. |
| Header text | Text color in the header. | |
| Alternating row | Alternating row background | Background color for even rows (zebra effect). |
| Alternating row text | Text color for even rows. |
Automatic integrations
Centralized table management
The system adds a dedicated menu item, "Excel Tables," in the admin panel. Here you can upload, update, and manage all Excel files that will then be used as blocks on the site.
Pagination and navigation
If sorting is enabled, the system automatically adds a navigation panel below the table that includes:
- Arrows to navigate between previous and next pages.
- An indicator showing the range of currently displayed rows (e.g., "1 – 50 / 125 rows").
Monitoring
The system performs an automatic operation for managing and saving data that tracks how many times each table has been viewed on the site.
