I thought about creating a project that uses Jspreadsheet to build interactive Excel tables, where people can easily and simply fill in data without needing to install anything complicated. The idea is that a company that needs to collect information from different departments, like sales or inventory, could have each team use these tables directly in the browser to input data. Once the data is entered, it would automatically be sent to a backend developed in Java.
This backend would have the role of taking the data from the tables and converting it into PDFs. For example, if the sales team fills in a spreadsheet with goals and results, the Java backend would convert that data into a PDF report using a library like iText or Apache PDFBox. This would ensure that the data is organized and ready to be shared or archived.
After generating the PDFs, the system would store these files in a secure location. I’m thinking about using a cloud storage solution like AWS S3, which makes managing large volumes of files easier and ensures they’re always accessible. Another possibility would be to store these files directly in a database, like PostgreSQL or MySQL, especially if there’s a need for detailed queries or to organize the data by specific categories.
In addition to the PDFs, the raw data from the spreadsheets would also be stored, so we can perform future analyses. For example, if the management team wants to analyze sales performance over the last six months, with the data already organized and stored, the system could generate detailed reports based on the previously filled information. This helps both with analysis and tracking goals and performance.
So, the project flow would be as follows: the user enters Jspreadsheet, fills in the tables with the necessary data (whether it’s sales, inventory, or something else), the Java backend processes this data, converts it into PDFs, and stores them securely. Finally, all the data remains accessible for future queries and deeper analyses. This would create a complete solution, integrating data collection, report generation, and efficient storage, all in an automated and accessible way.
I’m really eager to move this idea forward, but I know a project like this involves many technical details and different areas of expertise. That’s why I need help to make it all happen. If anyone is interested in participating in this project.
I tried to do the front end and hope to get help for the back end