I'm using this extension to export automatically a Google Drive Spreadsheet with CRON every 5 minutes.
Thing is, the sheet's name changes every time a new export is made. So, in /admin/model/extension/module/ie_pro_file_spreadsheet.php there's a line that I changed in order to force the sheet name to be "Data".
Original line:
Code: Select all
$sheet_name = $this->language->get('xlsx_sheet_name_'.$this->profile['import_xls_i_want']).'-'.date('Y-m-d-His');
Code: Select all
$sheet_name = 'Data';
Maybe some of you comes with an idea to solve this. I've spoken with the extension developer and he doesn't know how to solve it.
Currently, I just duplicate the export sheet with the long name and change it to "data" so I can pull everything from that one without changing all the formulas in the other sheets. But I'd like automate the whole process.
Thanks