Solved

Query Excel file in SharePoint

Posted on 2011-09-07
5
261 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
  • 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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…

832 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