Use an existing Excel-file like an template
The Excel export is a very good feture but it generates a completly generic excel-output. It would be nice to design an excel-template-file and on userRequest LightSwitch only fills the wanted data from the Screen into the excel-template and opens the fully formated and user-ready excel-file for the user.
Thank you for your feedback! You can achieve this today. Please follow Beth’s pointer for more information. We are closing this thread so you get your votes back!
Beth Massi commented
You shoul dbe able to control exact what/how data is exported using the Office Integration Pack. See: http://blogs.msdn.com/b/bethmassi/archive/2011/09/22/fun-with-the-office-integration-pack-extension-for-lightswitch.aspx