asked on

Query Excel file in SharePoint

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!

mwochnick

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

e126319

ASKER

I think it is Enterprise edition.

mwochnick

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

e126319

ASKER

Hi, Mwochnick
What is the webpart name to display spreadsheet info?
Thanks

ASKER CERTIFIED SOLUTION

mwochnick

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial