GoAnywhere Forum

I'm receiving the following error when converting a .xlsx file to .csv using the "Read Excel File" and "Write to CSV" tasks when the .xlsx file contains cells with value #N/A:

"Cannot get a text value from a error cell"

I've set "Skip Invalid Records" to "True", but that doesn' t help.

Here is the portion of xml:

<readExcel label="Read Excel File" inputFile="${xlToCSV}" outputRowSetVariable="excelRowset" skipInvalidRecords="true" skipEmptyRows="true" processedInputFilesVariable="excelFilename" version="2.0" logLevel="debug" disabled="false" />


<writeCSV label="Write to CSV" inputRowSetVariable="${excelRowset}" outputFile="${excelFilename}.csv" whenFileExists="error" fieldDelimiter="comma" outputFileVariable="rmvXlsx" version="1.0" logLevel="debug" disabled="false" />

Thanks!!


edit to add: We're using GADirector v 4.1.1, running on RedHat.

Wally,

Please send the entire Project XML and how any job log you have showing the issues with what is going on. Please run this in Debug mode if possible.

Thanks!

Thanks Rick, I've emailed the log and XML to [email protected]

-josh

We have been able to duplicate your issue & have advised the developers.

It was identified that we have a similar development case GAD-1831.

Your information has been added to that case and we will evaluate it in the near future. If a patch can be created or if it is added to a future release, we will let you know.