Solved

Query Excel file in SharePoint

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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
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 create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now