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 |
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 |
All times are GMT +1. The time now is 03:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com