Skip to main content
D
dharanik2600
February 10, 2023
Question

Procees Getting Errored Out parse XLSX file node

  • February 10, 2023
  • 3 replies
  • 0 views

Hi ,

My process was getting errored out at Parse XLSX file node saying 

Error:

An error occurred while evaluating expression: Output:rule!s_CRDoc(pv!changeRequestFile_doc) (Expression evaluation error in rule 'c_doc' at function 'readexcelsheetpaging' [line 8]: com.github.pjfanning.xlsx.exceptions.OpenException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Invalid byte 1 of 1-byte UTF-8 sequence.) (Data Outputs)

3 replies

csteward
csteward
February 10, 2023

Have you verified there is nothing different about the document - does it look like all the others, etc?  No weird values?  Not empty?

What version of Excel Tools are you using?

Otherwise I would suggest posting in the thread for this plugin as well.

D
dharanik2600Author
February 10, 2023

Thank you so much for the info Chris

Document seems it was fine and plugin version needs to be validated will check on that once and parse xlsx node is not using as smart service in script task output defined a rule for reading the data in Excel sheet

csteward
csteward
February 10, 2023
defined a rule for reading the data in Excel sheet

This is my preferred method over the smart service, but unfortunately I have not encountered that error.  I would definitely recommend to verify the plugin is up to date and go from there.

Terms & ConditionsAccessibility statement