jenniferjun 回复 Renzheng(提问者)var v1 = _g().getCellValue(0, 1, 1);
var v2 = _g().getCellValue(0, 1, 2);
var v3 = _g().getCellValue(0, 1, 3);
let result = Math.ceil(v1 / v2);
//console.log(result);
let s=result+1
function addDay(dateString,ddays) {
// 将字符串解析为 Date 对象
const date = new Date(dateString);
// 格式化回 YYYY-MM-DD
const year = date.getFullYear();
const month = String(date.getMonth() + 1).padStart(2, '0'); // 月份从0开始
const day = String(date.getDate()).padStart(2, '0');
var ss=year+"-"+month+"-"+day;
return ss;
}
for(var i=1;i<=result;i++)
{
console.log(i);
var n = _g().setCellValue(0, 0, i+ 7,i);
var g=addDay(v3,i-1)
console.log(g);
var p = _g().setCellValue(0, 1, i + 7,g);
var q=v2;
if(i==result){
q=v1%v2;
}
var r = _g().setCellValue(0, 2, i + 7,q);