Sql query to delete the excel sheet data

Help
21

Bro, This method I already used as you suggest me in the earlier post. But not resolve the issue. It’s not deleting any records from the excel.

22

Fine can i have a view on the property panel of the INSERT/DELETE activity
Cheers @balkishan

1 Like
23

Sure
image

24

Are you there @Palaniyappan

1 Like
25

yah there buddy
i still wonder y so
kindly share the whole project in a zipped folder if possible
lets see
if not we can go remove datarow
Cheers @balkishan

1 Like
26

First I fed up this new updated version. It’s not showing any error popup message what is the exact error is.
If I see in the Right side it show me the two error of One Activity. What I understood from this error.
image

Previously what happened if we’re running in the Debug mode by pressing the f7 and run the each activity by pressing the f11.
Now they changed the debug mode key from f7 to f6.

Now the error is on the Insert/Delete Rows Activity when I press the f11 not giving any response. Suppose it should display that Error Message.
image

27

Hi @Palaniyappan As I checked this, It’s working for small data contain excel. Not huge. That I told you I have huge data I that excel is Macro Enable. There it’s not working. Not removing even single row.

See I have how many rows.
Once I come to this Activity, My machine processor speed high and the FAN speed is increasing with giving sound. And the system got hanged.

For small excel data it’s working that you give me the logic but not for this bro, for Macro Enable Excel.

image
image728×302 12.4 KB

Note:- This activity just seeing it’s Executing but not doing anything.

28

Can we try with DataRow Bro ?

I have seen the many solution to remove the complete data from the sheet. But didn’t get the best solution.

1 Like
29

Ohhh
Sorry for the delayed response
Was in a meeting that’s why
Hmm fine
lets do one thing
one steps we can use CLEAR DATATABLE activity which will remove all the data in the datatble except the header

Cheers @balkishan

1 Like
30

I have to remove Headers also bro. Then How to remove the headers.

1 Like
31

then rather to delete that excel we can create a new file itself right
Cheers @balkishan

32

If we Delete and Re-Create the Excel it will change the Order. I have more than 20 sheets in One Excel File.
So I want to clear the complete data from the Existing sheet then copy the New data inside it.

1 Like
33

CLEAR DATATABLE Not worked

1 Like
34

so you want to delete only the data of one sheet and let the remaining as it is
then in that case while reading with READ RANGE uncheck ADD HEADERS and get the datatable
and while writing uncheck ADD HEADERS

fine may i know what was the issue

Cheers @balkishan

35

will this Clear the data from the Sheet

36

it would
were we facing any issue buddy
Cheers @balkishan

37

No, Bro this is not working. It’s not clear any data from the dataTable.
Still my data is there in the Excel.