Writing a WSS 3.0 web service to read excel files from a document library

I have a document library where a bunch of Excel files all in the same format, and I want to be able to write a script or a web service that will read in each file, then iterate through certain rows and columns and extract data.  Is this possible?   I have visual studio 2008 standard and use sharepoint wss 3.0
Who is Participating?
Ted BouskillConnect With a Mentor Senior Software DeveloperCommented:
You'd have to write a console application using the Sharepoint API (that can only run on the Sharepoint server) to do this.  Download the WSS SDK for more information.

You could try using a console application that uses the web service to access the list but it's slow and might not have all the features you need.
chinu1310Connect With a Mentor Commented:

Please check the post made by Yugal on the following thread.


If you have excel service running you can take advantage of it and use it as below.

Hope it helps
rmiconeAuthor Commented:
Hi thanks for the reply,

I don't have MOSS2007 so Excel services is not possible, but thank you for that link.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.