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.
Unfortunately, activation email could not send to your email. Please try again.

Grid exporting to excel(2013) out of range exception

Thread ID:

Created:

Updated:

Platform:

Replies:

131430 Jul 9,2017 08:39 AM Jul 12,2017 12:30 PM ASP.NET Web Forms 3
loading
Tags: Grid
Razor
Asked On July 9, 2017 08:39 AM

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: 


Thavasianand Sankaranarayanan [Syncfusion]
Replied On July 10, 2017 07:50 AM

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. 


Razor
Replied On July 10, 2017 09:35 AM

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



Thavasianand Sankaranarayanan [Syncfusion]
Replied On July 12, 2017 12:30 PM

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. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;