Chapter 8. Using Excel To Analyze LightSwitch Data

We’re used to looking at data from the developer’s point of view. However, most organizations include people who need to analyze data with specific tools such as Microsoft Excel. These people might need to generate graphics, review statistics, or apply special formulas to data. Why should you care? Because your boss is probably one of those people. Usually they don’t know how to attach Excel to a LightSwitch data source, so that’s likely to be your responsibility. In this chapter, you learn how to take advantage of data connections and OData services to give Excel users the ability to analyze LightSwitch data.

Exporting from LightSwitch to Excel

When working with desktop applications, screens ...

Get Hidden Visual Studio LightSwitch: Secrets from the Real World for Creating Great Apps now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.