0

To be more detailed, let's say I have an Excel file with some numerical values that need to be updated every day into a Web platform, and I would like to automate this process as it is very time consuming to do it manually. I know some basic Java but that's it, but I'm keen to learn what it takes to improve this process.

Bianca Petroiu
  • 1
  • Client side or Server side? – Remus Rusanu Dec 31 '16 at 08:14
  • @RemusRusanu it would be Client Side – Bianca Petroiu Dec 31 '16 at 08:18
  • You can simulate Manual updating of the web page using [Internet Explorer](https://msdn.microsoft.com/en-us/library/aa752084(v=vs.85).aspx). Or, more efficient, you can use [XMLHttpRequest object](https://msdn.microsoft.com/en-us/library/ms535874(v=vs.85).aspx). Or, even better (though I know nothing about it) [WinHttpRequest](http://stackoverflow.com/a/158657/4636801). – kolcinx Dec 31 '16 at 09:38

1 Answers1

0

The is the Java libary Apache POI is a mature libary for reading and writing Microsoft Offic documents. Its contains two components called POI-HSSF and POI-XSSF, that are for handlin Excel files.

If you do not want to insert images or graphs it is relative easy to use.

Ralph
  • 118,862
  • 56
  • 287
  • 383