Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Services Chart Generation for SharePoint Dashboard Display
Hi there,
I've got an xml/rpc datasource that I'm currently manipulating in Java to create an Excel 2007 workbook table. I'm then referencing that Excel workbook as the data for a second Excel 2007 workbook, constructing a pivot table, and a number of business data charts utilizing cell formulas and various vba macros. I need to display these business charts within a SharePoint dashboard using Excel services. However, vba macros will not work within Excel services and my SharePoint Excel service web part continuously generates warnings/confirmations regarding 'enabling queries to external data sources' upon all data refreshes. I've been reading exerpts about odc's and data sources within MS Excel 2007 and I'm wondering if I should just be importing the rpc/xml directly into Excel and dynamically parsing it, to make it much more Excel Services/SharePoint friendly. I have some idea of how to import the rpc/xml data into Excel, but I'm not sure how to dynamically manipulate the data without using macros. Can someone point me in the direction of some how-tos/articles for how to do this; keeping all the data and logic local to Excel and without using macros? Thanks!! -- -Tracy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Services Chart Generation for SharePoint Dashboard Display
For those of you who may also have this question; I never got a response and
consequently figured it out myself. Check out this URL: http://msdn.microsoft.com/en-us/libr...rExcelServices Thanks! -- -Tracy "Tracy" wrote: Hi there, I've got an xml/rpc datasource that I'm currently manipulating in Java to create an Excel 2007 workbook table. I'm then referencing that Excel workbook as the data for a second Excel 2007 workbook, constructing a pivot table, and a number of business data charts utilizing cell formulas and various vba macros. I need to display these business charts within a SharePoint dashboard using Excel services. However, vba macros will not work within Excel services and my SharePoint Excel service web part continuously generates warnings/confirmations regarding 'enabling queries to external data sources' upon all data refreshes. I've been reading exerpts about odc's and data sources within MS Excel 2007 and I'm wondering if I should just be importing the rpc/xml directly into Excel and dynamically parsing it, to make it much more Excel Services/SharePoint friendly. I have some idea of how to import the rpc/xml data into Excel, but I'm not sure how to dynamically manipulate the data without using macros. Can someone point me in the direction of some how-tos/articles for how to do this; keeping all the data and logic local to Excel and without using macros? Thanks!! -- -Tracy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import to Windows SharePoint Services List | Excel Discussion (Misc queries) | |||
Drill thru in Sharepoint using Excel web services | Excel Discussion (Misc queries) | |||
Sharepoint Services -- Need Refresh Option | Excel Discussion (Misc queries) | |||
Excel linked worksheets in Windows sharepoint services | Links and Linking in Excel | |||
Synchronization between Excel and Windows Sharepoint Services FAIL | Excel Discussion (Misc queries) |