Problem Reading MS Excel file(with borders and other formatting)using POI
807580May 20 2010 — edited May 27 2010My task is to read the MS Excel file and put the contents into the Oracle database.
I have a MS Excel file containing huge data and formatting with too many borders and cell shading.
For this reason, I have created an intermediate MS Excel file. I do a Copy from the source file and Paste Special-> Values in the intermediate file.
During this, if the table borders and cell shading is lost then POI does not read the data in the correct format.
But if I do a Paste Special-> Values in the source file and then Copy-> Paste the rows in the intermediate file. It works fine. (Wild guess: This may be because the formatting with the borders is not lost.) But this is too confusing for the user!
I want to simply copy paste the values from the source to intermediate file. If somebody has come across such a problem please share the solution here.
This is my first experiment with POI. I am looking froward to some help.
Thanks in advance.