Solved

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

Posted on 2009-07-15
3
308 Views
Last Modified: 2013-11-26
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
0
Comment
Question by:rmicone
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 14

Assisted Solution

by:chinu1310
chinu1310 earned 62 total points
ID: 24868348
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
 
LVL 2

Author Comment

by:rmicone
ID: 24942775
Hi thanks for the reply,

I don't have MOSS2007 so Excel services is not possible, but thank you for that link.
0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 63 total points
ID: 25000073
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question