Excel "Value must not be empty"

Hi Makers,

Having some trouble with the MS Excel module here!
For some reason I get the message “Value must not be empty” on fields that need to be left empty using the “Add a table row” module.
My scenario contains more of these modules, but only one of them is requiring this. What makes it even weirder is that this one module is a copy of another one.

Can anyone point me in the right direction?
-SOAP-over-HTTP-Join-a-Student-for-a-Day-2022-23-All-programmes-Make

Best, Steven

Hi @Steven ,

Try to insert the {{emptystring}} keyword from the text functions and see if this resolves the issue.
image

Glenn - Callinetic

1 Like

Thanks @Callinetic , I tried that. I can save the module, which is progress. But not it throws errors. See screenshot.
-SOAP-over-HTTP-Join-a-Student-for-a-Day-2022-23-All-programmes-Make(1)

Hi @Steven ,

Could you please give a little bit more context.
Do these parameters refer to your columns in your sheet?
Are these also empty like in your initial request? Or do you map values in these fields?

Glenn - Callinetic

1 Like

@Callinetic It doesn’t say what the parameters refer to. But I guess it’s the ones with the empty strings as they have no value. I don’t map values to these fields.

I have exactly the same issue with a xlsm file. I have a scenario running well with a xlsx file. But with the same file named .xlsm i have this issue.

I have not been able to solve this issue.