in

SharePoint Blogs

The Best Place for SharePoint-related Blogs

Madamo working experience about Sharepoint

Talking about sharepoint real world

Programmatically create link to open sharepoint list in Excel, like Export to Excel Spreasheet list action

Tha'ts a Windows Sharepoint Services RPC call,

This is the URL Protocol

http://sitecollectionurl/subweb/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&
List=ListName&View=ViewName

I'm trying to send CAML Query, using POST command...

If you have to export a custom list items interval, you can use a "temporary" SPView,

create a custom List View using Windows Sharepoint Object Model,then export on Excel using the URL Protocol 

Windows Sharepoint Services RPC Reference

http://msdn2.microsoft.com/en-us/library/ms448359.aspx

See you next!! 

 

Comments

 

Seth said:

The cool thing would be if you could pass CAML and generate an excel file for a roll up of many sharepoint lists!

Seth;

December 14, 2007 2:56 PM
 

madamo said:

I'm not sure, you want to join more than one list and export to excel?

it woukd be a cool feature, but using  CAML is not possbile to make join like sql :(

It is a really big problem  in Sharepoint.

December 15, 2007 8:25 AM

Leave a Comment

(required )  
(optional )
(required )  
Add

Need SharePoint Training? Attend a SharePoint Bootcamp!

Posts (c) their respective authors. Everything else (c) 2007 SharePoint Experts