Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Using an excel spreadsheet as a data source

Updated: 21 May 2010 | 2 comments
GreatAmericanWF's picture
0 0 Votes
Login to vote

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

reecardo's picture
03
Nov
2009
0 Votes 0
Login to vote

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.

GreatAmericanWF's picture
05
Nov
2009
0 Votes 0
Login to vote

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.