Spreadsheet (Smartbi)

Smartbi spreadsheet is a plug-in based on Excel spreadsheet office software. Smartbi spreadsheets can quickly implement report design and meet the needs of industry regulatory reports and internal management reports in various formats. Through the Smartbi spreadsheet plug-in, users can design reports directly in Excel and publish them to the Web. Friends who need it can download it.

SmartbispreadsheetFunction introduction

Extremely simple

Excel is the report designer

It is not an "Excel-like report designer" and does not reinvent the wheel; it is easy to learn and use, and has powerful functions that surpass existing report tools.

Ultimate functionality

Support various types of reports

Regardless of whether the report format is simple or complex, Smartbi spreadsheet supports them all;

Covers all types of reports supported by domestic and foreign reporting tools.

Business charts, beautifully presented

Supports all Excel graphics;

Combine basic graphics and create new graphics;

Business color matching, beautiful and elegant;

Rich analysis functions

Full support for Excel functions and formulas, including statistical functions, financial functions, mathematical and trigonometric functions, logical functions, etc.;

Support for defining new functions in Java.

Mobile display, cross-screen access

Provide APP to query and display reports and graphics on mobile phones/tablets

extreme speed

Powerful backend Java report engine; reports are presented in seconds

More features

As long as it takes 10 minutes to learn Smartbi spreadsheets, users can use the Excel skills they have mastered to design reports, make reports and reports with pictures and texts, and publish them to the browser (mobile APP) for report viewers to use.

Smartbi spreadsheet looks forward to your trial. The standard version can be downloaded and used from the official website, and includes free authorization for 10 registered users + 5 concurrent users, and its functions are consistent with the paid version.

We have been working hard, and this time we went to the extreme, and Sematic spreadsheet products were launched shockingly!

SmartbiSpreadsheet installation conditions

The user's computer must have office or WPS series office software installed in order to use the Smartbi spreadsheet plug-in normally.

SmartbiSpreadsheet plug-in installation

1. Download the Smartbi spreadsheet plug-in installation file from Huajun Software Park and double-click it with the left mouse button to open it.

2. After entering the installation program, you can see that the version is the latest version 8.5.6, click "Next" directly.

3. Click "Browse" to select the installation directory of the Smartbi spreadsheet. It is not recommended to install it on the C drive. If there are too many files on the C drive, it will affect the running speed of the computer. After selecting, click "Next".

4. The installation process of Smartbi spreadsheet takes about 2 minutes, please wait patiently.

5. After the installation is completed, just click the "Finish" button below.

SmartbiHow to use spreadsheets

1. After the installation is completed, reopen Excel, and the Smartbi function panel will appear at the top of the software.

2. After clicking the "Settings" button, enter the "Server URL", "Username" and "Password" in sequence, and then click "OK".

3. Click the "Login" button above. After successful login, the Smartbi data set panel will appear on the right side of Excel, so that you can use Excel to design reports. Come and try it.

SmartbispreadsheetChange log

Smartbi new features

1. [Self-service analysis] Group statistics

2. [Self-service analysis] Time dimension support

3. [Spreadsheet] Create jump rules in excel

4. [Spreadsheet] Filling in attributes supports regular expressions

5. [Spreadsheet] Parameter reference cell value

6. [Mobile terminal] Integrate with WeChat enterprise account

7. [Spreadsheet] Optimization of write-back and supplementary entries.

8. [Self-service analysis] Whether to display the total of classified summaries and add system option configuration

9. [Graphics] Support heat map

Complete functions

10. [Public] The installation package detects the system memory and sets the server recommended memory

11. [Public] Automatically optimize cache settings based on jvm memory

12. [Public] Update date control

13. [Self-Service Analysis] The total field name can be modified

14. [Self-service analysis] Individually control whether to display the resource tree

15. [Spreadsheet]: Binding the "server configuration information" in the setting interface and the plug-in configuration information

16. [Dashboard] Resource adds a quick print button.

17. [Public] Support custom upload icon

18. [Public] Macro resource package selection resource interface and data permission setting permission interface support search

19. [Public] Resource tree sorting optimization

Function changes

20. [Spreadsheet] Reference perspective analysis parameter modification

21. [Self-Service Analysis] The business theme is selected by default when creating a new creation.

22. [Public] Administrators export system logs without encryption

23. [Spreadsheet] The report is not automatically saved when previewing