Using an excel spreadsheet as a data source
I would like to take a string a user enters into a form, match that string with the value in a cell in a spreadsheet, and return the value of another cell in the same row of the spreadsheet. Example – user wants to request access to a shared network folder. User needs to input the path to the folder. User does not need to know the owner of the folder, but owner names are also stored in the spreadsheet. All shared network paths (and their associated owners) are manually maintained from the worksheet (yikes, I know), so when the user inputting into the form inputs the path to the folder that they want to access, I would like to return the name of the owner of the folder, whose name would be in the same row, different column.
Thanks in advance
Brian
Comments
You can capture input of the
You can capture input of the path via a basic "form builder". Then, you can read the Excel spreadsheet via the Office DLL (not loaded by default) or using the Excel integration library. Once the data of the worksheet is read, you can compare the data to the value in the form builder, and return a "subset" of the read spreadsheet data to populate in another control.
Thanks - I also got the
Thanks - I also got the suggestion that manipulating a DB is easier than Excel, so I might try reading the spreadsheet into a SQL table and using that.
Would you like to reply?
Login or Register to post your comment.