You are here Home

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 files on LAN, internet. Someone can open the Excel file in the server at the same time for editing and saving. The client connects to the server by TCP/IP protocol (does not share the full directory - the way Excel does), the server manages the connection by restricting users, setting permissions for each user group: read-only, edit, limit the number of people who can open the sheet, ... When the data in the spreadsheet is changed, other computers on the LAN, the internet will be updated immediately (after about ~1 milli seconds).

What can I do with Add-in A-Tools?

1) Share Excel files over Network between users. Client connects to server using TCP/IP protocol, login with IP address, domain name

2) Limit users to worksheets, address ranges, workbooks

3) Restrict users to edit only certain cells in that sheet

4) Restrict users to print, copy sheets

5) Some users can edit the worksheet at the same time, but cannot delete or change other people's data. User as leader can change the data of users in the same group.

6) Users with "Approve" permission can browse rows in the sheet or the entire sheet, so all users in the network cannot edit once the row or sheet has been approved.

7) Chat with others in Excel.

8) Query the data on the sheet using the executable SQL language. Connect to any database on your computer and link the data to the sheet. With the BS_SQL function, you can create professional reports at high speed with large data in sheets, very easily with drawing and dropping with mouse on SQL Builder.

Add-in A-Tools can generate dynamic reports using functions to query a database (DB) with the T-SQL language. It also allows users to connect to internal and external databases such as Excel, Access, Foxpro, MS SQL, MySQL and Firebird, ... for example. "SQL Builder" helps users to create query formulas (with BS_SQL function) easily and efficiently. Users can create highly complex sheets that are filtered by different conditions and associated with different data sources. That way, high accuracy, stability and speed are guaranteed.

Add-in A-Tools 2019 - v9.5.0.1 - Update 2021-10-07 (yyyy-mm-dd) - Network and Query Strength Report in Excel

The new version is 10 times faster. BS_SQL function support report with group, footer in Excel
This version offers the best feature of Excel file sharing on the network and reporting in SQL
 
menu-atools

A-Tools is a powerful add-in for Microsoft Excel with functions: share excel files on LAN, internet. Query functionality by executing T-SQL on the sheet for report generation - high speed with big data on the sheet. It has the following main functions:

Share Excel files on LAN, internet with many users:.
 

poster-atools

poster-atools

Add-in A-Tools allows sharing and managing Excel files on LAN, internet. Someone can open the Excel file in the server at the same time for editing and saving. The client connects to the server by TCP/IP protocol (does not share the full directory - the way Excel does), the server manages the connection by restricting users, setting permissions for each user group: read-only, edit, limit the number of people who can open the sheet, ... When the data in the spreadsheet is changed, other computers on the LAN, the internet will be updated immediately (after about ~1 milli seconds).

(Synchronize Excel data in Real Time)

poster-atools

(Excel Server sets up Excel files, sheets to share on LAN, Internet)

Excel Client can connect to the server (any computer running "Start Server" on the "A-Tools" menu in Excel). Open some sheets they have shared and have limited permissions. Several users can open one excel sheet simultaneously for editing, chatting with limited permissions from Excel server settings.

poster-atools
 

Query data on a worksheet using SQL language. That's the power of quick reports for Excel:

Add-in A-Tools can generate dynamic reports using functions to query a database (DB) with the T-SQL language. It also allows users to connect to internal and external databases such as Excel, Access, Foxpro, MS SQL, MySQL and Firebird, ... for example. "SQL Builder" helps users to create query formulas (with BS_SQL function) easily and efficiently. Users can create highly complex sheets that are filtered by different conditions and associated with different data sources. That way, high accuracy, stability and speed are guaranteed.

poster-atools

bs_sql_demo

 

(SQL function on worksheet)

Create Dynamic Reports in Excel with GROUPS of columns with Add-in A-Tools

 

If you want to create reports in Excel with speed and power, the Add-in A-Tools is a good choice! This video demonstrates how to summarize and concatenate data with the BS_SQL, GROUP_CONCAT  function.

(Function GROUP_CONCAT in Add-in A-Tools)

Add-in A-Tools supports SQL Builder to create forms in Excel with seemingly simple clicks! Report generation is very easy by drag and drop sheet inside/left side, right join any sheet to query data using T-SQL Statement.

Advanced Input (Support drop-down list to select list with multiple columns to search and filter, date on dialog,...): Data validation list in Microsoft Excel, you can create a drop-down list with a column in the select list but it cannot filter the list when typing the value. With Advanced Input, you can select items in the drop-down list, you can search and filter data easily. If input data with DATE format, you can select date from dialog, ...
 
poster-atools
 
How to calculate value with conditional color like Excel function for value: SUMIF, COUNTIF, SUMPRODUCT, .... A-Tools support: BS_SUMIFCOLOR, BS_COUNTIFCOLOR, BS_SUMPRODUCTIFCOLOR, BS_SUBTOTALIFCOLOR, you can calculate value 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.
 

Main functions:

=> Share worksheet, workbook/workbook, area/range in spreadsheet to share on network

=> Restrict Groups and Users from accessing/connecting to the server

=> Restrict user permission to open sheet, area/range; modified or read-only; Format; Copy; print;...

=> Connected user list management: build blacklist or connection list, manage users online.

=> View a list of connected and chat users

=> Manage Excel reports on the network (LAN), support commands: Check; Approve; Disapprove. According to each command, users are not allowed to copy data, print, modify reports.

=> Query the data on the sheet in SQL language with the BS_SQL() function or the SQL Builder tool

=> Connect to external databases: Excel, Access, MySQL, Firebird, etc. Bind data to a worksheet (with the BS_SQL function).

=> Dynamic report generation in Excel with data link to any database in client or server (with BS_SQL function).

=> Calculation function with color: BS_SUMIFCOLOR(), ...

=> Advanced Input (select a list with multiple columns, filters, dates, ...)

=> Create statistical formulas with multiple conditions.

=> Convert text, numbers to words.

=> Developers can do VBA for their application with Add-in A-Tools by referencing addinatools.dll. Add-in A-Tools provides API function and COM objects like BSNetwork, BSFormulaArray, BSAdvancedInput.

Add-in A-Tools runs on Excel 2000 / XP / 2003/2007/2010/2013/2016/2019, 365 or later versions (32-bit or 64-bit)