Save as XLSX hexidecimal error AR 16

Save as XLSX hexidecimal error AR 16

Posted by: darin on 30 May 2025, 11:29 am EST

• 

  darin

  • Post Options:
  • Link
    Copy

  Posted 30 May 2025, 11:29 am EST

  We have multiple instances where a customer reports they can’t save a report as Excel because of an invalid error:

  hexadecimal value 0x02, is an invalid character

  Usually it is because of the backwards " (ascii code 148), but it can also be a 1/2 (ascii 189) or the degree or circle R, or any number of things.
  
  not sure if you see the difference below, but the first line is the error line, the second line is fine because I changed the "

  PULLEY 4” IDLER
  
  PULLEY 4" IDLER

  I have read other forum posts that it is due to the XLSX and the XML limitations.

  What are our options without having to have our customers change their data?

  The command we are using in the program is:

  Dim xls As New GrapeCity.ActiveReports.Export.Excel.Section.XlsExport
  
  xls.FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xlsx
  
  xls.Export(in_myDoc, in_file)
  
  xls.Dispose()

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 6 June 2025, 1:18 am EST

  Hi Darin,

  It would be difficult to comment upon the exact cause of the issue without actually going through a sample that replicates the issue.

  Could you please share a sample that replicates the issue so we can test the same on our end and further investigate the same?

  Thanks,
  
  Anand