posted 12 years ago
To start off, I found some information about reading Excel files via javascript, but none of the information I found seems to work as expected. This is what all I want to do (don't laugh):
Read an existing Excel spreadsheet that has been selected for uploadGo through the columns starting at row 2 to check for anything that is either mising that should exist or incorrectFlag any of those columns (perhaps highlight), or if that's not possible, if I read it, I can display an error alert.
Now I get that it may be a little more complex than "all I want", but this is what I would like to be able to do. We had tested JExcel awhile back that would have done that via the back-end -- and I certainly am doing back-end validation -- but I would really like to have the user be able to make the needed changes prior to uploading since it will actually save a step (they currently get a notification that their request has been denied for validation errors). I figure if they could get their spreadsheet validated prior to uploading the spreadsheet, it woudl help eliminate the annoyance factor.
Any help would greatly be appreciated. Thanks.