Hi, everybody.
First, thank you in advance for assisting me with this issue: I've created a .xlsx template to generate certain information. I used the RANDBETWEEN function in most of the cells as to create different values to them, so each time that I change a cell or refresh the sheet, everything is recalculated, which is exactly what I want to do. Now, I have to create hundreds of files based on this template, thing that I'm currently doing manually. I'm trying to find a way to automatically open the file, change the values of a column (which in consequence will change the rest of the "random" values), and save this updated file under a new extension (.csv).
So, basically, this is the process that I'm doing by hand:
1. Open template.xlsx. (has two sheets; "book1" is the one that I save, "book2" has some formulas that are used by cells in "book1").
2. Take Column A ("start time"), which has the following format: yyyy-mm-dd hh:mm:ss. Then, change the minutes by 15, for example: 2015-06-15 00:00:00 to 2015-06-15 00:15:00 (so, 4 files per each hour).
3. Save template as .csv file with the following format: NewFile_20150615-0015. (same date/time as the "start time" column, but the date as a single string and the hour as a second string).
So, any pointers/suggestions will be greatly appreciated.
First, thank you in advance for assisting me with this issue: I've created a .xlsx template to generate certain information. I used the RANDBETWEEN function in most of the cells as to create different values to them, so each time that I change a cell or refresh the sheet, everything is recalculated, which is exactly what I want to do. Now, I have to create hundreds of files based on this template, thing that I'm currently doing manually. I'm trying to find a way to automatically open the file, change the values of a column (which in consequence will change the rest of the "random" values), and save this updated file under a new extension (.csv).
So, basically, this is the process that I'm doing by hand:
1. Open template.xlsx. (has two sheets; "book1" is the one that I save, "book2" has some formulas that are used by cells in "book1").
2. Take Column A ("start time"), which has the following format: yyyy-mm-dd hh:mm:ss. Then, change the minutes by 15, for example: 2015-06-15 00:00:00 to 2015-06-15 00:15:00 (so, 4 files per each hour).
3. Save template as .csv file with the following format: NewFile_20150615-0015. (same date/time as the "start time" column, but the date as a single string and the hour as a second string).
So, any pointers/suggestions will be greatly appreciated.