ExcelIO sample app not found in SpreadJS 11

ExcelIO sample app not found in SpreadJS 11

Posted by: drojas on 28 March 2018, 6:39 pm EST

• 

  drojas

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 March 2018, 6:39 pm EST

  Hi,
  
  We downloaded the latest SpreadJS 11 bundle as we want to try it and check the performance enhancements.
  
  We were also expecting to find the ExcelIO service for converting from/to Excel.
  
  However, we could not find it in the downloaded content from the Grapecity site (SpreadJS.Release.11.0.0.zip).
  
  In our licensed version 9 (SpreadJSLicensed9.40.20161.0), the ExcelIO service can be found at (SpreadJSLicensed9.40.20161.0\SpreadJS Javascript Library.zip\samples\GrapeCity.ExcelService).

  Can you tell us where can we find the enhanced ExcelIO service corresponding to SpreadJS 11?

  Thanks,
  
  David R

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 29 March 2018, 5:14 am EST

  Hi David,

  With SpreadJS v11.0. you can use the Excel import/export functionality client side too. Your SpreadJS package includes the ExceIIO js file.

  However there is a server side component also which can be used for importing and exporting Excel files at server side in your windows/web applications.
  
  You can download the ExcelIO server component from the link below(latest build). It also contains the code for Excel IO service:

  http://cdn.grapecity.com/devchannel/ExcelIO%20Server%20Component.11.0.4.zip

  Latest build of SpreadJS can be downloaded from here:
  
  http://cdn.grapecity.com/spreadjs/11.0.4/Files/SpreadJS.Release.11.0.4.zip

  Thanks,
  
  Deepak Sharma

• 

  drojas

  • Post Options:
  • Link
    Copy

  Posted 3 April 2018, 10:48 pm EST

  Thanks, Deepak!

  I have deployed the Converter app to IIS. Exactly as I did for the version 9.
  
  For some reason I get the error mentioned in the attachment.
  
  Do you know why? should I follow some specific procedure?

  Thanks.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 4 April 2018, 7:38 am EST

  Hello,

  It seems that the attachment is missed.
  
  I would like to inform you that licensing for SpreadJS model has changed after v9.0. Now you need to include the deployment key in your application in order to deploy and to use Excel IO client side or server side component.

  Please refer to the documentation given here:
  
  http://help.grapecity.com/spread/SpreadSheets11/webframe.html#addcontrol.html

  Thanks,
  
  Deepak Sharma

• 

  drojas

  • Post Options:
  • Link
    Copy

  Posted 4 April 2018, 8:12 am EST - Updated 3 October 2022, 11:19 am EST

  Hello,

  Sorry, I am adding the attachment again:

  

  1276×758 30.5 KB

  Also, I will try what you suggested, guessing that would work with a trial license.
  
  Thanks.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 5 April 2018, 10:47 am EST

  Hello,

  Yes, you should be able to use your evaluation license with no issues with SpreadJS Excel IO.

  Thanks,
  
  Deepak Sharma

