Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Excel Service

  Asked By: Judson    Date: Jun 09    Category: Sharepoint    Views: 771

Issue:
1. I've an Excel sheet (we can't have more than a file)
2. Which has data in A1...A10 to K1...K10 columns
3. We've to display the content of that Excel sheet on three different webparts
4. Want to display the below information
Webpart-1: has to display the data in A1..A10 to D1 to D10
Webpart-2: has to display the data in E1..E10 to G1 to G10
Webpart-3: has to display the data in H1..H10 to K1 to K10


is it possible to do? if so, please help me.

Share: 

 

4 Answers Found

 
Answer #1    Answered By: Leeann Hull     Answered On: Jun 09

as per i know u can't select partucular rows of data  in excel  sheet to display  in the web part.
If u r particular abt tht in the same wrkbook create three sheets and later add them as 3 web parts

 
Answer #2    Answered By: Vaasu Radhakrishna     Answered On: Jun 09

is it possible to use Range to get it resolved?

My idea is:
1. Single Excel Workbook
2. Three different Ranges
3. Three different Excel Access Webpart
4. while configuring, have to use "Named Items"

I've not tried the above as facing issue  with Excel services, keep you posted once the issue with Excel services fixed.

 
Answer #3    Answered By: Brinda Bca     Answered On: Jun 09

I'm able to display  the specific portion of an Excel sheet  on the Excel Web Access Webpart, using Excel Ranges.

What you to do is:
1. create an Excel sheet wtih one or more Ranges
2. Upload the Excel into the sharepoint document library.
3. Add a "Excel Web Access" webpart
4. Select the Excel Sheet
5. Specify the Range-Name on the "Named Items"

thats it.

 
Answer #4    Answered By: Sheryl Velez     Answered On: Jun 09

Thnks for it.
Any ideas how to on workflows using Infopath.

 
Didn't find what you were looking for? Find more on Excel Service Or get search suggestion and latest updates.




Tagged: