英文:
How to fix error Exception: Can not be converted to int
问题
在您提供的代码中，问题出现在以下行：
[weight, width, length, height, dimensions, volume] = [...data.split(';',)]
错误消息指出无法将字符串“500,120,80,250,120х80х250,0.0024”转换为整数。这是因为您尝试将包含浮点数的字符串分割并解构为整数，这会导致错误。
要解决此问题，您应该将数据分割后保留为字符串，而不是尝试将其转换为整数。您可以像这样修改代码：
[weight, width, length, height, dimensions, volume] = data.split(';');
这样，您将保留数据作为字符串数组，而不会尝试将其转换为整数。
此外，请确保在数据中没有包含无法转换为整数的值，否则可能需要在处理数据之前添加一些数据验证。
在修复了此问题后，您的代码应该能够按预期工作。
英文:
I'm trying to use the Property Service as an analogue of the vlookup function here is my code
function setUpProps() {console.log('Set up props');var documentProperties = PropertiesService.getDocumentProperties();documentProperties.deleteAllProperties();var sh = SpreadsheetApp.getActive();var shname = sh.getSheetByName('конфиг');var values = shname.getRange(2, 1, shname.getLastRow(), 7).getValues();props = {};for (i of values) {props[i[0]] = i.slice(1).join(";");}documentProperties.setProperties(props);}function getProps() {var props = PropertiesService.getDocumentProperties();Logger.log(props.getProperties());}function onEdi(e) {var props = PropertiesService.getDocumentProperties();var range = e.range;var sheet = range.getSheet()var row = range.getRow()var shName = e.source.getSheetName();var col = range.getColumn();var g = 'г';if (['мука', 'масла', 'жмыхи', 'десерты', 'лечебные тарвы'].includes(shName) && col == 2) {var arr = [];var itemNames = range.getValues();for (let name of itemNames) {var data = props.getProperty(name + g);Logger.log(name + g);var weight, width, length, height, dimensions, volume;if (data != null) {[weight, width, length, height, dimensions, volume] = [...data.split(';')]var row = [weight, width, length, height, dimensions, volume];Logger.log(row);arr = arr.concat([row]);Logger.log(arr);}}sheet.getRange(row, 21, range.getNumRows(), 6).setValues(arr);}}
error getting in this place sheet.getRange(row, 21, range.getNumRows(), 6).setValues(arr);
Exception: Невозможно преобразовать "500,120,80,250,120х80х250,0.0024" в int.
at onEdi(Copy of PropertyService:43:11)
On function onEdi() I'm set a installable trigger for edit
When I use similar code like this
function onEdit(e) {var props = PropertiesService.getDocumentProperties();const itemCol = 3;const groupCol = 4;var range = e.range;var sheet = range.getSheet()var row = range.getRow()if (range.getColumn() == 2) {var itemIDs = [];var itemGroups = [];var itemNames = range.getValues();for (let name of itemNames) {var data = props.getProperty(name);var itemID, groupName;if (data != null) {[itemID, groupName] = [...data.split(';')]itemIDs.push([itemID]);itemGroups.push([groupName]);} else {itemIDs.push(['NO DATA']);itemGroups.push(['NO DATA']);}}sheet.getRange(row, itemCol, range.getNumRows(), 1).setValues(itemIDs);sheet.getRange(row, groupCol, range.getNumRows(), 1).setValues(itemGroups);}}
it works flawlessly
A simple trigger for edit is also used here
But I want to insert data in an array, tell me where is my mistake?
Gif what I need to output
答案1
得分: 1
你正在重新定义 row。
在 onEdi(e) 的第3行：
var row = range.getRow()
但是在 onEdi(e) 的第23行：
var row = [weight, width, length, height, dimensions, volume];
所以在你的循环中，row 从一个整数重新定义为一个数组。
你可以将其更改为：
let row = [weight, width, length, height, dimensions, volume];
现在会有两个名为 row 的变量，一个在 onEdi(e) 函数的全局范围内，另一个在循环的局部范围内。
英文:
You are redefining row.
On line 3 of onEdi(e):
var row = range.getRow()
But on line 23 of onEdi(e):
var row = [weight, width, length, height, dimensions, volume];
So in your loop row is redefined from an integer to an array.
You could change it to
let row = [weight, width, length, height, dimensions, volume];
Now there would be two variables named row, one at a global scope for the onEdi(e) function and one at the local scope of the for loop.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论