Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2009-07-15
3
Medium Priority
?
312 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
3 Comments
 
LVL 14

Assisted Solution

by:chinu1310
chinu1310 earned 248 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 252 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

824 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