.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Sharepoint 3.0 - Export to Spreadsheet - owssrv.dll

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :C#

Caveat: New to SP, just took over this in the wake of our current sysadm's departure.


So users want to export lists/libraries data to spreadsheet. They get a "To export a list, you must have a Windows SharePoint Services-compatible application." and when you click ok, it downloads owssvr.dll

I have no idea what to do with this, and the lack of information when searching the two subject together do not produce solid information.

Please assist. Working with office2007 on the client machine.

View Complete Post

More Related Resource Links

Export SharePoint List to Excel Spreadsheet Programmatically using C#

In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

Sharepoint export to spreadsheet gives two extra columns in excel 2007 named as type and path, is th

When i export a list in excel 2007, it creates two extra columns named as type and path. At the same time this behaviour is not exhibited in office 2000. Is there any way to remove these two columns without using code ? Is there any configuration settings required for this, to remove it on the fly ? Thanks Ravish Verma

Unable to Export to Spreadsheet in SharePoint Form Library


Hi All,

I am unable to export SharePoint Form Library view data in a Spread Sheet. Whenever I am trying , I got following error message.

An operation that uses the database driver could not be completed. If the driver is a Microsoft Driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query. For other drivers, contact your database administrator or driver vendor.

Any idea how to solve the problem ?

Muhammad Tariq khan

Unable to Export to Spreadsheet in SharePoint if record Count increase more than 1100


Hi All,

When I am trying to export the SharePoint View from SharePoint site to Spreadsheet, sometimes I am able to export the the whole data and sometimes I only get Column headers but no data or records

I have Infopath form (2007) published on SharePoint Site and I am using MOSS 2007 and Excel 2003

I am not able reach the cause of this behaivour of Export to Spreadsheet functionality

Is their a Buffer size Issue with IIS or Session time out

I am not sure because when I export to Spreadsheet and if the record goes to Spreadsheet the file size is just 1.72 MB

Please suggest

Hitesh Duggal

Sharepoint survey- feature for export to spreadsheet


Hi All

I am working on sharepoint survey and I want to extend the functionality EXPORT TO SPREADSHEET of survey list. By default when I click on EXPORT TO SPREADSHEET  option it generates an MS Excel sheet with multiple columns. There is a column Created By in which default value is System Account.

I want to change this default value with currently login user`s Logon Name. Is this possible?

Is there any custom feature for this?


Configuring Profile Image Export in SharePoint 2010

It's no secret that I am thrilled with the new social features of SharePoint 2010. I am most excited about the new Profile Picture handling. I strongly believe that the more we can show the faces of our colleagues to one another the more connected we will feel. Clearly Microsoft feels that way as witnessed by the many features that make use of the Profile Image like the Activity Feed and Colleagues list

Cannot export from a Report in SharePoint integrated mode in a server hardend environment


We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.

The environment has worked fine in test (but the servers are not hardend).

With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.

There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)

When the report is opened directly from Reporting Services (ie http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue only happens when the report is invoked directly through SharePoint.


We can only assume that this issue has something to do with server hardening/UAC as we have

Document Library "export to spreadsheet" doesn't export all columns in Excel 2003

Hi, we are working with MOSS 2007, Infopath Forms Services, KPIs and Excel 2003. There is a view for some data of the Infopath forms which has to be exported to Excel by our users, but some columns are not exported - without any error message. If I try to export it to Excel 2007 everything is exported as expected, but our users have to use Excel 2003. Any idea?

How to export data from a sharepoint list to a SQL database

hi, is it posible if i add some data in a sharepoint list that i can export these data to my sql server tables. or if i create a dataview for exapmle from databse A in SPD to use in my wss3 site and then export it to database B in sql server? thnx

Import Excel spreadsheet To Sharepoint List

Hi, I am having sharepoint 2010 RTM trial on Windows Server 2008 SP2. I want to populate csv filke data to new sharepoint list. I am using custom List Wizard to achieve this... When I Import csv on server then everything is fine but when i inport csv from client, i get the following error "The Specified is not valid Spreadsheet or contains no data to import" I have also checked to import excel workbook but it gives the same error on client and do great on server..... can anybody have any idea what is wrong ?? thanks

Unable to export/copy documents out of SharePoint 2007 libraries

Hi, A client had an issue a few months ago where their MOSS 2007 home site collection had to be restored after a major crash, it now works but they have loads of issues with the restored site(no need to go into) now I am trying to migrate the Data (files and folders only, no security or metadata) to a SharePoint 2010 installation, the problem is that I am unable to get any of the files out of SharePoint. I decided against an upgrade or any form of site migration as I might only be taking the problems with me. i am just trying to copy the files using the "Library - Actions - Open with Windows Explorer". The Explorer view window opens but if i select a file and move it into a folder on the server nothing happens, If I select a folder with files and folders in it then only the root folder is copied over but it is empty.  i don't want to repair any of the issues with the old site as it's only wasting time, can anybody think of a way to get all of the data out of Sharepoint 2007, without taking any of the lists or libraries or any other Sharepoint settings. I only need to keep the folder structure and files within them as i don't need any metadata and am recreating the security again seperately on the new SharePoint setup. Anybody have any ideas or know of free/trial products that i

Export Sharepoint Calendar (with Recurring) to Excel

Hi Everyone, I have a user who manages several Sharepoint calendars who likes to export lists and calendars to excel.  Currently when there is a recursive item, it only gets sent out once.  I have set up a list view that shows recurring events, but when exported to excel, it goes back to only showing each instance once. I know that the concern is that it will generate infinite entries, but is there a way to export this to excel showing all of the recurring items?  I have tried many times and looked on the internet with no success.  So far I'm only using the included parts of sharepoint, so I haven't looked into 3rd party software or writing my own code. Any help is appreciated, Thanks! -Casey

Sharepoint Calendar export to Outlook but can only view the Title column

I have created a Calendar in Sharepoint for booking out company vehicles. The fields I have created are: Vehicle (Choice), Driver (User/Group), Start & End Times, Title (text), DisplayField (Calculated text based on Vehicle + Title...... it would be nice to include Driver but it seems Sharepoint cannot handle the User/Group datatype in a calculated field.....but I digress). I use the DisplayField calculated field in my default calendar view in Sharepoint. All is good at this point. When one connects it to Outlook (via the Action menu in Sharepoint) the calendar is added but all the entries show only the Title field. If I double click on an entry, only the title field appears - the Vehicle and Driver values are missing. When I try to create a new entry - only the Title field (plus other default Outlook fields) are available. So: How can one display a value other than Title by default, and how can I display the other columns when looking at the event detail?

Anonymous Access to "Event Export" on sharepoint calendar display page

I am using a SharePoint calendar with events added in the list. When an anonymous user tries to use "Export Event" on the display page ,the user is prompted for a login. Is there a way that an anonymous user can download the .ics file without logging in ? Is anonymous access even possible ?    

Unable to see Export spreadsheet option under Actions Menu in Surveys

Created 30 surveys expected one survey every survey has Export spreadsheet option.The one which doesn't have Export Option has 924 Responses. I think there is no problem with FBA.Please let me know how to resolve. Thanks

How to export SharePoint site structure into another site on MOSS 2007 SP2

Hi All, Is it possible to export and import the site structure only without the content-just the tables/forms etc ? using only the builtin feature of MOSS 2007 ? if yes, can anyone share it here please ? Thanks, AWT/* Infrastructure Support Engineer */

the list cannot be imported because a windows sharepoint service-compatible spreadsheet application

I have googled this for 3 days now, without any solution. I have install, reinstall services and ms office, save as web the excel file for import, without any results, have anyone encounter this error. I need help.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend