DATATABLE

You are here:

TEMPORARY IS OUT OF SERVICE!

AXCEL.DATATABLE function

Datatable deploys an interactive web application for data filtering, search, print and exporting.

Syntax

AXCEL.DATATABLE(data, [buttons], [filters], [editable], [dateFormat], [deployment])


The AXCEL.DATATABLE function syntax has the following arguments:

data Required. The data that you would like to search or export with datatable web application. You can add “.n”, “.s” or “.d” to the end of column names for declaring data type as explained below:

Name Extension Operation
.d column is date format
.s column is string format
.n Drop the column from analysis

buttons Optional. Default is TRUE which shows “Copy”, “CSV”, “Excel”, “PDF” and “print” buttons. If set FALSE, these buttons are removed from the web application.

filters Optional. Default is FALSE which does not show filters in the web app. If set TRUE, every column would have a filter in the web application.

editable Optional. Default is FALSE which does not allow editing data in the web application. If set TRUE data is editable.

dateFormat Optional. If the date in Date columns is Excel standard date format, you do not need to provide any format, and Axcel will automatically identify the date format and applies the conversion. However, if the date is provided in TEXT format, you should define the date format for appropriate conversion. Here are the elements of the date format:

/ or - : Separators
%d: day
%m: month
%y: 2-digit year (for example 98 or 07)
%Y: 4-digit year (for example 1998 or 2007)

Here are some examples of date format:

for "08/22/2019" : "%m/%d/%Y"
for "19/08/22" : "%y/%m/%d"
for "2019-08-22" : "%Y-%m-%d"

deployment Optional. It is the deployment in project/name or owner/project/name format. You need to create a project by logging into your console (https://console.axcel.io) -> Project -> Create Project. After that you can use the project name in your deployment. Please note project and visualization names contain small letters and numbers only. If a project is shared with you, you should use the username of the owner in your deployment. Please visit visualization projects and sharing to learn more about this powerful feature.

when you type =AXCEL.DATATABLE in an Excel cell, the IntelliSense guides you through required and optional (shown in [] brackets) inputs:

In above example we have:

=AXCEL.DATATABLE(A1#,, TRUE)

which means that data is located at cell A1 as an array, we would like to have filters and leave the rest for the default values which means that show buttons, data is not editable and dateFormat is the default.

After running the function, the datatable web application shows in the plot area of the task pane which you can expand it in your browser. Here is the outcome:

You can search, filter or export your data within datatable application.

See also Visualization Projects and Sharing