Java – is there a tool to replace the passed Excel files back and forth and merge them?
Some legacy software relies on downloading multiple Excel files, merging the contents, sending them back, making some changes remotely, and then sending back the modified excel file. The next day, multiple Excel files will be downloaded again and merged with this file Are there any tools (preferably Java or can be used from Java programs) that allow me to replace these legacy code because maintaining / extending it is only slightly better than self Immolation?
I should add that the reason why we use Excel instead of database is that some reports can only be exported to excel, and in our end, some staff are satisfied with using Excel formula So we need something they can edit in Excel, but we can do all the above
Update: these files do not contain images, only ordinary Excel data and formulas I'm leaving "send" generics because it can be easily changed It can be via FTP, via email, via web forms, etc., without really changing the nature of the process
Solution
Consider using spreadsheets of Google Documents