Import Data from an Excel Workbook


Brand new to the forum and am still undecided about using JasperReports for our BI dashboards.  

One main question I am trying to find out is whether or not I'd be able to import data from multiple Excel workbooks into one dashboard.  The dashboard just needs to display the information from each cell.  The dashboard would not be using graphs or charts.  Executive staff only want to see numbers.  The numbers come from one or two cells in a variety of workbooks.

Thank you in advance.



laxdog68's picture
Joined: Feb 2 2016 - 1:07pm
Last seen: 6 years 4 months ago

1 Answer:

It's possible to use Jaspersoft ETL to consolidate data from several Excel workbooks into one workbook, csv, or database table and then use that in JasperReports Server.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 2 weeks ago