SharePoint Excel Web Service

Excel Web Service

Get Workbook using excel web service –

http://msdn.microsoft.com/en-us/library/ms519570(v=office.12).aspx

Save Workbook –

http://msdn.microsoft.com/en-us/library/ms575918(v=office.12).aspx

Use it as required in SSRS/SSIS

SharePoint Excel web Service URL - http://SiteURL/sites/WEBName/_vti_bin/excelservice.asmx