none
Excel Importer for Visual Studio LightSwitch 2013 RRS feed

  • Question

  • Has anyone managed to get the 'Excel Importer for Visual Studio LightSwitch' extension working with Visual Studio 2013?
    Thursday, November 28, 2013 3:51 PM

Answers

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

    Friday, November 29, 2013 6:13 AM

All replies

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

    Friday, November 29, 2013 6:13 AM
  • 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.
    • Edited by chuckj11 Monday, December 16, 2013 8:22 PM addition
    Monday, December 16, 2013 8:21 PM
  • Hi

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

    Regards


    Mark

    • Proposed as answer by ITPSB Saturday, January 11, 2014 5:31 AM
    Saturday, January 11, 2014 5:29 AM
  • It works fine if you change the manifest. See my update below.

    Mark

    Saturday, January 11, 2014 5:30 AM
  • Thanks 
    Saturday, March 8, 2014 10:03 PM
  • 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!

    Wednesday, April 8, 2015 8:47 PM
  • 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

    Friday, May 13, 2016 8:56 PM
  • 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

    Saturday, May 14, 2016 8:56 AM