Like many software developers I always look for the easiest way to solve a problem. Also like so many, I prefer to be in control of the technology I use. That's why I have a love-hate relationship with SharePoint Excel Services. On the one hand, Excel Services holds the promise of moving complex computational logic and data visualization tasks from code into an Excel workbook where it can be implemented in a fraction of the time. On the other hand, Microsoft has taken control of data access out of the hands of the developer, making it maddeningly difficult or impossible to get to the very data that Excel could analyze so effectively.
In this article I will show how you can sidestep the problem of data access while still taking advantage of Excel for analysis and charting. While the example here uses Excel to analyze documents stored in a SharePoint document library (a use case not supported by native SharePoint), with minor modifications this approach can be used with data from any source, including other types of SharePoint lists, SQL databases, or web services.
This content has been archived. It is available through our partners, LexisNexis® and Bloomberg Law.
To view this content, please continue to their sites.
Not a Lexis Subscriber?
Subscribe Now
Not a Bloomberg Law Subscriber?
Subscribe Now
LexisNexis® and Bloomberg Law are third party online distributors of the broad collection of current and archived versions of ALM's legal news publications. LexisNexis® and Bloomberg Law customers are able to access and use ALM's content, including content from the National Law Journal, The American Lawyer, Legaltech News, The New York Law Journal, and Corporate Counsel, as well as other sources of legal information.
For questions call 1-877-256-2472 or contact us at [email protected]
