I have a client that is insisting on having an html form grid (that resembles Excel) that will allow them to copy and paste from the original excel document into this form. The data that’s copied and pasted into the html form grid will need to match the original excel document data cell by cell.
The client has turn down all other options of importing the excel data.
If anyone has any suggestions or ideas to how to get something like this to work, please let me know!
I’ve done this using one big <textarea> field. I just use copy and paste from the clipboard (as mentioned earlier, this will actually paste as tab delimited into the textarea). Then I just split on carriage returns, and split again on tabs. You’ll want to trim the data to get rid of any whitespace. I also typically have an intermediate page as a sanity check that presents the data in an HTML table to make sure it is formatted correctly before I start injecting it into MySQL.