TestProject Forum

The 'Read Excel Column' function does not work

When I perform the Read Excel Column function, there are no other problems, but an error keeps coming up.
Why? Are there any issues with that addon right now?
java.lang.NullPointerException at java.base/java.lang.String.replace(String.java:2165)

Hi @jy_test ,
This is a community addon(this is not an addon that we built) I sent an email to the creator about this scenario, I checked this addon right now and it worked for me just fine on the Windows system, which system are you using?
please check again the filePath, and please let me know if you managed :slight_smile:

1 Like

Hello. I am a Mac user. The file path is normal.

Hi @jy_test ,
The “Read Excel Column” addon is currently doesn’t support macOS operating system.
however, there is a solution you can use the CSV operations, please follow these steps:

  1. Convert the XLSX file to CSV, you can use the “Convert XLSX file to CSV” addon as an action.

  2. Add a new step with the addon “Read CSV column” as an action.

  3. Check that you put the right path of the CSV file that you converted in the previous step.

  4. Let me know if you managed :slight_smile:

1 Like

Thanks for checking it out!