We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Grid exporting to excel(2013) out of range exception

Dear All,


                Im facing a strange issue started recently from the excel export to excel and pdf ,

 attached the screen shot of the error.

 it says invalid argument exception in the error inner details are not given

please do reply 


 exp.Export(InquiryGrid.Model,InquiryGrid.DataSource, "Export.xlsx", ExcelVersion.Excel2013, false, true, ExportTheme.None);

{"Specified argument was out of the range of valid values."}

System.ArgumentOutOfRangeException was unhandled by user code
  HResult=-2146233086
  Message=Specified argument was out of the range of valid values.
  Source=Syncfusion.XlsIO.Base
  StackTrace:
       at Syncfusion.XlsIO.Implementation.RangeImpl.CheckRange(Int32 row, Int32 column)
       at Syncfusion.XlsIO.Implementation.RangeImpl.get_Item(Int32 row, Int32 column)
       at Syncfusion.EJ.Export.GridExcelExport.ProcessRecordRow(Object row)
       at Syncfusion.EJ.Export.GridExcelExport.RenderRecord()
       at Syncfusion.EJ.Export.GridExcelExport.ProcessGridContents()
       at Syncfusion.EJ.Export.GridExcelExport.IterateElements()
       at Syncfusion.EJ.Export.GridExcelExport.ExportHandler()
       at Syncfusion.EJ.Export.GridExcelExport.ExportHelper(GridProperties gridModel, Object dataSource)
       at Syncfusion.EJ.Export.GridExcelExport.Export(GridProperties gridModel, Object dataSource, Boolean multipleExport)
       at FlatGrid_ServerExcelExporting(Object sender, GridEventArgs e) 259
       at Syncfusion.JavaScript.Web.Grid.PostBackEventHandler(String EventName, Dictionary`2 args)
       at Syncfusion.JavaScript.Web.CommonDataBoundControl.RaisePostBackEvent(String EventArgument)
  InnerException: 


3 Replies

TS Thavasianand Sankaranarayanan Syncfusion Team July 10, 2017 11:50 AM UTC

Hi Vimal, 

Thanks for contacting Syncfusion support. 

We have analyzed your query and we are unable to reproduce the reported issue “while excel exporting the Grid argument out of range exception occurs” from our end. 

We have prepared a sample and it can be downloadable from the below location. 


Note: You have said that “you have attached a screen shot of the error”. But we are unable to see your attachment. 

Please provide the following details for better assistance. 

  1. Screen shot or video demonstration of the issue.
  2. Share the Grid code example both server and client side.
  3. Essential studio version.
  4. If possible share the sample or reproduce the issue in the attached sample.

If we misunderstood your query then please get back to us. 

Regards, 
Thavasianand S. 



RA Razor July 10, 2017 01:35 PM UTC

Dear Thavasianand,


            Thank you for the reply we are using 14.4.015 version and ill try to simulate the error on the below attached I might need to convert the project in to 14 version as I don't have the installation with me.


Regards

Vimal




TS Thavasianand Sankaranarayanan Syncfusion Team July 12, 2017 04:30 PM UTC

Hi Vimal, 

As per your requirement we have modified the sample to Essential studio version 14.4.0.15 and the sample can be downloadable from the below location. 


Note: We are unable to reproduce the reported issue from our end. 

Regards, 
Thavasianand S. 


Loader.
Up arrow icon