.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

Not able to Import Spreadsheet into SharePoint list.

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :SharePoint

Hello All,

I am working on WSS 3.0  and with MS Office 2007. I want to import an excel spreadsheet into SharePoint list using the feature provided under "Custom List -> Import Spreadsheet". Whenever I try to Import SpreadSheet i got following error;

Cannot connect to server at this time. Your table cannot be published.

Simultaneously, I am not able to utilize Export to Spreadsheet functionality present under " Actions => Export to Spreadsheet". Whe i tried to export the list it gives "Cannot connect to sharepoint list" error.

Can anyone help me to fix this issues?
Thanks in advance. Waiting for your valuable response.



View Complete Post

More Related Resource Links

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

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.

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.

import data from infopath xml forms to SharePoint list

Hi. I have this issue, a customer has an old application that consists of a SharePoint 2003 site and a 'forms library' with forms listing information about physical servers. The infopath (2003) form is pretty straight forward and has a few dropdowns from lists and so on. Now, we need to move this to 2010 and preferably to a list only using oob functionality. I would like to know if anyone has a clue as to how I can get the data from the hundreds of xml files into a list, could be to excel and then to SharePoint, or any means Necessary. I would prefer it if it can be scripted or done using standard tools from Microsoft, no 3rd party custom xml importer...(if it's not really good and free :-) ) ThanksThomas BalkestÃ¥hl - Technical Specialist - SharePoint

How to provision custom list and import custom aspx pages automatically in sharepoint?

What is best way to create custom list (Document library) and import custom .Net pages automatically. The goal is to avoid create the list and upload those .net page to the list manually. Any code snippet that would be great help. thanks

Can I import a databse from MS Access into a SharePoint list if it contains attachments?


I have 2 issues I am trying to accomplish:

Background:  I have a SharePoint list of over 8000 entries.  This list contains Text (entries) and document attachments.  The list is approximately 400MB.  I have exported the entire SharePoint list into an Access database.  I now want to import parts of the database back into seperate SharePoint lists.

Endstate:  Break the list into seperate lists.  The seperate lists will be broken down by month.  The lists need to include all content from the original list (attachements included)

Issue 1:  Can I import only selected filtered fields into SharePoint from the Access database?

Issue 2:  Can I import the selected filtered fields to include the attachements?


Sharepoint Export Import List Items



My requirement is to export the list items in Pages library with its meta data i.e. Created Time and Modified Time.

I am trying Export Import code, but it does not import time. It imports the CreatedBy and ModifiedBY acuurately but createdTIme and Modified Time comes as current time, the time i run the import.

Pls help


private static void ExportItems()
      string exportFolder = @"C:\exports\";
      string exportFileName = "Export_File.cmp";

      using (SPSite site = new SPSite(sourceSiteUrl))
        using (SPWeb oWeb = site.OpenWeb())
          SPList oList = oWeb.Lists["Pages"];
          SPListItem oItemA = oList.GetItemById(2480);

          SPExportObject exportObject = new SPExportObject();
          exportObject.Id = oItemA.UniqueId;
          exportObject.Type = SPDeploymentObjectType.ListItem;

          SPExportSettings exportSettings = new SPExportSettings();
          exportSettings.LogExportObjectsTable = true;
          exportSettings.LogFilePath = exportFolder + "Exportlog.log";
          exportSettings.SiteUrl = sourceSiteUrl;

Sharepoint 2010 List from Excel Spreadsheet to Display as Options in Infopath 2010


I have an Infopath 2010 form where I want the users to be able to display the cost of something based on the results of the data in an excel spreadsheet.

This spreadsheet does not have to stay a spreadsheet, I can import it into a List if that will make this work. So the spreadsheet has types of appraisals along the "X" axis and then individual States along the "Y" axis.

So if I am filling out the form - I want a "residential" appraisal and it is going to be in "California" - that should return the cost.

Any help woudl be appreciated. I am not sure exactly where to start.

Import excel to sharepoint list

Could any one post me a sample code in c# to import data from an excel to a new sharepoint list

Formula showing in OSSR Excel spreadsheet exported from SharePoint list


I exported a list of SharePoint issues into an Excel workbook (2010).  The workbook seemed to work normally as I added new columns and  formulae until just now.  Now when I add a variance calc formula in a cell I see only the formula.  The formula is in a format like "=([@[Prior Est]]-[@[Actual (3/27)]])" instead of "=(G2-F2)" and nothing I do seems to get it to show the actual value.

Is there some sort of bug in the SharePoint excel exports after so many columns are added, or what?

import filtered sharepoint 2010 list data into a word document

i want my filtered list data in sharepoint and export the data into a word document with some relevant fields not all the fields. how can i acheive this ?  
e.g i want to show all items related to "taskname" in word document.

SharePoint 2007 - Import from User Info List into InfoPath 2007

We are using Sharepoint 2007 with InfoPath 2007 and are trying to pull names from the UIL and display the name last name first.  Such as Smith, John.  It seems to pull and display first-name first.  Any way of displaying last name first? Thanks for the assist.

Ready made List Types provided by SharePoint

SharePoint provides some out of the box List Types. Some of the most used ready made list types that SharePoint provides currently are listed below:

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

How to add custom list entries to mysite's calendar in Sharepoint 2007 site?


I would like to know below things

(1) How to create MySite for one specific member with other or administrator's access?

(2) Scenario : Administrator have created one SP2007 site. now Administrator have created one calendar (Sample calendar). Administrator have added some entries in calendar. now one user entered in portal site ansd view the calendar and he click on MySite menu. so this sample calendar entries should enter in that user's mysite calendar. How this can be achieved?

Thanks in advance.
Regards, Praful Udade

Sharepoint Blog Post List Renaming in onet.xml


Ihave created a Site definition and added a Posts Listview in the same.

<View List="$Resources:core,lists_Folder;/$Resources:core,blogpost_Folder;" BaseViewID="10" WebPartZoneID="Left" WebPartOrder="1"/>

This list is created using my own schema.xml which i have copied from the Blog site template.

I wanted to rename the title of the list [not Title field] which is coming to be Posts right now.

Is there anyway to do it?

Any help appreciated


Is there a list of the Accessibility Acts that SharePoint supports?



 Is there a list of accessibility acts that SharePoint 2007 supports.
 For example the Accessibility for Ontarians with Disabilities Act, 2005?


Thank You

Sarbjit Gill
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