{"id":123461,"date":"2022-06-27T16:41:59","date_gmt":"2022-06-27T07:41:59","guid":{"rendered":"https:\/\/support.questetra.com\/?p=123461"},"modified":"2023-08-30T09:36:24","modified_gmt":"2023-08-30T00:36:24","slug":"excel-row-update","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/excel-row-update\/","title":{"rendered":"Microsoft 365 Excel: Update Row"},"content":{"rendered":"\n<div style=\"text-align: center; background: #FFF4CC; margin: 1em; padding: 1em;\">\n<h3><span class=\"material-icons\">warning<\/span> PAGE UPDATED<\/h3>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/excel-row-update-202307\/\">https:\/\/support.questetra.com\/en\/addons\/excel-row-update-202307\/<\/a>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">Microsoft 365 Excel: Update Row<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Updates Rows of an Excel sheet. The update range can be specified up to 15 columns.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li>C1: OAuth2 Setting<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-caret-square-down fa-lg\"><\/i><\/span> C2: Target Book URL<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> C3: Target Sheet Title<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> C4: Row No to update new row(When empty, the top row)<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> C5: Column Range to Update (e.g. &#8220;A:J&#8221;)(Up to 10 columns)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> C6_1: 1st Column Value of updated Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> C6_2: 2nd Column Value of updated Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> C6_3: 3rd Column Value of updated Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> C6_4: 4th Column Value of updated Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> C6_5: 5th Column Value of updated Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> C6_6: 6th Column Value of updated Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> C6_7: 7th Column Value of updated Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> C6_8: 8th Column Value of updated Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> C6_9: 9th Column Value of updated Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> C6_10: 10th Column Value of updated Row<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\n\/\/ OAuth2 config sample at [OAuth 2.0 Setting]\n\/\/ - Authorization Endpoint URL: https:\/\/login.microsoftonline.com\/common\/oauth2\/v2.0\/authorize\n\/\/ - Token Endpoint URL: https:\/\/login.microsoftonline.com\/common\/oauth2\/v2.0\/token\n\/\/ - Scope: https:\/\/graph.microsoft.com\/Files.ReadWrite.All offline_access\n\/\/ - Consumer Key: (Get by Microsoft Azure Active Directory)\n\/\/ - Consumer Secret: (Get by Microsoft Azure Active Directory)\n\nconst GRAPH_URI = &quot;https:\/\/graph.microsoft.com\/v1.0\/&quot;;\n\nconst COLUMN_NUM = 10;\n\nmain();\nfunction main(){\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst oauth2 = configs.get( &quot;conf_OAuth2&quot; ) + &quot;&quot;;\nconst bookUrl = retrieveBookUrl();\nconst sheetName = configs.get( &quot;conf_Title&quot; ) + &quot;&quot;;\nif(sheetName === &quot;&quot; || sheetName === null){\nthrow &quot;Sheet Title is empty.&quot;;\n}\n\nconst rowNo = retrieveRowNo();\n\nconst range = configs.get( &quot;conf_Range&quot; );\n\nlet values = [];\nretrieveValues( range, values );\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/ Access to the API 1st(Get Book Info)\nconst bookInfo = getFileInfoByUrl( bookUrl, oauth2 );\n\n\/\/ Access to the API 2nd(PATCH)\npatchData( bookInfo.driveId, bookInfo.fileId, sheetName, rowNo, values, range, oauth2);\n}\n\n\/**\n* config \u304b\u3089\u30d6\u30c3\u30af\u306e URL \u3092\u8aad\u307f\u51fa\u3059\u3001\u7a7a\u306a\u3089\u30a8\u30e9\u30fc\n* @return {String} \u30d6\u30c3\u30af\u306e URL\n*\/\nfunction retrieveBookUrl() {\nconst bookUrlDef = configs.getObject( &quot;conf_Url&quot; );\nlet bookUrl;\nif ( bookUrlDef === null ) {\nbookUrl = configs.get( &quot;conf_Url&quot; )\n}else{\nbookUrl = engine.findData( bookUrlDef );\n}\nif ( bookUrl === &quot;&quot; || bookUrl === null){\nthrow &quot;Book URL is empty.&quot;\n}\nreturn bookUrl;\n}\n\n\/**\n* config \u304b\u3089\u884c\u756a\u53f7\u306e\u5024\u3092\u8aad\u307f\u51fa\u3059\u3001\u7a7a\u306a\u30891\n* \u6570\u5b57\u3067\u306a\u3044\u6587\u5b57\u304c\u5165\u3063\u3066\u3044\u308b\u304b\u3001\u30b7\u30fc\u30c8\u306e\u7bc4\u56f2\u5916\u3067\u3042\u308b\u6570\u5b57\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\n* \u30b7\u30fc\u30c8\u306e\u7bc4\u56f2: 1 ~ 1048576\n* @return {Number} \u884c\u756a\u53f7\n*\/\nfunction retrieveRowNo() {\nconst rowNoDef = configs.getObject( &quot;conf_RowNo&quot; );\nlet rowNo;\nif ( rowNoDef === null ) {\nrowNo = configs.get( &quot;conf_RowNo&quot; )\n} else {\nrowNo = engine.findData( rowNoDef );\n}\nif ( rowNo === &quot;&quot; || rowNo === null){\nrowNo = &quot;1&quot;;\n}\nconst reg = new RegExp( &#39;^[1-9][0-9]*$&#39; );\nif ( !reg.test( rowNo ) ){\nthrow &quot;Row no must be a positive integer.&quot;;\n}\nrowNo = parseInt(rowNo, 10); \/\/parse to int\nif ( rowNo &gt; 1048576 ){\nthrow &quot;Row no must be 1048576 or below.&quot;;\n}\nreturn rowNo;\n}\n\n\/**\n* \u6307\u5b9a\u3055\u308c\u305f\u7bc4\u56f2\u3092\u8003\u616e\u3057\u3064\u3064\u66f4\u65b0\u30c7\u30fc\u30bf\u3092\u6e96\u5099\n* \u7bc4\u56f2\u3092\u512a\u5148\u3057\u3001\u7bc4\u56f2\u5916\u306e\u6307\u5b9a\u30c7\u30fc\u30bf\u9805\u76ee\u306f\u7121\u8996\u3059\u308b\n* @param {Array} range \u7bc4\u56f2\u306e\u914d\u5217\n* @param {Array} values \u66f4\u65b0\u30c7\u30fc\u30bf\u306e\u914d\u5217\n*\/\nfunction retrieveValues( range, values ) {\n\n\/\/range\u306e\u7bc4\u56f2\u306b\u5408\u308f\u305b\u3066\u30c7\u30fc\u30bf\u3092\u6e96\u5099\u3001\u6700\u5927\u6570\u306e\u5236\u9650\u3042\u308a\nconst rangeArr = range.split(&#39;:&#39;);\nconst from = convertA1toR1C1(rangeArr[0] + &quot;&quot;);\nconst to = convertA1toR1C1(rangeArr[1] + &quot;&quot;);\nconst target = to - from + 1;\nlet limit = COLUMN_NUM;\nif (target &lt;= COLUMN_NUM) {\nlimit = target;\n}\n\nfor (let i = 0; i &lt; limit; i++) {\nconst columnConfigName = `conf_Column${i+1}`;\nconst columnValue = configs.get( columnConfigName );\nvalues.push( columnValue );\n}\n}\n\n\/**\n* \u30d5\u30a9\u30eb\u30c0\u306e URL \u304b\u3089\u30d5\u30a1\u30a4\u30eb\u60c5\u5831\uff08\u30c9\u30e9\u30a4\u30d6 ID \u3068\u30d5\u30a1\u30a4\u30eb ID\uff09\u3092\u53d6\u5f97\u3057\u3001\n* \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u8fd4\u3059\uff08URL \u304c\u7a7a\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\u3068\u3059\u308b\uff09\n* @param {String} fileUrl \u30d5\u30a9\u30eb\u30c0\u306e URL\n* @param {String} oauth2 OAuth2 \u8a2d\u5b9a\n* @return {Object} fileInfo \u30d5\u30a1\u30a4\u30eb\u60c5\u5831 {driveId, fileId}\n*\/\nfunction getFileInfoByUrl( fileUrl, oauth2 ) {\nlet fileInfo;\nif ( fileUrl !== &quot;&quot; && fileUrl !== null ) {\n\/\/ \u5206\u5272\u4ee3\u5165\nconst {\nid,\nparentReference: {\ndriveId\n}\n} = getObjBySharingUrl( fileUrl, oauth2 );\nfileInfo = {driveId: `drives\/${driveId}`, fileId: id};\n}\nreturn fileInfo;\n}\n\n\/**\n* OneDrive \u306e\u30c9\u30e9\u30a4\u30d6\u30a2\u30a4\u30c6\u30e0\uff08\u30d5\u30a1\u30a4\u30eb\u3001\u30d5\u30a9\u30eb\u30c0\uff09\u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3001JSON \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u8fd4\u3059\n* API \u306e\u4ed5\u69d8\uff1ahttps:\/\/docs.microsoft.com\/ja-jp\/onedrive\/developer\/rest-api\/api\/shares_get?view=odsp-graph-online\n* @param {String} sharingUrl \u30d5\u30a1\u30a4\u30eb\u306e\u5171\u6709 URL\n* @param {String} oauth2 OAuth2 \u8a2d\u5b9a\n* @return {Object} responseObj \u30c9\u30e9\u30a4\u30d6\u30a2\u30a4\u30c6\u30e0\u306e\u30e1\u30bf\u30c7\u30fc\u30bf\u306e JSON \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n*\/\nfunction getObjBySharingUrl( sharingUrl, oauth2 ) {\nif (sharingUrl === &quot;&quot; || sharingUrl === null) {\nthrow `Sharing URL is empty.`;\n}\n\n\/\/ encoding sharing URL\nconst encodedSharingUrl = encodeSharingUrl(sharingUrl);\n\n\/\/ API Request\nconst response = httpClient.begin()\n.authSetting( oauth2 )\n.get( `${GRAPH_URI}shares\/${encodedSharingUrl}\/driveItem` );\n\nconst responseStr = logAndJudgeError(response, &quot;GET&quot;);\n\nreturn JSON.parse( responseStr );\n}\n\n\/**\n* \u5171\u6709URL\u3092unpadded base64url \u5f62\u5f0f\u306b\u30a8\u30f3\u30b3\u30fc\u30c9\u3059\u308b\n* @param {String} sharingUrl \u5171\u6709 URL\n* @return {String} encodedSharingUrl \u30a8\u30f3\u30b3\u30fc\u30c9\u3055\u308c\u305f\u5171\u6709 URL\n*\/\nfunction encodeSharingUrl( sharingUrl ) {\nlet encodedSharingUrl = base64.encodeToUrlSafeString( sharingUrl );\nwhile ( encodedSharingUrl.slice(-1) === &#39;=&#39; ) {\nencodedSharingUrl = encodedSharingUrl.slice(0,-1);\n}\nreturn `u!${encodedSharingUrl}`;\n}\n\n\/**\n* \u6307\u5b9a\u30b7\u30fc\u30c8\u306e\u6307\u5b9a\u884c\u306b\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3059\u308b\n* @param {String,String} driveId, bookId \u633f\u5165\u5148\u30d5\u30a1\u30a4\u30eb\u306e\u30c9\u30e9\u30a4\u30d6 ID\u3001\u30d5\u30a1\u30a4\u30eb ID\n* @param {String} sheetName \u66f4\u65b0\u5148\u30b7\u30fc\u30c8\u306e\u540d\u524d\n* @param {Number} rowNo \u66f4\u65b0\u7b87\u6240\u306e\u884c\u756a\u53f7\n* @param {Array} values \u66f4\u65b0\u3059\u308b\u30c7\u30fc\u30bf\u306e\u914d\u5217\n* @param {String} range \u66f4\u65b0\u3059\u308b\u5217\u7bc4\u56f2\n* @param {String} oauth2 OAuth2 \u8a2d\u5b9a\n*\/\nfunction patchData( driveId, bookId, sheetName, rowNo, values, range, oauth2 ){\n\nconst rangeArr = range.split(&#39;:&#39;);\n\nconst patchUri = `${GRAPH_URI}${driveId}\/items\/${bookId}\/workbook\/worksheets\/${sheetName}\/range(address=&#39;${sheetName}!${rangeArr[0]}${rowNo}:${rangeArr[1]}${rowNo}&#39;)\/`;\nconst requestBody = makeRequestToAdd(values);\n\nconst response = httpClient.begin()\n.authSetting( oauth2 )\n.body( JSON.stringify(requestBody), &quot;application\/json&quot; )\n.patch( patchUri );\n\nlogAndJudgeError(response, &quot;PATCH&quot;);\n}\n\n\/**\n* \u66f4\u65b0\u3059\u308b\u30c7\u30fc\u30bf\u3092\u3001JSON \u5f62\u5f0f\u306b\u5909\u63db\u3059\u308b\n* @param {Array} values \u30c7\u30fc\u30bf\u306e\u5165\u3063\u305f\u914d\u5217\n* @return {JSON Object} \u5909\u63db\u3057\u305f JSON \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\n*\/\nfunction makeRequestToAdd(values){\nlet request = {\nvalues : [[]]\n};\nfor (let i = 0; i &lt; values.length; i++) {\nif(values[i] === &quot;&quot; || values[i] === null){\nrequest.values[0].push(null);\n} else {\nif(values[i].length &gt; 32767){\nthrow &quot;Can&#39;t set text over 32,767 character.&quot;;\n}\nrequest.values[0].push(values[i]);\n}\n}\nreturn request;\n}\n\n\/**\n* \u5217\u3092\u6307\u5b9a\u3059\u308b\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u3092\u6570\u5024\u5909\u63db\u3059\u308b\uff08\u4f8b\uff1aA\u21921\u3001C\u21923\uff09\n* @param {String} columnString \u5217\u3092\u6307\u5b9a\u3059\u308b\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\n* @return {Number} num \u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u306b\u5bfe\u5fdc\u3057\u305f\u6570\u5024\n*\/\nfunction convertA1toR1C1(columnString) {\nconst RADIX = 26;\nconst A = &#39;A&#39;.charCodeAt(0);\nlet str = columnString.toUpperCase();\nlet num = 0;\nlet strLength = str.length;\nfor (let i = 0; i &lt; strLength; i++) {\nnum = (num * RADIX) + (str.charCodeAt(i) - A + 1);\n}\nreturn num;\n}\n\n\/**\n* \u30ed\u30b0\u306e\u51fa\u529b\u3068\u3001\u30a8\u30e9\u30fc\u767a\u751f\u6642\u306e\u30b9\u30ed\u30fc\u3092\u884c\u3046\n* @param {HttpResponseWrapper} response \u30ea\u30af\u30a8\u30b9\u30c8\u306e\u5fdc\u7b54\n* @param {String} requestType \u30ea\u30af\u30a8\u30b9\u30c8\u3092\u3069\u306e\u5f62\u5f0f\u3067\u884c\u3063\u305f\u304b(&quot;GET&quot; or &quot;POST&quot; or &quot;PATCH&quot;)\n* @return {String} responseStr \u30ec\u30b9\u30dd\u30f3\u30b9\u306e\u6587\u5b57\u5217\n*\/\nfunction logAndJudgeError(response, requestType){\nconst responseStr = response.getResponseAsString();\nconst status = response.getStatusCode();\nif(status &gt;= 300){\nconst accessLog = `---${requestType} request--- ${status}\\n${responseStr}\\n`;\nengine.log(accessLog);\nthrow `Failed in ${requestType} request. status: ${status}`;\n}\nreturn responseStr;\n}\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAEZklEQVRYR8WXf2xTVRTHv3evo9v6\n+\/XHyuZccRMjc8QRkkFEI9MWJCHBJSgqzIjJshFxjqHGuCAh8VdcJy7DEYyiGY5\/QDFElHaKmZjM\nP3AiatAprcsiLDoawlZbWXvNvesrb91r+waY3qRJ8969537uOd9zzn0EOR5E7f4ljWuLtPpIPSVk\nJQGtAYgLgCWxPgTQIAUZIpSeiE4UfPTnvqNhNbazArieXeNEbOp5QtAEoECNUQARSrEXgub14BvH\nLmRakxHA1eZuIiAdAHQqN06dNklBtwe9\/r3p1qcFcG33vE0omq9x4xnLKEFPsMO3RcmWIoCrzd1H\nQB65EZtLNijowaDX\/2iqzVkAak6+ofYBLHEtQrmtBA6DiG+Gh9B+uCsrr5InZgAkYt4jWVpeeSfu\nr1qGCkcZ5pvsEPUmGAv1yBc0MzY7dnoAT\/W+nBWATaCgzXJNJAGY2kl86jdJcD++8gmK5qkTPQMQ\nBAE2vRlxSkETP\/afEIIuXy8Gf\/9BApykeZpKKTuuAmzzvEkInpFmnes4rupEbBIDWOh0odhk5dDh\nfyN8rUDyUKQtxK4jPXj\/5JGkPUqxO9jpa2UPOAAvMobouDzP5woghWBwx0Es2zWt3xbPRrR4Ns0C\nYHUiellrZcWKAyzY5t4IQnrlR04HwNz7z5UotJp8CHkCX8I8wIbNYMEdpZU4MzqMqXiMe6Om\/HYl\nAIDSTYFO\/wEO4GrzvEuAzekA3vnqEBaXLURtxWIMX\/gDHZ\/tx56GdmgSYmQAI+PnuUhXVa\/A8TMn\nuSmnyYZ7bluqCECB94Je35PTHmhzfweQmnQAbNPOzz9Ad0M7uvs\/xH1Vy\/lJpSHPAnkImuoexnNr\nNit7AHQo4PUvSQB4LsoaC7crD0EsHseLh97C6uq78OnpAbz2UGvS\/VIIWE0oNlphLjIgFL6MWDzG\n09WqN6cBQCjg9YkSAE2VfKoGvh85i\/quFhzeupvHVT7SeWCr+zG0rmpIB4CA10dUATDhdfkPwKIz\nITR5CU9zzV6tYQyAndRuFFFitmP04hivBRpBwAL7TaoAMobg3F+j2NPfh1fXt6Jx\/068tK6ZG5Zr\nYHhsBKLOiLU1K3F06AR\/VWopRt2iWjUhSC9CFv+dH3ejfqmbu\/7rX0\/hi58GsWPdFuQlvMA8MPDL\nKR7\/xnvXo7u\/D5ErUdzqLMcTdz+YXYSZ0pABTETD0M0r4Gk3EQljNDSGm63zk6WaAZRYHHAYRdj0\nFvw9EeIeyBfyYTdYVKThHApRqlilLFCqhBlFKC9EN6IUsz5gN4i8H4xdGudpyDxWJjqzl2JeDa+z\nGd3iKEOxUZzloKl4HI\/vewFnzweS72Y1Iw6Q0o6b6zagqrSCx5bFlQlMpy2ckX5KlVApRCnPlNvx\ndE\/gl9DkhSTVGOsHq6tX8NbrNNt47psK9fjy52+v\/0IibabmSqbilIpTsl7JkhC5vJT+H56Y87Vc\n5oncfZgkIXL5aSZXUs4+Tq9V8WrX\/Qc0OzY\/XizhkgAAAABJRU5ErkJggg==\n\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1vAbeC2GqEViqmg4UL4FoE0XjQkSPNRX0\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">excel-row-update.xml<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2022-06-20 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/excel-row-update\/\">https:\/\/support.questetra.com\/bpmn-icons\/excel-row-update\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Addon-import feature is available with <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<br>Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>About the settings for integration with Microsoft365 services\n<ul class=\"wp-block-list\">\n<li>How to register applications on Microsoft365 (Azure Active Directory) side\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/developer-blog\/office365-app-regist-2\/\" target=\"_blank\">Application Registration Procedure in Office 365 for Linking Office 365 and Questetra Cloud Workflow with API<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>How to Setup HTTP Authentication on Questetra side\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/developer-blog\/onedrive-questetra\/\" target=\"_blank\">How to Output Files from Cloud-based Workflow Questetra to OneDrive<\/a>\n<ul class=\"wp-block-list\">\n<li>&#8220;2.2: OAuth settings on the Questetra side&#8221;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u203b Note: \u3000If the Excel Online file is on a SharePoint Online (SPO) document library, the scope to be specified is different\n<ul class=\"wp-block-list\">\n<li>Not on SPO document library \u2192 <a href=\"https:\/\/graph.microsoft.com\/\" rel=\"nofollow\">https:\/\/graph.microsoft.com\/<\/a><strong>Files<\/strong>.ReadWrite offline_access<\/li>\n\n\n\n<li>On the SPO document library \u2192 <a href=\"https:\/\/graph.microsoft.com\/\" rel=\"nofollow\">https:\/\/graph.microsoft.com\/<\/a><strong>Sites<\/strong>.ReadWrite.All offline_access<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>In cases where there is a mismatch between the column range to be added and the specification of the value to be added on line 0 of the tail line, the column range to be added takes precedence.<br>\nFor example, if the column range is specified as \u201cA:C\u201d (for 3 lines), the values to be added after the fourth line are ignored.<\/li>\n\n\n\n<li>An error may occur if the sheet name contains parentheses or other symbols. If an error occurs, consider changing the sheet name.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row.jpg?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/excel-row-insert\/\" target=\"_blank\" rel=\"noopener\">Microsoft 365 Excel: Insert New Row<\/a><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/excel-row-append\/\" target=\"_blank\" rel=\"noopener\">Microsoft 365 Excel: Append New Row<\/a><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/excel-row-get\/\" target=\"_blank\" rel=\"noopener\">Microsoft 365 Excel: Get Row<\/a><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/en\/addons\/excel-find-row\/\" target=\"_blank\" rel=\"noopener\">Microsoft 365 Excel: Find Row Number By Specified Value<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Updates Rows of an Excel sheet. The update range can be specified up to 15 columns.<\/p>\n","protected":false},"author":9,"featured_media":123452,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[3160],"class_list":["post-123461","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-microsoft-365"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Tsuyoshi Kusaka","author_link":"https:\/\/support.questetra.com\/en\/author\/kusaka0211\/"},"uagb_comment_info":4,"uagb_excerpt":"Updates Rows of an Excel sheet. The update range can be specified up to 15 columns.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-w7j","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":94768,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/excel-row-insert\/","url_meta":{"origin":123461,"position":0},"title":"Microsoft 365 Excel for Business: Insert New Row","author":"Shiho Tatsumi","date":"2024-06-25","format":false,"excerpt":"This item inserts a new row with data at the specified position in a sheet.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-Excel-insert-row.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-Excel-insert-row.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-Excel-insert-row.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-Excel-insert-row.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/06\/bpmn-icon-Excel-insert-row.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82087,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/excel-online-questetra\/","url_meta":{"origin":123461,"position":1},"title":"How to Output Data to Excel Online From the Cloud-based Workflow Questetra (API Integration Setting Procedure)","author":"Tsuyoshi Kusaka","date":"2019-11-06","format":false,"excerpt":"Questetra BPM Suite \u2192 Excel Online \u3078\u306e\u9023\u643a\u306e\u8a2d\u5b9a\u306b\u3064\u3044\u3066\u307e\u3068\u3081\u307e\u3057\u305f","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/excelonline-questetra-eyecatch.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/excelonline-questetra-eyecatch.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/excelonline-questetra-eyecatch.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/excelonline-questetra-eyecatch.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/excelonline-questetra-eyecatch.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":97139,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":123461,"position":2},"title":"Google Sheets: Sheet Row, Update with Singleline TSV","author":"IMAMURA, Genichi","date":"2020-10-28","format":false,"excerpt":"Updates a Google Sheet with a single line of TSV data. Searches for an A-Column cell that exactly matches the first value of the TSV and overwrite only the first occurrence. The values will be parsed as if they were entered manually by the user. If no matching line exists,\u2026","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Google Sheets: Sheet Row, Update with Singleline TSV","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":97147,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":123461,"position":3},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u30c7\u30fc\u30bf, \u5358\u4e00\u884cTSV\u3067\u66f4\u65b0","author":"IMAMURA, Genichi","date":"2020-10-28","format":false,"excerpt":"\u5358\u4e00\u884cTSV\u30c7\u30fc\u30bf\u3067Google\u30b7\u30fc\u30c8\u3092\u66f4\u65b0\u3057\u307e\u3059\u3002TSV\u306e\u5148\u982d\u5024\u3068\u5b8c\u5168\u4e00\u81f4\u3059\u308bA\u30bb\u30eb\u3092\u63a2\u7d22\u3057\u3001\u6700\u521d\u306b\u5408\u81f4\u3057\u305f\u884c\u306b\u3064\u3044\u3066\u4e0a\u66f8\u304d\u3057\u307e\u3059\u3002\u305d\u308c\u305e\u308c\u5024\u306f\u3001\u624b\u5165\u529b\u3057\u305f\u969b\u3068\u540c\u69d8\u306b\u81ea\u52d5\u89e3\u6790\u3055\u308c\u307e\u3059\u3002\u3082\u3057\u5408\u81f4\u3059\u308b\u884c\u304c\u7121\u3044\u5834\u5408\u306f\u3001\u672b\u5c3e\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: \u884c\u30c7\u30fc\u30bf, \u5358\u4e00\u884cTSV\u3067\u66f4\u65b0","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":67292,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlesheets-appendcells\/","url_meta":{"origin":123461,"position":4},"title":"Google Sheets: Append New Row","author":"Shiho Tatsumi","date":"2024-02-27","format":false,"excerpt":"This item adds a row at the last of the sheet, and fills each cell of that row with data.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":150172,"url":"https:\/\/support.questetra.com\/en\/addons\/excel-row-update-202307\/","url_meta":{"origin":123461,"position":5},"title":"Microsoft 365 Excel: Update Row","author":"Tsuyoshi Kusaka","date":"2023-08-04","format":false,"excerpt":"Updates Rows of an Excel sheet. The update range can be specified up to 15 columns.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-update-row-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/123461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=123461"}],"version-history":[{"count":15,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/123461\/revisions"}],"predecessor-version":[{"id":150589,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/123461\/revisions\/150589"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/123452"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=123461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=123461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=123461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}