无法访问文件内容

Question

let file = KSDrive.openFile('https://kdocs.cn/l/xxxx') let sheet = file.Application.ActiveSheet

let fields = sheet.Field.GetFields() file.close() function getFie(item, wantedname) { let sta = item.name.localeCompare(wantedname)
return (sta===0)
}

function getID(wantedname) { for (let i = 0; i < fields.length; i++) { let one = fields[i] if(getFie(one, wantedname)) {
return one.id
}
}
}
let status = getID("项目状态")
sheet.Field.GetFields()

console.log(status) let col = sheet.Columns sheet.Id console.log(sheet.Columns) // 空的
我是真的想骂人

ted · Answer

// 配置 // TODO-自动获取rowEnd // TODO-自动找到某一列 const rowEnd=100 // TODO-rowEnd没法获取
const nameColNum = 1
const elapColNum = 10
const timeColNum = 3
const endColNum = 4
const statusColNum = 6

// 获取当前工作表 const sheet = Application.Selection // 获取当前工作表的使用区域 const usedRange = sheet.UsedRange
const startColumn = sheet.Columns
//console.log(Application.ActiveSheet.Columns)
// 遍历使用区域的每一行

for (let rowNum = 1; rowNum <= rowEnd; rowNum++) { let statusCol = startColumn.Columns(statusColNum) let val = statusCol.Rows(rowNum) let statusVal = val.Text
//console.log(statusVal)
if(statusVal == '未开始') {continue}
//console.log(statusVal)
if (statusVal !== '已完成') {continue}
//console.log(statusVal)
let nowCol = startColumn.Columns(timeColNum)
nowCol = nowCol.Rows(rowNum)
let nowVal = nowCol.Text
let endCol = startColumn.Columns(endColNum)
endCol = endCol.Rows(rowNum)
let endVal = endCol.Value2
if ("ss" instanceof Date) {
console.log("不是时间1")
continue
}
if (endVal instanceof Date) {
console.log("不是时间")
continue
}
nowStr = ""+nowVal
endStr = ""+endVal
let range = endVal-nowVal
console.log("开始"+nowVal)
console.log("结束"+endVal)
let hours = range24
let destVal = Math.round(hours4)
let elapCell = startColumn.Columns(elapColNum).Rows(rowNum)
let nameStr = startColumn.Columns(nameColNum).Rows(rowNum).Text
console.log(nameStr+",结果是:"+ destVal+"刻钟")
elapCell.Value2 = destVal
}
你们AI生成的代码自己跑过吗, 没人维护了? 能用吗这个产品

无法访问文件内容

1 Answers