• 

  ablsoft

  • Post Options:
  • Link
    Copy

  Posted 11 April 2018, 9:24 pm EST

  I finally got the conversion server component on IIS, however, when trying to use the import service I get a license error:

  w3wp.exe Information: 0 : Message=‘Import’, Operation=DefaultHttpControllerSelector.SelectController
  
  w3wp.exe Information: 0 : Message=‘GrapeCity.ExcelService.Controllers.ImportController’, Operation=DefaultHttpControllerActivator.Create
  
  w3wp.exe Information: 0 : Message=‘GrapeCity.ExcelService.Controllers.ImportController’, Operation=HttpControllerDescriptor.CreateController
  
  w3wp.exe Information: 0 : Message=‘Selected action ‘Post()’’, Operation=ApiControllerActionSelector.SelectAction
  
  w3wp.exe Information: 0 : Operation=HttpActionBinding.ExecuteBindingAsync
  
  ‘w3wp.exe’ (CLR v4.0.30319: /LM/W3SVC/1/ROOT/GrapeCity.ExcelService-3-131679579948440616): Loaded ‘C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualStudio.Debugger.Runtime\14.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Debugger.Runtime.dll’. Skipped loading symbols. Module is optimized and the debugger option ‘Just My Code’ is enabled.
  
  Exception thrown: ‘System.ComponentModel.LicenseException’ in GrapeCity.Spread.Sheets.ExcelIO.dll
  
  w3wp.exe Error: 0 : Operation=ReflectedHttpActionDescriptor.ExecuteAsync, Exception=System.ComponentModel.LicenseException: License Not Found, If you purchased a license, your key is in your purchase confirmation email. Email us.sales@grapecity.com if you need assistance.
  
  at GrapeCity.Spread.Sheets.ExcelIO.Spread…ctor(Workbook book)
  
  at GrapeCity.Spread.Sheets.ExcelIO.Importer…ctor()
  
  at GrapeCity.ExcelService.Controllers.ImportController.d__1.MoveNext() in \vmware-host\Shared Folders\Downloads\ExcelIO Server Component.11.0.4\samples\GrapeCity.ExcelService\Controllers\ImportController.cs:line 163
  
  w3wp.exe Error: 0 : Operation=ApiControllerActionInvoker.InvokeActionAsync, Exception=System.ComponentModel.LicenseException: License Not Found, If you purchased a license, your key is in your purchase confirmation email. Email us.sales@grapecity.com if you need assistance.
  
  at GrapeCity.Spread.Sheets.ExcelIO.Spread…ctor(Workbook book)
  
  at GrapeCity.Spread.Sheets.ExcelIO.Importer…ctor()
  
  at GrapeCity.ExcelService.Controllers.ImportController.d__1.MoveNext() in \vmware-host\Shared Folders\Downloads\ExcelIO Server Component.11.0.4\samples\GrapeCity.ExcelService\Controllers\ImportController.cs:line 163
  
  w3wp.exe Error: 0 : Operation=ImportController.ExecuteAsync, Exception=System.ComponentModel.LicenseException: License Not Found, If you purchased a license, your key is in your purchase confirmation email. Email us.sales@grapecity.com if you need assistance.
  
  at GrapeCity.Spread.Sheets.ExcelIO.Spread…ctor(Workbook book)
  
  at GrapeCity.Spread.Sheets.ExcelIO.Importer…ctor()
  
  at GrapeCity.ExcelService.Controllers.ImportController.d__1.MoveNext() in \vmware-host\Shared Folders\Downloads\ExcelIO Server Component.11.0.4\samples\GrapeCity.ExcelService\Controllers\ImportController.cs:line 163
  
  w3wp.exe Information: 0 : Message=‘Will use same ‘JsonMediaTypeFormatter’ formatter’, Operation=JsonMediaTypeFormatter.GetPerRequestFormatterInstance
  
  w3wp.exe Information: 0 : Message=‘Selected formatter=‘JsonMediaTypeFormatter’, content-type=‘application/json; charset=utf-8’’, Operation=DefaultContentNegotiator.Negotiate
  
  w3wp.exe Information: 0 : Response, Status=500 (InternalServerError), Method=POST, Url=http://db/GrapeCity.ExcelService/xsapi/import, Message=‘Content-type=‘application/json; charset=utf-8’, content-length=unknown’

  We are using a trial version, in the instructions I see how to specify the key on the JS side, but how can this be done in the server component?

  Note: in version 9 we have a License Manager, we do not see such tool in version 11.
  
  Thanks!

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 12 April 2018, 7:22 am EST

  Hello,

  You need to include the distribution license for SpreadJS in your application. Please refer to the documentation given here:
  
  http://help.grapecity.com/spread/SpreadSheets11/webframe.html#exceliolicense.html

  Thanks,
  
  Deepak Sharma