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
LVL 2
rmiconeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chinu1310Commented:
Hi,

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

http://social.msdn.microsoft.com/forums/en-US/sharepointdevelopment/thread/5b5c96d4-17fb-42ad-8c30-e184fe26c5ef

If you have excel service running you can take advantage of it and use it as below.
http://msdn.microsoft.com/en-us/library/ms519100.aspx

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

I don't have MOSS2007 so Excel services is not possible, but thank you for that link.
0
Ted BouskillSenior 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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.