How do I script making a backup copy of a spreadsheet and its values not its formulas to an archive folder? -
i new google app scripts , have been looking way sheet. using.
driveapp.getfilebyid("146qfnrqonpbcdhv6qb0bschfp8tquxjoac1qg_esy4e").makecopy("dailyarchive" + date() + " backup");
the problem making daily backup , backups updating original , want make backup of values have archive. in sheet importing data jail roster. http://www.kitsapgov.com/sheriff/incustody/jailwebname.xml
here quite simple 1 sheet (you can adapt several sheets)
var source = spreadsheetapp.getactivespreadsheet(); var data = source.getactivesheet().getdatarange(); var cible = spreadsheetapp.create(source.getname()+" backup"); cible.getactivesheet().getrange(data.geta1notation()).setvalues(data.getvalues()); logger.log(cible.getid()); logger.log(cible.geturl());
Comments
Post a Comment