With Cell can I read in data from by database and wite it to cells in an excell spreadsheet and then create bar charts and other forms of charts using the data I have written to the spreadsheet. I have a large amount of data and will need to be able to create as many as maybe 50 charts using the data from one or more sheets.
Can cell support this? Can I save the results as a excel file? Also if the user opens the spreadsheet using Excel and changes some of the valuse will the charts update to reflect the new data?
Yes, Aspose.Cells for Java will suit your needs. You may import data from your datasource using Cells.importResultSet() or Cells.importArray() method, or any other method etc. Once the data is filled into the cells of the worksheet, you may create your desired charts accordingly. Finally you may save the Excel file for your needs.
See the document on how to import data from the data sources:
See the documents on how to create charts or manipulate charts:
And, yes, the charts would be editable instead of static pictures. So, once the user will open the generated file into MS Excel, then, he changes the source data or apply/update formattings for the charts, the changes will be reflected accordingly.