{"id":13422,"date":"2022-10-03T09:46:32","date_gmt":"2022-10-03T00:46:32","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=13422"},"modified":"2023-02-17T09:31:42","modified_gmt":"2023-02-17T00:31:42","slug":"target_table","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/target_table\/","title":{"rendered":"About a targeted table position or range"},"content":{"rendered":"\n

<\/i>   Home<\/a> > User guide<\/a> > BOT<\/a> > How to use the BOT editor<\/a> > Extention<\/a> > Excel (xlsx)<\/a> > About a targeted table position or range<\/p>\n\n\n\n

This page explains \"targeted table position or range\" using an example for Excel files.<\/p>\n\n\n\n

Targeted table position or range<\/strong><\/h2>\n\n\n\n
<\/div>\n\n\n\n

This is an example of specifying a range.<\/p>\n\n\n\n

<\/div>\n\n\n\n
\n
\n

<\/i>When specifying as \"A1\u201d<\/strong><\/p>\n\n\n\n

This is an input example for specifying the start point.<\/p>\n\n\n\n

Up to the last row of adjacent cell is automatically recognized as a range.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
\n
\n

<\/i>When specifying as \"A1:C\"<\/strong><\/strong><\/p>\n\n\n\n

This is an input example for specifying both of start and end points.<\/p>\n\n\n\n

As the end point is specified as \u201cC\u201d, up to the last row of column C of adjacent cell is automatically recognized as a range.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
\n
\n

<\/i>When specifying as \"A1: D4\u201d<\/strong><\/strong><\/p>\n\n\n\n

This is an input example for specifying both of start and end points explicitly.<\/p>\n\n\n\n

A2 to D4 is recognized as a range.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n

Example when applying blank cells<\/strong><\/h3>\n\n\n\n
<\/div>\n\n\n\n

Here explains how to recognize the range based on data when there are blank cells in the range specification.<\/p>\n\n\n\n

<\/div>\n\n\n\n
\n
\n

<\/i>When specifying as \"A1:I\u201d<\/strong><\/p>\n\n\n\n

Column E is blank, but is included in the range of cells to be displayed.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
\n
\n

<\/i>When specifying as \"A1\u201d<\/strong><\/p>\n\n\n\n

The 7th row is blank, but is included in the range of cells to be displayed.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
\n
\n

If the data are lined up horizontally, column E is out of range even if you specify \"A1\" in the same way.<\/p>\n<\/div>\n\n\n\n

\n
\"\"<\/figure>\n<\/div>\n<\/div>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

  Home > User guide > BOT > How to use the BOT editor > Extention > Excel (xlsx) > About a targeted table position or range This page explains \"targeted table position or range\" using an example for Excel files. Targeted table position or range This is an example of specifying a range. When specifying as \"A1\u201d This is an input example for specifying the start point. Up to the last row of adjacent cell is automatically recognized as a range. When specifying as \"A1:C\" This is an input example for specifying both of start and end points. As the end point is specified as \u201cC\u201d, up to the last row of column C of adjacent cell is automatically recognized as a range. When specifying as \"A1: D4\u201d This is an input example for specifying both of start and end points explicitly. A2 to D4 is recognized as a range. Example when applying blank cells Here explains how to recognize the range based on data when there are blank cells in the range specification. When specifying as \"A1:I\u201d Column E is blank, but is included in the range of cells to be displayed. When specifying as \"A1\u201d The 7th […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_locale":"en_US","_original_post":"https:\/\/docs.c-bot.pro\/?p=13120","footnotes":""},"categories":[37],"tags":[45,44],"class_list":["post-13422","post","type-post","status-publish","format-standard","hentry","category-extension","tag-excelxls","tag-excelxlsx","en-US"],"_links":{"self":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/13422","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/comments?post=13422"}],"version-history":[{"count":5,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/13422\/revisions"}],"predecessor-version":[{"id":17814,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/13422\/revisions\/17814"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=13422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=13422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=13422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}