I'm trying to import specific cell data/values from an uploaded XLS into a web form - or alternatively directly into SQL.
The file upload routine works ok, so that's not an issue, but the excel file name will be different for each record, so the routine needs to handle that.
I've tried the MS option of using named ranges, but whilst it works, its a bit clunky. I need to be able to use cell ref's (A1 etc) or (2,1).
What are my options ??
MySheet1 - Cell A1 or (1,1) --> MyFormField1
MySheet2 - Cell A1 or (1,1) --> MyFormField2