Export to Excel functionality in LightSwitch

Her you will learn how to export data to an excel sheet in LightSwitch and you can also enable or disable this functionality.


As you know Visual Studio LightSwitch is a Microsoft tool, which is used to build business applications. There is a lot of functionality in a LightSwitch application like export to excel functionality. Export to excel functionality provides a functionality in which you can send your data to an excel sheet. If you want disable the export to excel functionality, then you can do that as well.

This functionality is a very useful functionality because once the data is brought into Excel it can be used in a variety of ways such as,

  • Create reports using SSRS
  • Integrate with other data sources using SSIS
  • Export it as XML files, ASCII files so on
  • Create charts and use pivot tables so on
  • Export data from SQL Azure

Step by step solution

Step 1 : Open Visual Studio LightSwitch->Create new table.

1st.gif

Step 2 : Create a table like below.

2nd.gif

Step 3 : Right click on screen->add screen.

3rd.gif

Step 4 : Select editable grid screen->Select screen data (student)->Ok.

4th.gif

Step 5 : Run application (Press F5)->Click + sign and fill data and save. Now if you want to export your data in excel sheet then you click excel sheet icon.

9th.gif

Step 6 : your data will display in excel sheet like below image.

6th.gif

Step 7 : If you want disable the export to excel functionality then you will go on data grid properties then check the disable export to excel.

7th.gif

Step 8 : Run application (Press F5). Now you will see there will no excel icon .So you can't export to excel sheet your data.

8th.gif

Summary

Export to excel functionality is very useful functionality. It is used when if you want your data display in any spreadsheet like as excel sheet.