Solved

Query Excel file in SharePoint

Posted on 2011-09-07
5
271 Views
Last Modified: 2012-05-12
Hi,
I have 3 excel files in a SharePoint document library, users will keep adding records to these excel files. I would like to have some kind of report or similar thing to show me how many records/rows in each of these excel files currently. If you have some idea, please be as detail as possible since I am new to SharePoint.
Thanks!
0
Comment
Question by:e126319
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 12

Expert Comment

by:mwochnick
ID: 36497657
which version and edition of sharepoint are you using?
Edition include:
Foundation   = free with Windows Server Ca
Standard - licensed less features
Enterprise - licensed more features
http://sharepoint.microsoft.com/en-us/buy/pages/editions-comparison.aspx

If you have Enterprise edition your options are different than if you have one of the others
0
 

Author Comment

by:e126319
ID: 36498537
I think it is Enterprise edition.
0
 
LVL 12

Expert Comment

by:mwochnick
ID: 36503368
with Enterprise Edition you get Excel services - which allows you to view your spreadsheet in your browser and all the formulas and the like are run on the server before the data is displayed in the browser - if this is what you have then you just need to add  a formula to report the number of rows and display it at the top of the sheet - there is a webpart for displaying information from the spreadsheet.  If you don't have Enterprise edition then you will need custom code - or you could add a field to the document library where spreadsheet is stored and have people update how many rows they added to the sheet manually when the check it in
0
 

Author Comment

by:e126319
ID: 36503886
Hi, Mwochnick
What is the webpart name to display spreadsheet info?
Thanks
0
 
LVL 12

Accepted Solution

by:
mwochnick earned 500 total points
ID: 36511209
The web part is called Excel Web Access - Here's a link to an MSDN article about Excel services in Sharepoint
http://msdn.microsoft.com/en-us/library/ms546696.aspx
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question