const sheet = ActiveSheet const usedRange = sheet.UsedRange const columnC = sheet.Columns("C") let sum = 0
for (let row = usedRange.Row; row <= usedRange.Row + usedRange.Rows.Count - 1; row++) {
const rangeC = columnC.Rows(row)
const numC = parseFloat(rangeC.Text)
if (!isNaN(numC)) {
sum += numC
}
}
console.log("C列的全部数据相加结果为:", sum)
错误 TypeError:Application.ActiveSheet.Columns is not a function