Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a requirement from a business user that I don't know how to address. The question is this:

Can I count the number of times a specific value appears inside the spreadsheets stored in a SharePoint (MOSS Enterprise) document library? There are hundreds of complex spreadsheets in the library and the user wants to count the instances of a specific value in all spreadsheets stored in the library.

I can do all of the analytics that the user likes on the library metadata but I don't know where to start with this one. Thoughts?

share|improve this question
add comment

1 Answer 1

up vote 2 down vote accepted

(Development required): You're gonna have to use Office Interop, combined with the Find method. How exactly you do this is up to you. If you have a lot of files, the process could be time consuming, so one method is to create an application page that has a control on it. The control accepts the target library you want to search (dropdown box, populated with libraries in the current web?) and the search string to look for, then, inside a SPLongOperation, iterates over the files in the library and performs the Excel Interop Find method, collecting the results as it goes, and presents the results once the Long Operation has finished.

share|improve this answer
    
Ouch... I should probably have specified "no code" but subsequent research is showing me that your suggestion seems to be the only one out there. Will let the question marinate for a bit longer before marking Answered but at least you've given me a thread to follow... thanks! –  SharePointEric Dec 19 '11 at 19:11
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.