Deleting cell values - Error: Input string was not in a correct format

[amithvs (Amyth)]

I am working on this new project on excel. I completed the workflow, now I am into testing my project. The scenario is:

I am having an excel file without any blank cells (all cells are filled with datas). Once I run the workflow I am getting the output ie the sum of the numbers in the excel. Now I tried by deleting on of my cell values and tried running the workflow, unfortunately, I am ending up with an error " Input string was not in a correct format" . I really need to troubleshoot this. I would like to trouble shoot this error and if there is any blankcells in the excel it should print something like INVALID

Thanx in advance guys…

[ddpadil (Dilip)]

Ho,
Use read range activity to read the spread sheet existent rows. The output is a datatable.

You can use “for each row” to iterate your datatable rows.

To get first 1st column value use row(0) for second column row(1) and so on.

To check if column is empty check row(0) = Nothing in if condition.

How to check null condition

Hi, “IsNothing()” or “=Nothing” is only going to work if there’s nothing assigned to that variable but looks like in your case that an actual row is there but it just contains “” values. You could just see if certain values or columns has nothing in it like row(0)=“”, and that would tell you there’s nothing there. Or you could look at query functions such as the .Select() which you can filter out the empty rows or whatever you need.

[amithvs (Amyth)]

@ddpadil Thanx for the help!! Btw, tried doing so. I already had a FOR loop in my workflow. I put the IF within that. But not getting as expected. I need to check the whole excel whether there is any blank cells. So I guess in condition if we put row(0) it should not work right? i am attaching my recent edited workflow as you suggested. getting an error.

[ddpadil (Dilip)]

Condition to check if item is nothing

For datatable rows have you tried String.IsNullOrEmpty() - you’d have to convert your row to string first but that shouldn’t be a problem in most cases. For the outlook problem I’m a little confused either you have a mail message or you don’t so when you are obtaining a list of mail messages you should know how many you have e.g. your mailMessages array will have 10 items. Therefore you know to check 10 messages and after that you will know that it is going to be nothing. Alternatively you woul…