this is my first day using application express!
what i would like to do is have a form that allows a user to upload an excel spread sheet.
the contents of the spread sheet would be then copied to a table in my database.
i would be producing the spreadsheets for the users that they will import so hopefully the rows in the spreadsheet would match the rows in the table.
maybe some validation would need to be done to check the rows match.
as i said this is my first day using this product [i normally program in PHP by hand], so i really would like to know if this is acheivable and how to go about it.
what direction to take and if there are some good tutorials on this.
The easiest way is to use a feature of APEX called the Data Loading Wizard. See the documentations Link below:
Another awesome option is the Excel2Collections plug-in
It handles multiple formats, worksheets into an APEX collection.
i recently posted an article asking if it was possible to have a form that would upload an excel spreadsheet.
i realise now, that was a bit vague.
I Should have asked:
can I have a form that uploads xlsx files?
PLease do not reply with answers on how this can work with CSV files or XLS files.
this post relates to XLSL files only.
i Found several answers on how to get this working with CSV.
also the apex upload wizard allows you to create a form to upload a CSV.
theres a good article on how to get an uploader working for XLS. But again this doesn't work for xlsx.
however, a lot of people, like me, want to cut out the step when the user has to convert their file to another format.
so converting from xlsx to XLS or CSV are both unwanted steps.
the top answer in this arrticle explains that actual this is not possible due to the face that the APEX listener can't read XSLX files.
The article was submitted in feb 2012 with no definitive answer on a compatable listener as yet (sep 2013)
does any one know when there might be a APEX listener that will work with xlsx files, or if there is a work around?