Add- in A-Tools: Query, Share and manage Excel workbook on LAN, internet
Add- in A-Tools allows sharing and managing Excel workbook on LAN, internet. Users to manage Excel workbook powerful on the network, allow connect to the spreadsheet over TCP/IP (not full share folder - Excel's way), manage connections to the data ranges, setting rights for each user group: read only, edit, limit how many people are connected ,....,When data is changed on worksheet then other computers on LAN, internet are updated immediately (after about ~ 1 millisecond).
Add-in A-Tools can create dynamic reports by using the functions to query the database (DB) with T-SQL language. It also allowers users to connect to the internal and external database such as Excel, Access, Foxpro, MS SQL, MySQL and Firebird,... for instance. The "SQL Builder" helps users to create a query formula (with BS_SQL function) easily and efficiently. Users are able to create highly sophisticated worksheets which are filtered according to various conditions and associated with different data sources. In that way, accuracy, stability and high speed are ensured.
- (with Microsoft Excel 2007 or more advanced ): After starting Mircrosoft Excel 2007 and selecting menu A-Tools, the function of the A-Tools is shown as below:
- With Microsoft Excel 2003 or lower
Share and manage Excel workbooks on LAN, internet (network):.
Add- in A-Tools allows sharing and managing Excel workbook on LAN, internet. Users to manage Excel workbook powerful on the network, allow connect to the spreadsheet over TCP/IP (not full share folder - Excel's way), manage connections to the data ranges, setting rights for each user group: read only, edit, limit how many people are connected ,....,When data is changed on worksheet then other computers on LAN, internet are updated immediately (after about ~ 1 millisecond).
Query data on worksheet:
Add-in A-Tools can create dynamic reports by using the functions to query the database (DB) with T-SQL language. It also allowers users to connect to the internal and external database such as Excel, Access, Foxpro, MS SQL, MySQL and Firebird,... for instance. The "SQL Builder" helps users to create a query formula (with BS_SQL function) easily and efficiently. Users are able to create highly sophisticated worksheets which are filtered according to various conditions and associated with different data sources. In that way, accuracy, stability and high speed are ensured.
A-Tools provides APIs function and COM objects as BSNetwork, BSFormulaArray for users to fully exploit A-Tools and strengthen their applications. In otherwords, the user interface is easy and convenient.
The extra functions:
- Build statistical formulas associated with multiple conditions.
- Convert text / number to words, ....
The main functions:
- Create Server (Excel Server) on Excel for sharing Excel files. Any computer can create server
- Manage Server
- Share workbook, worksheet/spreadsheet, regions/range in spreadsheet for sharing on the network
- Manage Groups and Users to access/connect to server
- Setup rights for groups: open sheet, regions/range; modify or read-only; format; copy; print;...
- Manage list of users connected: build black list or connection list, manage user online
- View list of users connected and chatting
- Functions support for editing and updating data on server
- Management Excel reports on the network (LAN), support commands: Check; Approve; Dis-Approve. Under each command the user is not allowed to copy data, printing, modify report.
- Manage the history Excel files in the server, users can open them again if they have the right.
- Query data on worksheet by fubction BS_SQL() or SQL Builder
- Connect to the external database: Excel, Access, MySQL, Firebird,…
- Create dynamic report
- Create function for Function BS_SQL()
- Create statistical formulas with multiple conditions
- Convert text, number to words
- Developers can program their applications with A-Tools.
