Reading excel file inside a servlet (multipart data)

Question

I am supposed to read an excel file on the server and store it in the database as a table. I was using ApachePOI to read the excel file by picking up the excel file from the hard disk. Imagine a client uploads a file and sends it to a server, the server wouldn't have access to the hard disk of the client. So now I want to send it as a multipart form-data and then read it on the server.

I have been reading on the internet as well as Stackoverflow but have not found an answer(although there are examples to read a text file).

Please guide me. Thank you.

read [this](https://stackoverflow.com/questions/19237031/uploading-a-file-in-java-servlet) — Jason Krs, Aug 21 '17 at 16:28

DwB · Accepted Answer · 2017-08-21T16:54:14.367

2

Accept the uploaded multiPart File in your servlet.
The servlet should then write the uploaded file to the server's disk.
The servlet can then read the uploaded file from the server's disk.

edited Aug 21 '17 at 16:54

answered Aug 21 '17 at 16:28

DwB

37,124
11
56
82

Reading excel file inside a servlet (multipart data)

1 Answers1