.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

Fetching details from Excel Sheet in SharePoint 2007

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

Hi All,

I have customized my SharePoint site to an extent that it does not look like a sharepoint site according to requirement..

It looks like a .net page only. The requirement is

In an .aspx page in SharePoint,

The user must be able to upload an excel sheet to a SharePoint folder every month. 

After uploading & clicking the 'View Sheet' button(my own, not default) must fetch few fields in the excel sheet to a textbox i have..

This is in order that, even a layman will be able to read the contents quickly from the format.

How can i read a particular cell in an excel sheet..

please help..


~ Loveson

View Complete Post

More Related Resource Links

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


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



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.

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.

Publishing Excel 2007 Workbooks to SharePoint Server 2007 (Visual How To)

Watch the video and explore code as you learn how to publish Excel 2007 Workbooks to SharePoint Server 2007 programmatically.

Sample: Publishing Excel 2007 Workbooks to SharePoint Server 2007

Explore the code in this visual how-to article as you learn how to publish Excel 2007 Workbooks to SharePoint Server 2007 programmatically.

Sharepoint 2010 and Excel 2007

i just installed sharepoing 2010 enterprise (not an upgrade) and sqlserver 2008 on another machine. everything is working well, however, i cannot open any excel documents saved in 2007 format. if i save the document in 2003 format, i can open and edit the file. this is not true for word, in which either 2003 or 2007 opens perfectly. not sure what the problem is. the error on the server is 5244. ExcelServerWebServiceApplication.Local: Could not get the web application associated with this context. This indicates that the Excel Server service is not properly registered or provisioned. is registered in event viewer.  

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

Uploading Excel 2007 table into WSS 3.0 - How does SharePoint decide the column that is used to edit

Hi, In Excel 2007, there's an option to upload (export) an Excel table into SharePoint.  The range of cells have to be identified as a table.  In the Table ribbon, there's an Export button.  When I upload the Excel 2007 table, SharePoint (WSS 3.0) decides which column in the table will be linked to the properties dialog box for each line in the table.  It seems to be a sporadic decision on the part of SharePoint. Does anyone know how WSS 3.0 decides which column will be linked to properties?  And, is there any way to control this when uploading the file? Thanks!Thanks! Patti N.

Document is read-only in SharePoint, but user sees "check out" option in Office 2007 / Word / Excel

I am finding that when there is a document library in SharePoint with checkin/checkout required, if a user with read-only ("Visitor") permissions opens a document from that library, the document will open as read-only in Word, Excel, etc., but the user will see the "Server Document" bar with the message "To modify this document, you must check it out" and the "check out" button.  When the user tries to check the document out, they are asked to authenticate, and then receive the error "Cannot perform this operation.  The file has been deleted or someone else has it checked out."    How is it possible to prevent a user with read-only rights in SharePoint from seeing the "Check out" option in Word or Excel?

Hyperlinks embedeed in excel change when checked out in sharepoint 2007 and saved as local copies.


I have an excel folder that is used by several people.  Each has the ability to edit and save changes to track training classes they have attended.  Each person's name in column a is a hyperlink to a sharepoint folder to which is only accessible by the individual and their managers.  When a user checks out the document, they are asked if they want to open the file as a local draft.  If they select yes, when the document is saved back to sharepoint the hyperlinks have changed to the local copy of the user's workstation.  This prevents users from accessing their folders.

Can I turn off the ability to save to a local copy?  How can I prevent the hyperlinks from changing?


Unable to open an Excel File in Sharepoint MOSS 2007


I am unable to open an excel file in Sharepoint (MOSS 2007). All other documents work fine. As far as I know there was no change on the Server at all.

Excel found unreadable content in 'stuff.xls'. Do you want to recover the contents of this workgroup? If you trust the source of this workbook , click Yes

When I click YES >> It says "Excel recovered your formulas and cell values, but some data may have been lost." And then a link to an xml file , which reads :

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <summary>Errors were detected in file 'http://server_name/Project_name/Shared Documents/abc - def/Phase 5/Track/stuff.xls'</summary>
- <additionalInfo>
  <info>Excel recovered your formulas and cell values, but some data may have been lost.</info>

Now this has resulted in huge loss of data and I can see New numbers in the cells which is very strange!

Is there a way I can get it back ? I do not have a

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 :-)


On excel sheet upload read the workbook and populate data to sharepoint list


Requirement in my current project:
In a document library when I upload an excel sheet, a specific workbook has to be read and the contents have to be uploaded to a sharepoint custom list.
The approach followed was create an event receiver and register as a feature. Following is the code for event receiver.

public override void ItemAdded(SPItemEventProperties properties)
            var list = getSPList("{150301BF-D0BD-452C-90D7-2D6CD082A247}");          
            SPListItem doc = properties.ListItem;
            doc["Msg"] = "items deleted from req list";
            string excelname=doc.File.Name;

Sharepoint 2010 and Excel 2007




I am creating a windows utility where user select list from a windows form combo box and inserting the excel data into the sharepoint list.

Issue that i am facing is, SharePoint runs on VS2010 project properties Platform Target as "Any CPU" while excel 2007 driver "Microsoft.ACE.OLEDB.12.0;" workins with Platform target as "x86".


Both are not working with each other, while if I am running them separately, they are working.


Kindly suggest.





Edit Details in Sharepoint 2007 My Site Page

Our Company is currently using Sharepoint 2007 as our intranet.  We want users to start using it for more collaboration and search funtionality.  One function we would want to give each user is the ability to modify their extension number.  However, users cannot edit  the "Work Phone" field in the My Site.  Is there a way to be able to modify this field?

Display the Version of a MOSS 2007 Sharepoint document in Word 2007 and Excel 2007

Do somone have a step-by-step solution to this problem;   I have a liberary in SharePoint with version controll. In this liberary I have both Word and Excel documents.  Displaying the metadata from created columns are no problem, but  displaying the Version of the document generated by SharePoint is worse.  I do appreciate if someone can help me with this problem.
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