1. Home
  2. Forum
  3. WinForms
  4. XlsIO ParseException

XlsIO ParseException

Hi!

I'm opening an Excel file with XlsIO and I get this error:

{"_xlfn.TEXTJOIN isn't custom function. at position 1. Formula: _xlfn.TEXTJOIN(\" - \",TRUE,AI8:AI9), Position: 15"}

Formula in Excel is this: =TEXTJOIN(" - ";TRUE;R[1]C:R[8]C)

When I remove the column containing this formula, everything works fine.

Any thoughts?


1 Reply
KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team December 21, 2021 12:02 PM UTC

Hi Stephane, 

Greetings from Syncfusion. 

This is to inform you that TEXTJOIN function is supported only from the Microsoft Excel 2019 version. We request you to share the Excel document you are using at your end along with the code snippet and confirm us the Syncfusion XlsIO version, which will be helpful for us in investigating the query and provide prompt solution at the earliest. 

Regards, 
Keerthi. 


Loader.
Up arrow icon