{"id":123430,"date":"2022-06-27T15:54:11","date_gmt":"2022-06-27T06:54:11","guid":{"rendered":"https:\/\/support.questetra.com\/?p=123430"},"modified":"2023-08-30T09:26:47","modified_gmt":"2023-08-30T00:26:47","slug":"excel-row-get","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/excel-row-get\/","title":{"rendered":"Microsoft 365 Excel: Get 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-get-202307\/\">https:\/\/support.questetra.com\/en\/addons\/excel-row-get-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: Get Row<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Obtains data from the specified row of an Excel sheet as String-type data. The acquisition 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 to Get (e.g. &#8220;1&#8221;, &#8220;11&#8221;)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> C5: Column Range to Get (e.g. &#8220;A:J&#8221;)(Up to 10 columns)<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> C6_1: Data item that stores the value in the 1st column<\/li>\n<li> C6_2: Data item that stores the value in the 2nd column<\/li>\n<li> C6_3: Data item that stores the value in the 3rd column<\/li>\n<li> C6_4: Data item that stores the value in the 4th column<\/li>\n<li> C6_5: Data item that stores the value in the 5th column<\/li>\n<li> C6_6: Data item that stores the value in the 6th column<\/li>\n<li> C6_7: Data item that stores the value in the 7th column<\/li>\n<li> C6_8: Data item that stores the value in the 8th column<\/li>\n<li> C6_9: Data item that stores the value in the 9th column<\/li>\n<li> C6_10: Data item that stores the value in the 10th column<\/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();\nconst range = configs.get( &quot;conf_Range&quot; );\n\ncheckRowNoAndRange( rowNo, range );\nconst columnDefList = [];\nretrieveValueConfigs( columnDefList );\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(GET)\nconst dataStringList = getData( bookInfo.driveId, bookInfo.fileId, sheetName, rowNo, range, oauth2);\n\n\/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 \/ Data Updating ==\nsetDataByLists( columnDefList, dataStringList );\n}\n\n\/**\n* config \u304b\u3089\u884c\u756a\u53f7 \u3092\u8aad\u307f\u51fa\u3059\n* @return {String} rowNo \u884c\u756a\u53f7\n*\/\nfunction retrieveRowNo() {\nconst rowNoDef = configs.getObject( &quot;conf_RowNo&quot; );\nlet rowNo = configs.get( &quot;conf_RowNo&quot; );\nif ( rowNoDef !== null ) {\nrowNo = engine.findData( rowNoDef );\n}\nreturn rowNo;\n}\n\n\/**\n* \u884c\u756a\u53f7\u304c\u7a7a\u3001\u4e0d\u6b63\u306a\u6587\u5b57\u5217\u3067\u3042\u308c\u3070\u30a8\u30e9\u30fc\u3068\u3059\u308b\n* \u5217\u7bc4\u56f2\u304c\u4e0d\u9069\u5207\u306a\u6587\u5b57\u5217\u3067\u3042\u308c\u3070\u30a8\u30e9\u30fc\u3068\u3059\u308b\n* @param {String} rowNo \u884c\u756a\u53f7\n* @param {String} range \u5217\u7bc4\u56f2\n*\/\nfunction checkRowNoAndRange( rowNo, range ) {\nif ( rowNo === &quot;&quot; || rowNo === null ) {\nthrow &quot;Row number is empty.&quot;;\n}\nif ( !isValidNo(rowNo) ) {\nthrow &quot;Invalid Row number.&quot;;\n}\nif ( !isValidRange(range) ) {\nthrow &quot;Invalid Range.&quot;;\n}\n}\n\n\/**\n* \u884c\u756a\u53f7 \u304c\u6709\u52b9\u304b\uff08\u81ea\u7136\u6570\u304b\uff09\u3092\u5224\u5b9a\u3059\u308b\n* @param {String} noString \u884c\u756a\u53f7 \u306e\u6587\u5b57\u5217\n* @return {Boolean} \u6709\u52b9\u306a \u884c\u756a\u53f7 \u304b\u3069\u3046\u304b\n*\/\nfunction isValidNo( noString ) {\nconst idReg = new RegExp( &#39;^[1-9][0-9]*$&#39; );\nreturn idReg.test( noString );\n}\n\n\/**\n* \u5217\u7bc4\u56f2 \u304c\u6709\u52b9\u304b\u3092\u5224\u5b9a\u3059\u308b\n* @param {String} rangeString \u5217\u7bc4\u56f2 \u306e\u6587\u5b57\u5217\n* @return {Boolean} \u6709\u52b9\u306a \u5217\u7bc4\u56f2 \u304b\u3069\u3046\u304b\n*\/\nfunction isValidRange( rangeString ) {\nconst idReg = new RegExp( &#39;^[A-Z]+:[A-Z]+$&#39; );\nreturn idReg.test( rangeString );\n}\n\n\/**\n* config \u306e\u5217\u306e\u5024\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u60c5\u5831\u3092\u8aad\u307f\u51fa\u3057\u3001\u914d\u5217\u306b\u683c\u7d0d\u3059\u308b\n* \u4ee5\u4e0b\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\u3068\u3059\u308b\n* 1. \u5024\u3092\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u91cd\u8907\u3057\u3066\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\n* 2. \u5217\u306e\u5024\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u4e00\u3064\u3082\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u306a\u3044\n* @param {Array&lt;ProcessDataDefinitionView&gt;} valueDefList \u5217\u306e\u5024\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u306e ProcessDataDefinitionView \u3092\u683c\u7d0d\u3059\u308b\u914d\u5217\n*\/\nfunction retrieveValueConfigs( columnDefList ) {\nconst dataItemNumList = []; \/\/ \u30c7\u30fc\u30bf\u9805\u76ee\u306e\u91cd\u8907\u78ba\u8a8d\u7528\nfor (let i = 0; i &lt; COLUMN_NUM; i++) {\nconst columnConfigName = `conf_Column${i+1}`;\nconst columnValueDef = configs.getObject( columnConfigName );\ncolumnDefList.push( columnValueDef );\nif ( columnValueDef !== null ) {\nconst dataItemNum = configs.get( columnConfigName ); \/\/ \u30c7\u30fc\u30bf\u9805\u76ee\u306e\u91cd\u8907\u78ba\u8a8d\u7528\nif ( dataItemNumList.indexOf( dataItemNum ) !== -1 ) { \/\/ \u65e2\u306b\u6307\u5b9a\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u9805\u76ee\nthrow &quot;The same data item is set multiple times.&quot;;\n}\ndataItemNumList.push( dataItemNum ); \/\/ \u30c7\u30fc\u30bf\u9805\u76ee\u306e\u91cd\u8907\u78ba\u8a8d\u7528\n}\n}\nif ( columnDefList.filter( v =&gt; v !== null ).length === 0 ) { \/\/ \u5217\u306e\u5024\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u4e00\u3064\u3082\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u306a\u3044\nthrow &quot;No Data Item is set.&quot;;\n}\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* \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* \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\u30bb\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\n* @param {String,String} driveId, bookId \u53c2\u7167\u5148\u30d5\u30a1\u30a4\u30eb\u306e\u30c9\u30e9\u30a4\u30d6 ID\u3001\u30d5\u30a1\u30a4\u30eb ID\n* @param {String} sheetName \u53c2\u7167\u5148\u30b7\u30fc\u30c8\u306e\u540d\u524d\n* @param {String} rowNo \u53d6\u5f97\u3059\u308b\u884c\n* @param {String} range \u53d6\u5f97\u3059\u308b\u5217\u7bc4\u56f2\n* @param {String} oauth2 OAuth2 \u8a2d\u5b9a\n*\/\nfunction getData( driveId, bookId, sheetName, rowNo, range, oauth2 ){\n\nconst rangeArr = range.split(&#39;:&#39;);\n\nconst getUri = `${GRAPH_URI}${driveId}\/items\/${bookId}\/workbook\/worksheets\/${sheetName}\/range(address=&#39;${sheetName}!${rangeArr[0]}${rowNo}:${rangeArr[1]}${rowNo}&#39;)\/`;\n\nconst response = httpClient.begin()\n.authSetting( oauth2 )\n.get( getUri );\n\nconst responseStr = logAndJudgeError(response, &quot;GET&quot;);\n\nconst jsonObj = JSON.parse( responseStr );\nif (jsonObj.values === undefined ) {\nthrow `No Data in range.`;\n}\n\nconst dataStringList = jsonObj.values[0]\n.slice(0, COLUMN_NUM) \/\/ \u6700\u592710\u5217\n.map( v =&gt; v.toString() ); \/\/ \u3059\u3079\u3066 String \u306b\u5909\u63db\n\nreturn dataStringList;\n}\n\n\/**\n* \u30c7\u30fc\u30bf\u9805\u76ee\u306b\u51fa\u529b\u3059\u308b\n* @param {Array&lt;ProcessDataDefinitionView&gt;} valueDefList \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u306e ProcessDataDefinitionView \u304c\u683c\u7d0d\u3055\u308c\u305f\u914d\u5217\n* @param {Array&lt;String&gt;} dataStringList \u51fa\u529b\u3059\u308b\u30c7\u30fc\u30bf\u304c\u683c\u7d0d\u3055\u308c\u305f\u914d\u5217\n*\/\nfunction setDataByLists( valueDefList, dataStringList ) {\nvalueDefList.forEach( (valueDef, i) =&gt; {\nif ( valueDef !== null) {\nif ( i &gt; dataStringList.length - 1 ) { \/\/ dataStringList \u306e\u8981\u7d20\u304c\u306a\u3044\u5834\u5408\nengine.setData( valueDef, null );\nreturn;\n}\nconst dataString = dataStringList[i];\n\n\/\/ if ( valueDef.matchDataType(&quot;STRING&quot;) ) { \/\/ \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u6587\u5b57\u578b\u306e\u5834\u5408\n\/\/ \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u6539\u884c\u306b\u5bfe\u5fdc\u3057\u3066\u304a\u3089\u305a\u3001\u4fdd\u5b58\u3059\u308b\u6587\u5b57\u5217\u306b\u6539\u884c\u304c\u542b\u307e\u308c\u308b\u5834\u5408\u306e\u30a8\u30e9\u30fc\u306f QBPMS \u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u306b\u4efb\u305b\u308b\nengine.setData( valueDef, dataString );\n\/\/ } else if ( valueDef.matchDataType(&quot;DECIMAL&quot;) ) { \/\/ \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u6570\u5024\u578b\u306e\u5834\u5408\n\/\/ convertTypeAndSetData( valueDef, dataString, &quot;DECIMAL&quot;, &quot;Numeric&quot; );\n\/\/ } else if ( valueDef.matchDataType(&quot;SELECT&quot;) ) { \/\/ \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u9078\u629e\u578b\u306e\u5834\u5408\n\/\/ convertTypeAndSetData( valueDef, dataString, &quot;SELECT&quot;, &quot;Select&quot; );\n\/\/ } else if ( valueDef.matchDataType(&quot;DATE&quot;) ) { \/\/ \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u65e5\u4ed8\u578b\u306e\u5834\u5408\n\/\/ convertTypeAndSetData( valueDef, dataString, &quot;DATE&quot;, &quot;Date&quot; );\n\/\/ } else if ( valueDef.matchDataType(&quot;DATETIME&quot;) ) { \/\/ \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u304c\u65e5\u6642\u578b\u306e\u5834\u5408\n\/\/ convertTypeAndSetData( valueDef, dataString, &quot;DATETIME&quot;, &quot;Datetime&quot; );\n\/\/ }\n\n}\n});\n}\n\n\/**\n* \u30c7\u30fc\u30bf\u9805\u76ee\u306e\u578b\u306b\u3057\u305f\u304c\u3063\u3066\u30c7\u30fc\u30bf\u3092\u5909\u63db\u3057\u3066\u51fa\u529b\u3059\u308b\n* \u5bfe\u5fdc\u3057\u306a\u3044\u30d5\u30a3\u30fc\u30eb\u30c9\u578b\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\u3068\u3059\u308b\n* \u5909\u63db\u3067\u304d\u306a\u3044\u5024\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\u3068\u3059\u308b\n* @param {ProcessDataDefinitionView} dataDef \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u306e ProcessDataDefinitionView\n* @param {String} dataString \u51fa\u529b\u3059\u308b\u30c7\u30fc\u30bf\uff08\u5909\u63db\u524d\u306e\u6587\u5b57\u5217\u30c7\u30fc\u30bf\uff09\n* @param {String} dataType \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u30c7\u30fc\u30bf\u578b\n* @param {String} dataTypeLabel \u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u30c7\u30fc\u30bf\u578b\u306e\u8868\u793a\u540d\uff08\u30a8\u30e9\u30fc\u51fa\u529b\u7528\uff09\n*\/\n\/*\nfunction convertTypeAndSetData( dataDef, dataString, dataType, dataTypeLabel ) {\n\nlet convertedData;\nif ( dataString === &quot;&quot; || dataString === null ) { \/\/ \u7a7a\u5024\u306e\u5834\u5408\u306f null \u3092\u8a2d\u5b9a\nconvertedData = null;\n} else {\ntry { \/\/ try-catch \u3067\u30a8\u30e9\u30fc\u3092\u6355\u6349\nswitch (dataType) {\ncase &#39;DECIMAL&#39;:\nconvertedData = new java.math.BigDecimal( dataString );\nbreak;\ncase &#39;SELECT&#39;: \/\/ \u4e00\u81f4\u3059\u308b\u9078\u629e\u80a2 ID \u304c\u306a\u3044\u5834\u5408\u306e\u30a8\u30e9\u30fc\u306f QBPMS \u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u306b\u4efb\u305b\u308b\nconvertedData = new java.util.ArrayList();\nconvertedData.add( dataString );\nbreak;\ncase &#39;DATE&#39;:\nconvertedData = java.sql.Date.valueOf( dataString );\nbreak;\ncase &#39;DATETIME&#39;:\nconst dateFormatter = new java.text.SimpleDateFormat( &quot;yyyy-MM-dd HH:mm&quot; );\nconvertedData = new java.sql.Timestamp( dateFormatter.parse( dataString ).getTime() );\nbreak;\n}\n} catch (e) { \/\/ \u5909\u63db\u3067\u304d\u306a\u3044\u5024\u306e\u5834\u5408\u306f\u30a8\u30e9\u30fc\nthrow `Returned value &quot;${dataString}&quot; cannot be saved to ${dataTypeLabel} type data item.`;\n}\n}\nengine.setData( dataDef, convertedData );\n}\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\/1bV58rBsJrPrckCKg6zynngKrvPomKCIN\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">excel-row-get.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-get\/\">https:\/\/support.questetra.com\/bpmn-icons\/excel-row-get\/<\/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\n<ul class=\"wp-block-list\">\n\n<li>How to register applications on Microsoft365 (Azure Active Directory) side\n\n<ul class=\"wp-block-list\">\n\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\n<\/ul>\n\n<\/li>\n\n\n<li>How to Setup HTTP Authentication on Questetra side\n\n<ul class=\"wp-block-list\">\n\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\n<ul class=\"wp-block-list\">\n\n<li>&#8220;2.2: OAuth settings on the Questetra side&#8221;<\/li>\n\n<\/ul>\n\n<\/li>\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\n<ul class=\"wp-block-list\">\n\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<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\n<\/ul>\n\n<\/li>\n\n<\/ul>\n\n<\/li>\n\n<\/ul>\n\n<\/li>\n<li>If there is a cell that does not contain a value but is formatted, the row containing that cell is also considered to be used and the last row is identified. (Internally useRange() is used to identify the last row)<\/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-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-get-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-update\/\" target=\"_blank\" rel=\"noopener\">Microsoft 365 Excel: Update 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>Obtains data from the specified row of an Excel sheet as String-type data. The acquisition range can be specified up to 15 columns.<\/p>\n","protected":false},"author":9,"featured_media":123496,"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_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_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":[3161],"faq_section":[],"class_list":["post-123430","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-microsoft-365-ja"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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-get-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":5,"uagb_excerpt":"Obtains data from the specified row of an Excel sheet as String-type data. The acquisition range can be specified up to 15 columns.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-w6O","jetpack-related-posts":[{"id":94768,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/excel-row-insert\/","url_meta":{"origin":123430,"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":123430,"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\/ja\/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":67292,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/googlesheets-appendcells\/","url_meta":{"origin":123430,"position":2},"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\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\/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":79781,"url":"https:\/\/support.questetra.com\/en\/data-items\/table-type\/","url_meta":{"origin":123430,"position":3},"title":"Table-Type","author":"Peter Glover","date":"2021-01-22","format":false,"excerpt":"Displays a table that can use the String, Numeric, Select or Date formats.","rel":"","context":"In &quot;Data Items&quot;","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.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\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.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":123430,"position":4},"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":[]},{"id":97139,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":123430,"position":5},"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":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/06\/excel-get-row-fi-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/123430","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=123430"}],"version-history":[{"count":18,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/123430\/revisions"}],"predecessor-version":[{"id":150587,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/123430\/revisions\/150587"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/123496"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=123430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=123430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=123430"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=123430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}