Excel Importer for Visual Studio LightSwitch 2013

Question

Has anyone managed to get the 'Excel Importer for Visual Studio LightSwitch' extension working with Visual Studio 2013?

Answer 1

Hi Kevin,

I assume you mean this extension here - http://code.msdn.microsoft.com/silverlight/Excel-Importer-for-Visual-61dd4a90

From what I can tell that does not yet support VS 2013.  The source code is of course available, so you could attempt to fix it up yourself and tell us the result.

Thanks.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

Working for me.  You can also try the OfficeIntegration extension, which works as well.

Here are the methods used for the buttons:

Private Sub ImportFromExcel_Execute()         
   ' Write your code here.            
ExcelImporter.Importer.ImportFromExcel(Me.Customers)
        End Sub

 Private Sub ImportExcel_Execute()

       OfficeIntegration.Excel.Import(Me.Customers)
 
    End Sub

Unfortunately, not sure if you need it or now, but still seems like you cant simply update entries. The import works well, but it only adds new entries not update existing.

Answer 3

Hi

The ExcelImporter will work with VS2013. You just have to edit the manifest contained in ExcelImporter.vsix as shown below:

Regards

---

Mark

Answer 4

It works fine if you change the manifest. See my update below.

---

Mark

Answer 5

Thanks 

Answer 6

Made the mods to the manifest and the importer crapped out. It flashes a list of errors on the screen and then all goes white. I managed to capture a screenshot of the errors while it flashed on the screen...

I tried adding the screenshot, but the forum won't allow me... Something about my identity being verified...



Any help would be GREATLY appreciated!

Answer 7

Hi Mark,

First I'd like to thank you for your effort - I tried the method and it still doesn't work for me - Installation failled - May be I did not followed the process as explained - Can you pls detail the tutorial.

Thanks

Nabil

Answer 8

Hi Nabil

So when you double-click on excelimporter.vsix to install it you get an error message?

Does the error message say something to the effect that this version is not supported?

If so it'll likely be because the version numbers in the Manifest are still incorrect.

Regards, Mark.

---

Mark