How to add exception for the null value in the excel sheet and add that null row in the new sheet

Help
1

Hi All,

I have a excel where i am splitting the columns into names and email id and writing it in the new sheet.

When it comes to some empty columns it is throwing the exception like “Assign : Value cannot be null.
Parameter name: oldValue”

Kindly help me to handle this and write the empty records also in the output sheet

Attaching the workflow and the sample files here.

Split Columns .zip (18.8 KB)

Regards,
Selvarani M

2

@selvarani1390 Check below workflow once.

Split Columns.zip (20.4 KB)

3

Hi @Manjuts90,

Thanks for your response,

When i try to run it with my actual file i am getting the write range doesnt exists error is coming

I tried creating new file for output and checked still the same issue.

Kindly help.

thanks.
Selvarani M

4

@selvarani1390 Please check the path of the file and other properties once. If that solved your Uninstall excel package and install it again. Try both solutions one after other.

5

sure thanks :slight_smile: it worked …

can you please resolve one more issue…

how can I filter the data that has more than one name and email id.

Please see the input and the output attached

New folder.zip (13.9 KB)

Kindly help.

Regards,
Selvarani M

7

Hi @Manjuts90 ,

sure thanks :slight_smile: it worked …

can you please resolve one more issue…

how can I filter the data that has more than one name and email id.

Please see the input and the output attached

New folder.zip (13.9 KB)

Kindly help.

P.S.: Is this fine now?

Regards,
Selvarani M

8

@selvarani1390 I will check tomorrow and let you know

9

Hi @Manjuts90,

Any update, i am quite confused with the regex most of the times. there where generally i get struck.

Please dont mind, hoping for your response

Regards,
Selvarani M

10

@selvarani1390 I am in last stages of the workflow once i complete i will update you

11

@selvarani1390 Except column names i have created solution for your problem.

New folder.zip (24.4 KB)

Please check let me know if you have any doubts

1 Like
12

Hi @Manjuts90,

Thank you so much , its working perfect.

Regards,
Selvarani

13

@selvarani1390 Your welcome :slightly_smiling_face:, if you got solution close thread by marking specific answer as solution.

14

Hi,

how can i do that, i just checked all the options but couldnt find that option to close it

Kindly help

Regards,
Selvarani

15

HI @Manjuts90,

its done,thank you so much

Selvarani

1 Like
16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.