.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

Problems with excel import to sharepoint

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint

I have a rather large spreadsheet I want to import into sharepoint.  The data imports fine but the column headers are a row of data within the sharepoint list and not the column headers of the list.  I've tried to change the format of the header and even added a blank row b/w the headers and first row of data but sharepoint seems to be adding generic column headers to my list...is there a fix for this issue?

Much thanks!

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

Problems with Exposing Excel contents in SharePoint 2010

<!-- [if gte mso 10]> <mce:style>

I have an Excel spreadsheet and I want to use it to trigger a work flow ... BUT ... I don't want to just use the creation or modification of it to trigger the work flow ... I want some data in the sheet to trigger it. 

I followed some How-To's and was able to get to the point where I set up a Site Column and associated it to a Custom Content Type (i.e.: my Excel sheet) and when someone creates a new document this is loaded with the ability to manually enter the value in the Document Properties bar that appears.  Great ... but why would I want to manually enter the value again when I have already have it in a cell below.  I thought, OK a little more work to do and I am done.

So, after some research, I learned that I have to  create a named cell range and custom field in my Excel document and then expose that to SharePoint. I was referenced to this article (http://tinyurl.com/29l98rl) and performed the steps as outlined ... and thought, "Great that was easy ... I am done !!"

Well ... that wasn't quite true.  After testing this out I soon realized that the data in the cell was not being populated into the Site Column.  So I went back and double checked it and am pretty sure that I did everything right (

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

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.

In sharepoint excel working fine in office 2007 but not in office 2010


Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.


This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.


Can you let me know why is problem is coming and how to resolve this.



Sanjeev Tiwari


SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

Sharepoint 2007 and Excel 2010 features


Does Sharepoint 2007 Server support the new Excel 2010 feaures like slicers? Or do i have to have Sharepoint 2010 to get that working (considering all other components besides Sharepoint 2010 are available in my Sharepoint 2007 environment) ?

- Thanks



Excel file published on Sharepoint


I want to use ExcelServices of MOSS to publish few XLS files.
The problem is if i want to open up the excel file it will not open in the web browser as I expected, altough i already click "Display as web page".
My MOSS instance is on a server without MS Excel installed on it.
The excel file was created using Excel 2003.
Any idea how to fix it?
Thank you very much,

Attachements problems - also - How to add Office Communicator link to sharepoint Form ?



I have created an Infopath 2007 form and published it to Sharepoint 2007.

1. I can add "attachements" to the form, but the function can handle only one attachement per link. If i need to add 10 attachements, i have to create 10 attachement functions to the form.

Is it possible to create one attachement function in the Infopath form, that is able to save several attachements under it?

2. Is it possible to save .exe, .msi and similar files to the form as attachements? Sharepoint says security settings prohibit this.

3. How can i add a link that shows up as MS Office Communicator link in the form? For example: John Smith in Office communicator is now Online. I want his name and his status to show also in the Infopath form, when somebody opens it in Sharepoint.

Please help!


SharePoint 2010: Excel Services Resource Center

Are you looking to learn about Excel Services programmability capabilities? Learn about Excel Web Services, UDFs, the Excel Web Access Web Part, REST, and ECMAScript support.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

Learn about the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Sample: Developing Applications in SharePoint 2010 Using Word Automation Services and Excel Services

Download sample code that demonstrates the new client services features that are available in SharePoint Server 2010, including Word Automation Services and Excel Services.

Video: Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists

Learn how to use the Open XML SDK 2.0 to create Excel 2007 PivotTables that are connected to data stored in SharePoint lists.

Assembling Documents on SharePoint 2010 Sites by Merging Content from Excel, PowerPoint, and Word

This article describes a rich document assembly solution that takes Word 2010 documents, Excel 2010 documents, and PowerPoint 2010 documents and merges them together to form a final report in Word. It does all of this from a SharePoint 2010 Web Part.

Interacting with the Excel Web Services API for SharePoint Server 2007

Get a quick start with the Excel Web Services API, which enables interaction with published Excel 2007 workbooks in SharePoint Server 2007 from a remote application. Learn considerations around session state, security, and performance.

Video: Excel Services and SharePoint 2010 Business Intelligence

In this video you will learn how to create BI applications using Excel Services. (Length: 10:26)
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