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 ...