Web Dashboard – Add Excel File Connection

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

This article will explain how to add new Excel File connection

Visit http://127.0.0.1:4001/infocaptor/dash/connection_template.php?mode=excel

Image

 

Assuming your excel file is located in the “c:samplestest_data.xls” the following entries are populated

Image

 

“Connection Handle” : This is an identifier for the excel file that will be used in the dashboard so name it appropriately so you can identify. Each Connection handle will appear in the data connection drop down list

“Excel File Path” : Type the exact Excel file and also verify the extension if it is .xls or .xlsx, or .xlsm or .xlsb

Then select the windows and excel version. Add some descritption and then click on the “Add new Connection Entry”

You should see the confirmation message below

Image

Now go back to the Dashboard Designer interface

And from the left panel, under the “Containers and Boxes” section we drag the “Grid” and drop it in the main canvas in the center

Image

 

Now right click on the Grid

It will show a context menu

Find the “Data URL” item and click on it

Image

this will open a new window as shown below

Image

 

From the connection you can select the Excel handle that we defined earlier

In the SQL window you can type any valid SQL statement

Click “OK”

The SQL will execute and immediately update the Grid with the result it brought in

Image

So this explains the basic data sourcing for Grid.

You can source data into the charts too but for charts make sure you are pulling the right number of columns and in the proper order.

Custom Reports and Dashboards

We will build you a set of custom reports and dashboards
Best Offer

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH