Edit Excel workbook without saving it

[jan]

Hello, could you please add a new “Save” parameter to activities such as Write Value, Write Range, Excel Scope, Run Macro… because sometimes it just takes unnecessarily too long and sometimes it is just desired to do some changes, get the result and close the workbook without saving it.
Thanks

[rajeshprabhu_gp (Rajesh prabhu)]

Hi,

latest version of Studio has the Property check box for AutoSave set to true/false in Excel Application scope, that will do

Thanks~Rajesh

[Ignacio_Insua_Feito]

@jan

Hello, could you please add a new “Save” parameter to activities such as Write Value, Write Range, Excel Scope, Run Macro… because sometimes it just takes unnecessarily too long and sometimes it is just desired to do some changes, get the result and close the workbook without saving it.

he probably did not have the last update

[badita (Mihai Badita)]

yep. it is out in 18.1.

Excel generic - Save toggle + Save activity

Hi Team, It could help in the long run to have the ability to toggle saving in excel activities, either per activity (preferred) or as a transaction-like scope. There are use cases with legitimate reason to iterate over cells and modify something about them (latest being changing cell colors that are not a full range). If there would be a boolean flag for those to not save immediately, it could save a lot of execution time. For compatibility reasons default should remain to save. Major candi…