PDA

View Full Version : upload excel file into editor grid



poleapple
7 Sep 2010, 9:44 AM
I need to be able to upload an excel file to the application and have it show up in the grid. I've googled around and I all I found were exporting the grid to excel - opposite of what I want. I also found a drag and drop from excel to the grid but it's not what I want. Are there any plugins, workarounds? Thanks!

michaelc
7 Sep 2010, 11:34 AM
You need to upload the excel as you would any file,
the a backend process would parse the excel and return a grid of data.

if your using PHP you could use http://sourceforge.net/projects/phpexcelreader/

poleapple
7 Sep 2010, 11:37 AM
ah, you mean upload the excel and deal with the excel data in the backend... like updating it in the database and then outputting it back into the grid?
I am using JavaScript and Java with EJB, entity managers and whatnot. I know how to get data from excel with JDBC but I don't know how to do it with EJB.

Oh, and I need to implement a copy and paste functionality as well - such as ctrl + c rows of data from excel and ctrl + v onto an extjs grid...

Thanks!