You are here FEATURES

Query, Share and Manage Excel workbooks on LAN, Internet

Add-in A-Tools for Excel

logoa-tools

Add-in A-Tools: Query, Share Excel file on LAN, internet with multiple users

Add-in A-Tools allows sharing and managing Excel file on LAN, internet. Someone can open Excel file in server at the same time for editing and saving. Clients connect to server by TCP/IP protocol (not share full folder - Excel's way), server manage connections with restrict users,  setting rights for each user group: read only, edit, limit how many people can open a worksheet,....,When data in spreadsheet is changed then other computers on LAN, internet are updated immediately (after about ~ 1 millisecond).

How can I do with Add-in A-Tools?
1) Share Excel files over the Network among users. Client connect to server by TCP/IP protocol, login with IP address, Domain
2) Restrict Users to sheets, range address, workbook
3) Restrict Users to edit only certain Cells in that sheet
4) Restrict Users to print, copy sheet

5) Some users can edit at the same time on sheet but can not clear or change data of others. User is leader can change data of users who in the same group.

6) User have rights "Approve" can approve rows in sheet or all sheet so all users in network can not edit when rows, sheet have approved.

7) Chat with other in Excel.
8) Query data on sheet by execute SQL language. Connect to any database in your computer and link data to sheet. With function BS_SQL you can create professional.reports for high speed with large data in sheet, so very easy with draw and drop by mouse on SQL Builder.

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.

Add-in A-Tools 2017 - v7.3.0.1 - Updated 2017-08-23 (yyyy-mm-dd) - The Power of Network and Query in Excel
v7.3 has Drilldown report in Excel
menu-atools
A-Tools is a power add-in for Microsoft Excel with: share excel file on LAN, internet. Query function by execute T-SQL on sheet for creating report  - high speed with large data on sheet. It has the main functions :

Share Excel file on LAN, internet with multiple users:.

poster-atools

(Video Part 2)

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).

poster-atools
Excel  Server setup Excel files, sheets to share on LAN, Internet
poster-atools
Excel  Client can connect to server (any computer run "Start Server" on menu "A-Tools" in Excel)
Open some sheets that they have shared and having resrict rights
Some users can open a sheet excel at the same time for editing, chating with restrict rights from Excel server settingposter-atools
 
User can see all peoples online in this sheet opening and Seeing their information on network)
poster-atools
User online can chat with others...
poster-atools
You can assign approval state for row(s) in sheet, so you can lock data can not edit that rows.

Query data on worksheet by SQL language. That is the power of fast report for Excel:

bs_sql_demo

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.

Creating report very easy by draw and drop sheet to inner/left,right join to any sheet to query data by T-SQL Statement

Advanced Input (Support drop down list to select list with multiple columns for searching and filtering, date on dialog,…): Data Validation List in Microsoft Excel, you can create drop down list with one column in select list but it can not filter list when typing value. With Advanced Input you can select items in drop down list, you can search, filter data easy. If data input with DATE format you can select date from dialog,...
 
poster-atools
 
How to calculate values with conditional color as Excel function for value:  SUMIF, COUNTIF, SUMPRODUCT,.... A-Tools supports: BS_SUMIFCOLOR,BS_COUNTIFCOLOR,BS_SUMPRODUCTIFCOLOR,BS_SUBTOTALIFCOLOR you can calculate values with condition color.

Programming VBA, VB, Delphi, .NET with Add-in A-Tools with classes (COM objects) in addinatools.dll

+ BSNetwork: programming with excel server, excel client for sharing and connecting excel file on LAN, Internet
+ BSFormulaArray: programming with formular array, create functions as BS_SQL, formular return dynamic array, execute T-SQL with extend functions. 
+ BSAdvancedInput: programming with list. Select list with multiple columns for searching and filtering, date on dialog,…

 

+ BSConnection: programming with database on LAN, Internet for Excel, Access, Foxpro, MySQL, SQL Server,... with protocal TCP/IP

 

The main functions:

  • => Share workbook, worksheet/spreadsheet, regions/range in spreadsheet for sharing on the network
  • Restrict Groups and Users to access/connect to server
  • Restrict rights of users to open sheet, regions/range; modify or read-only; format; copy; print;...
  • Manage list of users connected (connections): build black list or connection list, manage user online
  • View list of users connected and chatting
  • Manage 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.
  • => Query data on worksheet by SQL language with function BS_SQL() or tool SQL Builder
  • Connect to the external database: Excel, Access, MySQL, Firebird,…. Link data to sheet (with function BS_SQL )
  • Create dynamic report in Excel with data link to any database in client or server (with function BS_SQL )
  • => Calculation function with color: BS_SUMIFCOLOR(),...
  • => Advanced Input (select list with multi columns, filter, date,…)
  • Create statistical formulas with multiple conditions
  • Convert text, number to words
  • => Developers can program VBA for their applications with Add-in A-Tools by reference addinatools.dll. Add-in A-Tools provides APIs function and COM objects as BSNetwork, BSFormulaArray, BSAdvancedInput.
Add-in A-Tools running on versions of Excel 2000/XP/2003/2007/2010/2013/2016 or higher (32-bit or 64-bit)