You are here Home

Query, Share and Manage Excel workbooks on LAN, Internet

Add-in A-Tools

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. Users can open Excel file in server at the same time for editing and saving. Clients connect to server by TCP/IP protocol (not full share 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 an Excel Workbook 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) Query data on sheet by SQL language. Connect to any database in your computer and link data to sheet

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.

The new version 6.5.1.2 - updated 2014-10-15
A-Tools is an add-in software which runs on Microsoft Excel. A-Tools has the following functions :
Menu A-Tools:
  • (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:

menu-atools

menu-atools-2

  • With Microsoft Excel 2003 or lower

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

poster-atools

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 by SQL language:

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.

demo_report

The main functions:

  • Select a computer with good hardware to Create Server - Excel Server. This machine used for sharing Excel files to clients in LAN, internet. Call it as "Server" or "Host"
  • Add Excel files to server for sharing them to clients in LAN, internet
  • 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.
  • Manage the history Excel files in the server, users can open them again if they have the right.
  • 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 )
  • 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.
Add-in A-Tools running on versions of Excel 2000/XP/2003/2007/2010/2013 or higher (32-bit or 64-bit)