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?
Solved! Go to Solution.
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.
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.
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.