{"id":118337,"date":"2021-12-28T14:23:27","date_gmt":"2021-12-28T05:23:27","guid":{"rendered":"https:\/\/support.questetra.com\/?p=118337"},"modified":"2023-08-30T09:24:51","modified_gmt":"2023-08-30T00:24:51","slug":"excel-cell-update","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/excel-cell-update\/","title":{"rendered":"Microsoft 365 Excel: Update Cell"},"content":{"rendered":"\n<div style=\"text-align: center; background: #FFFF66; 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-cell-update-202307\/\">https:\/\/support.questetra.com\/en\/addons\/excel-cell-update-202307\/<\/a>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Microsoft 365 Excel: Update Cell<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Updates cell data at the specified position in an Excel sheet.<\/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><span class=\"fa-li\"><i class=\"fal fa-badge-check fa-lg\"><\/i><\/span> 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><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> C4: Target Cell<span style=\"color:#990000;\"> *<\/span><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> C5: Column Value of Update Cell<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\nmain();\nfunction main(){\n  \/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\n  const oauth2 = configs.get( &quot;conf_OAuth2&quot; );\n  const bookUrl = retrieveBookUrl();\n  const sheetName = configs.get( &quot;conf_Title&quot; );\n  if(sheetName === &quot;&quot; || sheetName === null){\n    throw &quot;Sheet Title is empty.&quot;;\n  }\n\n  const cell = configs.get( &quot;conf_Cell&quot; );\n  let values = [];\n  values[0] = configs.get( &quot;conf_Value&quot; ); \/\/1\u30bb\u30eb\u306e\u307f\n\n  \/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n  \/\/ Access to the API 1st(Get Book Info)\n  const bookInfo = getFileInfoByUrl( bookUrl, oauth2 );\n\n  \/\/ Access to the API 3rd(PATCH)\n  patchData( bookInfo.driveId, bookInfo.fileId, sheetName, cell, values, 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() {\n  const bookUrlDef = configs.getObject( &quot;conf_Url&quot; );\n  let bookUrl;\n  if ( bookUrlDef === null ) {\n    bookUrl = configs.get( &quot;conf_Url&quot; )\n  }else{\n    bookUrl = engine.findData( bookUrlDef );\n  }\n  if ( bookUrl === &quot;&quot; || bookUrl === null){\n    throw &quot;Book URL is empty.&quot;\n  }\n  return bookUrl;\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 ) {\n  let fileInfo;\n  if ( fileUrl !== &quot;&quot; && fileUrl !== null ) {\n    \/\/ \u5206\u5272\u4ee3\u5165\n    const {\n      id,\n      parentReference: {\n        driveId\n      }\n    } = getObjBySharingUrl( fileUrl, oauth2 );\n    fileInfo = {driveId: `drives\/${driveId}`, fileId: id};\n  }\n  return 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 ) {\n  if (sharingUrl === &quot;&quot; || sharingUrl === null) {\n    throw `Sharing URL is empty.`;\n  }\n\n  \/\/ encoding sharing URL\n  const encodedSharingUrl = encodeSharingUrl(sharingUrl);\n\n  \/\/ API Request\n  const response = httpClient.begin()\n    .authSetting( oauth2 )\n    .get( `${GRAPH_URI}shares\/${encodedSharingUrl}\/driveItem` );\n\n  const responseStr = logAndJudgeError(response, &quot;GET&quot;);\n\n  return 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 ) {\n  let encodedSharingUrl = base64.encodeToUrlSafeString( sharingUrl );\n  while ( encodedSharingUrl.slice(-1) === &#39;=&#39; ) {\n    encodedSharingUrl = encodedSharingUrl.slice(0,-1);\n  }\n  return `u!${encodedSharingUrl}`;\n}\n\n\/**\n  * \u6307\u5b9a\u30b7\u30fc\u30c8\u306e\u6307\u5b9a\u30bb\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u66f4\u65b0\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  \u633f\u5165\u5148\u30b7\u30fc\u30c8\u306e\u540d\u524d\n  * @param {String} cell  \u66f4\u65b0\u3059\u308b\u30bb\u30eb\u4f4d\u7f6e\n  * @param {Array} values  \u66f4\u65b0\u3059\u308b\u30c7\u30fc\u30bf\n  * @param {String} oauth2  OAuth2 \u8a2d\u5b9a\n  *\/\nfunction patchData( driveId, bookId, sheetName, cell, values, oauth2 ){\n  const patchUri = `${GRAPH_URI}${driveId}\/items\/${bookId}\/workbook\/worksheets\/${sheetName}\/range(address=&#39;${sheetName}!${cell}&#39;)\/`;\n  const requestBody = makeRequestToAdd(values);\n\n  const response = httpClient.begin()\n    .authSetting( oauth2 )\n    .body( JSON.stringify(requestBody), &quot;application\/json&quot; )\n    .patch( patchUri );\n  \n  logAndJudgeError(response, &quot;PATCH&quot;);\n}\n\n\/**\n  * \u65b0\u3057\u3044\u884c\u306b\u8ffd\u52a0\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){\n  let request = {\n    values : [[]]\n  };\n\n    if(values[0] === &quot;&quot; || values[0] === null){\n      request.values[0].push(null);\n    } else {\n      if(values[0].length &gt; 32767){\n        throw &quot;Can&#39;t set text over 32,767 character.&quot;;\n      }\n      request.values[0].push(values[0]);\n    }\n\n  return request;\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){\n  const responseStr = response.getResponseAsString();\n  const status = response.getStatusCode();\n  if(status &gt;= 300){\n    const accessLog = `---${requestType} request--- ${status}\\n${responseStr}\\n`;\n    engine.log(accessLog);\n    throw `Failed in ${requestType} request. status: ${status}`;\n  }\n  return 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\"><li><a href=\"https:\/\/drive.google.com\/file\/d\/1zWEIbrXOBQQjoi-Zu6tziRnr5g36R6X7\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">excel-cell-update.xml<\/a><\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-12-15 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/excel-cell-update\/\">https:\/\/support.questetra.com\/bpmn-icons\/excel-cell-update\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Add-on 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\"><li>Please refer to <a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/excel-online-questetra\/\" target=\"_blank\" rel=\"noreferrer noopener\">this page<\/a> for the HTTP authentication settings on the Questetra side of Excel Online.<\/li><\/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\/2021\/12\/microsoft-365excel-update-cell.png?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\"><li>M<a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/excel-row-insert\/\" target=\"_blank\" rel=\"noreferrer noopener\">icrosoft 365 Excel: Insert New Row<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Updates cell data at the specified position in an Excel sheet.<\/p>\n","protected":false},"author":30,"featured_media":118339,"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-118337","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\/2021\/12\/microsoft365-cell-update-fi-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/microsoft365-cell-update-fi-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/microsoft365-cell-update-fi-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/microsoft365-cell-update-fi-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/microsoft365-cell-update-fi-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/microsoft365-cell-update-fi-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/microsoft365-cell-update-fi-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-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\/2021\/12\/microsoft365-cell-update-fi-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Peter Glover","author_link":"https:\/\/support.questetra.com\/en\/author\/petergloverquestetra\/"},"uagb_comment_info":1,"uagb_excerpt":"Updates cell data at the specified position in an Excel sheet.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-uMF","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":96508,"url":"https:\/\/support.questetra.com\/en\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":118337,"position":0},"title":"Singleline TSV String, Extract Cell","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"excerpt":"Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and ORG type data.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Singleline TSV String, Extract Cell","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-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\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-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":118337,"position":1},"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":84787,"url":"https:\/\/support.questetra.com\/en\/addons\/table-duplicate\/","url_meta":{"origin":118337,"position":2},"title":"Table, Duplicate","author":"IMAMURA, Genichi","date":"2020-02-26","format":false,"excerpt":"Duplicates Table-type data. All cell value stored in Table-type data A is copied over Table-type data B. If the table column definitions are different, an error may occur.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Table, Duplicate","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-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\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":188431,"url":"https:\/\/support.questetra.com\/en\/addons\/excel-row-append-2026\/","url_meta":{"origin":118337,"position":3},"title":"Microsoft 365 Excel: Append New Row","author":"Hirotaka NISHI","date":"2026-07-01","format":false,"excerpt":"Adds a row to the end of an Excel sheet and enters data in each of its cells. The input range can be up to 10 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-append-new-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-append-new-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-append-new-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-append-new-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-append-new-row-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96361,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-append-tsv\/","url_meta":{"origin":118337,"position":4},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18","author":"IMAMURA, Genichi","date":"2020-10-14","format":false,"excerpt":"\u6700\u7d42\u884c\u306bTSV\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u5fc5\u8981\u3067\u3042\u308c\u3070\u3001\u65b0\u3057\u3044\u884c\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002TSV\u306e\u6307\u5b9a\u5217\u3060\u3051\u304c\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002\u306a\u304a\u3001\u5217ID\u3092\u6307\u5b9a\u3059\u308b\u969b\u306b\"d\"\u3092\u4ed8\u8a18\u3059\u308c\u3070\u65e5\u6642\u30c7\u30fc\u30bf\u3068\u3057\u3066\u3001\"n\"\u3092\u4ed8\u8a18\u3059\u308c\u3070\u6570\u5024\u30c7\u30fc\u30bf\u3068\u3057\u3066\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002\u5217\u6307\u5b9a\u306e\u4f8b: \"0,2d,5n\"\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: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-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-Append-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-Append-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-Append-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-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":94744,"url":"https:\/\/support.questetra.com\/ja\/bpmn-icons\/excel-row-insert\/","url_meta":{"origin":118337,"position":5},"title":"Microsoft 365 Excel for Business: \u884c\u633f\u5165","author":"Shiho Tatsumi","date":"2024-06-25","format":false,"excerpt":"\u3053\u306e\u5de5\u7a0b\u306f\u3001\u30b7\u30fc\u30c8\u5185\u306e\u6307\u5b9a\u3055\u308c\u305f\u5834\u6240\u306b\u65b0\u3057\u3044\u884c\u3092\u633f\u5165\u3057\u3001\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;BPMN\u30a2\u30a4\u30b3\u30f3&quot;","block_context":{"text":"BPMN\u30a2\u30a4\u30b3\u30f3","link":"https:\/\/support.questetra.com\/ja\/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":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/118337","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\/30"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=118337"}],"version-history":[{"count":7,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/118337\/revisions"}],"predecessor-version":[{"id":150578,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/118337\/revisions\/150578"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/118339"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=118337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=118337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=118337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}