Hello, a customer is asking me to export data to excel or txt file cyclically every few hours or days.
I am trying to create a code to export data from a table to a excel or txt file. With this code works:
table = event.source.parent.getComponent("Table")
filePath = system.dataset.exportExcel("data.xls", 1, table.data)
if filePath != None:
but what I’m trying to do is that when I use this code again don’t generate me a new excel file, I need to use the same file to add more data to it and if possible go deleting the oldest data cyclically every few hours or days.