This paper will illustrate how to build Dashboard (reports, charts) from Excel Spreadsheet. The data file is also provided so you can follow the steps.

For practice, you can download this excel spreadsheet and use the same SQL code in this document.
All of the SQL code that is highlighted in Yellow can be selected and copied using the Acrobat select option

Did you download InfoCaptor Dashboard Designer? If not, then it is a good idea to have it installed so you can follow the steps easily.

Launch InfoCaptor

Connect to the Excel file

If the path of the Excel file is “c:\files\data.xls” then use “\\” , result c:\\files\\data.xls
In this case the file to be used is “d:\\test_data.xls”.

Select “Excel File – sun.jdbc.odbc.JdbcOdbcDriver” from the Driver list.

1 2 3 4 5