Excel Importer for Visual Studio LightSwitch Updated for Web Applications

The Excel importer will now allow CSV files to be imported from LightSwitch web applications."Excel Importer is a Visual Studio LightSwitch Beta 2 Extension. The extension will add the ability to import data from Microsoft Excel to Visual Studio LightSwitch applications. The importer can validate the data that is being imported and will even import […]

The Excel importer will now allow CSV files to be imported from LightSwitch web applications.

"Excel Importer is a Visual Studio LightSwitch Beta 2 Extension. The extension will add the ability to import data from Microsoft Excel to Visual Studio LightSwitch applications. The importer can validate the data that is being imported and will even import data across relationships," the Redmond company explains.

"To install and use the extension in your LightSwitch applications, unzip the ExcelImporter zip file into your Visual Studio Projects directory (My Documents\Visual Studio 2010\Projects) and double-click on the LightSwitchUtilities.Vsix.vsix package located in the Binaries folder. You only need LightSwitch installed to use the Excel Importer."

"In order to build the extension sample code, Visual Studio 2010 Professional, Service Pack 1, the Visual Studio SDK and LightSwitch are required. Unzip the ExcelImporter zip file into your Visual Studio Projects directory (My Documents\Visual Studio 2010\Projects) and open the LightSwitchUtilities.sln solution."

To build the sample, make sure that the LightSwitchUtilities solution is open and then use the Build | Build Solution menu command.

To run the sample, navigate to the Vsix\Bin\Debug or the Vsix\Bin\Release folder. Double click the LightSwitchUtilities.Vsix package. This will install the extension on your machine.

Create a new LightSwitch application. Double click on the Properties node underneath the application in Solution Explorer. Select Extensions and check off LightSwitch Utilities. This will enable the extension for your application.

You can download Excel Importer for Visual Studio LightSwitch here.