Robotic Process Automation (RPA)

Hi,

My bot is traying to delete a row, bot it does not working, after this I opened the file and the row still there.

This is the script:

defVar --name empleados --type Excel
defVar --name trabajadores --type DataTable
defVar --name cantidad --type Numeric
excelOpen --file "C:\\Users\\EfectivaVPN\\Downloads\\AlexVirrueta\\employees.xlsx" empleados=value
excelGetTable --file ${empleados} --getfirstsheet  --entiretable  --hasheaders  trabajadores=value
deleteRows --where "Name= \'Ned\'" --dataTable ${trabajadores} cantidad=changedrowscount
logMessage --message "${cantidad}" --type "Info"
excelClose --file ${empleados} --save

Thanks for your help

Hi,

My bot is traying to delete a row, bot it does not working, after this I opened the file and the row still there.

This is the script:

defVar --name empleados --type Excel
defVar --name trabajadores --type DataTable
defVar --name cantidad --type Numeric
excelOpen --file "C:\\Users\\EfectivaVPN\\Downloads\\AlexVirrueta\\employees.xlsx" empleados=value
excelGetTable --file ${empleados} --getfirstsheet  --entiretable  --hasheaders  trabajadores=value
deleteRows --where "Name= \'Ned\'" --dataTable ${trabajadores} cantidad=changedrowscount
logMessage --message "${cantidad}" --type "Info"
excelClose --file ${empleados} --save

Thanks for your help

Hi Alex,

From what I can see, you are missing a command to write the filtered Data Table to the Excel file. Adding a Create from Data Table command right after deleteRows should make it run as you expect. The deleteRows command only filters the Data Table in the specified variable, it does not update the Excel file, that is why adding a command to write to the Excel file should fix it.

Hi,

My bot is traying to delete a row, bot it does not working, after this I opened the file and the row still there.

This is the script:

defVar --name empleados --type Excel
defVar --name trabajadores --type DataTable
defVar --name cantidad --type Numeric
excelOpen --file "C:\\Users\\EfectivaVPN\\Downloads\\AlexVirrueta\\employees.xlsx" empleados=value
excelGetTable --file ${empleados} --getfirstsheet  --entiretable  --hasheaders  trabajadores=value
deleteRows --where "Name= \'Ned\'" --dataTable ${trabajadores} cantidad=changedrowscount
logMessage --message "${cantidad}" --type "Info"
excelClose --file ${empleados} --save

Thanks for your help

Hi Vinicius,

I can delete rwos from the data table and write them in a new sheet of my spreadsheet.

Now I want to delete columns, more than one, is there any command to perform this action?, Delete Columno only deletes 1 column at once.

Thanks for your help

Regards

Hi Alex,

From what I can see, you are missing a command to write the filtered Data Table to the Excel file. Adding a Create from Data Table command right after deleteRows should make it run as you expect. The deleteRows command only filters the Data Table in the specified variable, it does not update the Excel file, that is why adding a command to write to the Excel file should fix it.

Hi,

My bot is traying to delete a row, bot it does not working, after this I opened the file and the row still there.

This is the script:

defVar --name empleados --type Excel
defVar --name trabajadores --type DataTable
defVar --name cantidad --type Numeric
excelOpen --file "C:\\Users\\EfectivaVPN\\Downloads\\AlexVirrueta\\employees.xlsx" empleados=value
excelGetTable --file ${empleados} --getfirstsheet  --entiretable  --hasheaders  trabajadores=value
deleteRows --where "Name= \'Ned\'" --dataTable ${trabajadores} cantidad=changedrowscount
logMessage --message "${cantidad}" --type "Info"
excelClose --file ${empleados} --save

Thanks for your help