.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

Excel spreadsheet properties push to sharepoint library columns

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :SharePoint

Hope this is the right forum; if not, please direct me to the right one.

In Excel 2007 I am filling in a document property programmatically in an Excel 2003 spreadsheet, and creating/filling a custom one.  Just FYI, I use the following VBA code:

    ActiveWorkbook.BuiltinDocumentProperties("Company") = "TEST COMPANY NAME"
    ActiveWorkbook.CustomDocumentProperties.Add "Manager's Name", False, msoPropertyTypeString, "TEST MANAGER NAME"

Then I save the document to a SharePoint library.  Right now it is saved as a 2003 version spreadsheet (.xls).  There are a Company column and a Manager's Name column in the SharePoint library, and Microsoft's online documentation says the properties should populate the corresponding columns in the library.  But they don't!

That's my problem--getting them to populate.  Incidentally, thinking that the spreadsheet version was the problem, I have tried saving these documents both as 2003 spreadsheets and 2007 spreadsheets in my code, but the SharePoint columns never populate either way.  The only way I can do it is by manually filling in the document property from the UI.

Does anyone know what I'm doing wrong, either in Excel or SharePoint or somewhere in between, to cause this?  Is there a non-code solution to the problem?  I can do some C# code if I h

View Complete Post

More Related Resource Links

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?

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

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.

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

Show wiki page library columns on wiki pages- SharePoint 2010

I created a wiki page library in SharePoint 2010 and added a few columns to the library. However, these columns do not show on the actual wiki pages as they did in SharePoint 2007. I looked through the library settings but didn't find anything to turn on this feature. Does anyone know how to do this or if this feature was even included in SharePoint 2010? Thanks.

InfoPath 2007 - Publishing Creates multiple columns on SharePoint Form Library (GUIDS apparently are

I have been working this issue for 2 days now.  This has happened to me in the past and I was able to work through it.  It doesn't appear that this time I am going to be so lucky. Issue Description: When publishing an InfoPath form a new column is created that has the same name as the correct one, but a new GUID is created. Troubleshooting steps: I have read this article: http://www.delphi-ts.com/blogs/lozzi/post/2009/06/03/Duplicate-site-columns-in-MOSS-from-InfoPath-Forms.aspx   This was the solution the last time I had this problem.  However, no matter what I do, it is not working now.  I have a column named User Name which is the username of the person that submitted the InfoPath form for use with my Visual Studio workflow.  When the workflow kicks off, it reads this column and attempts to get the value.  The value is blank because a new column with the name User Name now exists and that is where the value is stored.  I attempted to fix it by remapping the GUIDs as described in the article.  I also reverted the code to a previous version from TFS.  None of these worked.   I now have 3 columns called User Name and I can remap the GUID to the second column and third column.  But when I try to map it to the first column (the one I need) it doesn't work. The first column that is circled is the correct column. 

Document Library Missing Columns in Edit Properties

Hi, I'm having an issue with a specific Site Collection.  The issue is that some of the columns do not show up when you go to the Edit Properites page, or when the user creates a new document.  The items can be edited when opened in a data sheet, but the users would like to be able to edit them on the Edit Properties page.  They say they haven't made any changes, but this has happened at least 3 times with differenct document libraries on this specific site.  Has anyone else ever dealt with this?  Anyone got a solution?  Let me know if more info is needed.  Thanks.

Why is Sharepoint 2010 standard search no searching within Document library columns



Environment : SharePoint 2010 Enterprise version, using regular search and NOT Fast Search

Standard search is configured and running succesfully and returns results by searching in documents and columns of lists\ calendars and everything else except for Document librarie's columns may it be text or lookup datatype, any clue?



Cannot Publish Excel 2007 workbook to Report library on MOSS 2007 Sharepoint



I use Windows 7, trying to Publish an excel workbook to MOSS 2007 Report Library. When I type the location in the "Save As.." dialogue, It disappear & file is not saved.

If I do the same from Windows XP OS with Office 2007, I get the Report Library content (the sp folderrs), so I can navigate & file is published succesfuly

Please help :-)


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.

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

How to convert InfoPath form from sharepoint form library (xml format) to Excel format?


I've read about Document Converters in Sharepoint, and using xslt and xml mapping. 

What is the best way to convert InfoPath form with data in sharepoint form library (in xml format) to Excel format?

And how to do it?


SSRS 2008 - Excel Export adding unwanted total columns to spreadsheet



I have a SSRS 2008 report which has 3 column groups which when i export to Excel the resulting excel spreadsheet has an additional total column for each of the groups.  I dont have this displayed in the report and dont want it displayed in teh excel export, is there anyway to turn this off?

I've had a search of this forum but so far i've been unable to find a solution(or someone else having the same problem)


Passing Calculated Columns from Sharepoint into Word Document Library Template


Hi all...

Another noob question.  I have been able to figure out how to pass single line text, date, etc. data from a Sharepoint List into a Word Template, but I am still trying to figure out how to pass a calculated column.  Is there a workaround?


Word 2007 properties not syncronizing with the SharePoint 2007 document library


Hi everyone.

Anyone ever had trouble with document properties that does not syncronize between a Word 2007 document and the SharePoint library where it is stored?

I have a SharePoint library, that contains two content types. When I upload a pdf file, and set the property values everything is perfect. When I create a Word document and set the Properties using the DIP, the values are stored in the Word document (I see them in the DIP, inside the word xml files and in the fileds in the document where they are displayed (using quickparts)), but not transfered to SharePoint when I save the document to the library.

If I upload a Word document to the library, I am able to choose content type and set all the property values. But when I open the document for editing, all the property values in the DIP are empty. The DIP do show the correct property fields for that content type.

After creating new libraries, content types and creating, transfering and uploading files all day, I have not been able to locate what is causing this issue.

My users have been using this library for several months and use the documents on a daily basis, and this problem just got raised. My users are feeling scared that they have to recreate their library or site (which will involve manually updating all the document properties ). I hope someone are able to

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?

Reading Excel File from document library in sharepoint 2010


On a button click,I want to read a excel file placed in document library in sharepoint 2010.The button is in a visual web part.

I am giving the connection string as:



connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=http://server_name/Doc librar

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