How to delete a particular cell in the excel using PAD

[Anonymous]

Hi,

I want to delete a particular cell in the excel using PAD.

In PAD, we have delete row and delete column action, but how to delete a particular cell in the excel?

[burque505 · Accepted solution]

Hi @Anonymous, this action will write an empty string into a cell, replacing what was in the cell.

This is the notation for an empty string, might not be visible in the screenshot:

%""%

Before:

After:

[Anonymous]

Actually, I want to delete the selected cell and shifts up the cell value.

[burque505]

Before:

After:

This has the effect of deleting 2B and shifting 3B, 4B and 5B up, but what's really happening is 3B through 5B are written into the column starting at 2B, and then 5B is deleted.

[Anonymous]

It is working, but when I write the value " in the write to excel worksheet action, it is not displaying as empty cell, it is displaying like " in the cell.

[burque505]

Just as in the post farther above, you need to write this into the cell for an empty string:

%""%

Or you can write this, as PAD will translate what you wrote above into this:

%''%

What you see in the screenshot in the flow is how PAD displays this line, i.e. minus the surrounding '%' s.

You can also see from my screenshots that the target cell does, in fact, display as empty.

[Anonymous]

yes, got it thanks