Excel Dashboards - Launch Designer and Connect to Excel
In the Previous article we briefly mentioned the benefits of Excel based dashboard
We continue the series in building the dashboard
This is the sample Excel Spreadsheet test_data.xls
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.



2 Trackback(s)