How to search within excel file?

Hi

I have following requirement:

  1. 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
  2. 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

February 10th, 2015 6:51am

Hi,

You can use the excel REST service to search within excel.  One such example available is as follows

http://blogs.msdn.com/b/cumgranosalis/archive/2009/11/02/excel-services-rest-apis-the-basics.aspx

Please don't forget to mark it as answered, if your problem resolved or helpful.

Free Windows Admin Tool Kit Click here and download it now
February 10th, 2015 7:06am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics