Solved

Query Excel file in SharePoint

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
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 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…

749 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