Hi
I have following requirement:
- A document library will have an excel file with around 10,000 rows. It will have one column as a primary key column. Column name is: Request ID
- A SharePoint site will have a page with text box and button. Users will enter Request ID in text box and click on button. Page division will display all the data from excel file associated with that Request ID
I have tried using Infopath for this but Infopath fails running when item count increases. Here it is not possible. Uploading the data to SP list is also not possible because of many reasons like list item threshold or reporting methods(excel file will be uploaded on daily basis by some different team).
How can I perform this search task in SharePoint? Is there a way by which we can search within excel file. May be something like - using excel services in CEWP or using filter web part and excel web access web part together on one page.
Thanks in advance for any help.
Regards
Pratima