How to Clear the Data in Sheets In Excel for the last Run?

Help Studio
1

Hello Everyone,
I need to Clear the data in Excel Sheets in the last run and how to know whether it is in last run or not.

2

Hi @raghuramk,

Can you explain what you process does?

1 Like
3

Thank you for your response @Gabriele_Camilli basically Bot will run from 6 am to 6:30 pm with Excel Sheets Containing Data. In the last run Bot need to Clean the Data that Present in the Sheets.

4

Why is it needed to clean the excel sheet?
Does the file need to be clean fo the last iteration?

Can your case support a limit time (e.g. 6:20) after which you go into “Last Iteration Mode”?

5

@Gabriele_Camilli yes, in the last iteration i need to Clean the file.
My bot will run every 40 mins in the above intervals

6

The easiest, more riliable way and the one i personally use is to overwrite the file with a Template file into the folder using the Move File Activity

You can set this action to activate after a Timestamp you think reasonable

7

Thanks Cheers

8

As with many aspects in Excel, the used range is fraught with nuance, but you can easily set up an example to understand the concept. As illustrated in Figure 1, carry out these steps in a blank worksheet:

  • Type the number 100 in cell A10.
  • Press Ctrl-Home to move your cursor back to cell A1.
  • Press End-Home to move to the last used cell in your worksheet. Your cursor should now return to cell A10.
  • Press Ctrl-G (or the F5 key) to launch the Go To dialog box, enter the address TX5000, and then press Enter.
  • Type the number 100 in cell TX5000 and then press Enter.
  • Move your cursor up one cell and then press the Delete key to clear cell TX5000.
  • Press Ctrl-Home to move your cursor back to cell A1.
  • Press End-Home to move to the last used cell in your worksheet. Your cursor will now return to cell TX5000, even though you erased it.
9

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