{"id":13388,"date":"2022-10-03T09:46:20","date_gmt":"2022-10-03T00:46:20","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=13388"},"modified":"2024-11-02T18:06:45","modified_gmt":"2024-11-02T09:06:45","slug":"excel_xlsx_add_data","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/excel_xlsx\/excel_xlsx_add_data\/","title":{"rendered":"Excel(xlsx) \/ Add data row"},"content":{"rendered":"\n
<\/div>\n\n\n\n

<\/i>   Home<\/a> > User guide<\/a> > BOT<\/a> > How to use the BOT editor<\/a> > Extention<\/a>> Excel(xlsx)<\/a> > Excel(xlsx) \/ Add data row<\/p>\n\n\n\n

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

App overview<\/h2>\n\n\n\n

Add a new data row to the Excel (xlsx) file.<\/p>\n\n\n\n

<\/div>\n\n\n\n
Extended Feature URL<\/td>cbot-extension:\/\/cloud-bot:xlsx:add-data:2<\/td><\/tr>
Provider<\/td>Cloud BOT official<\/span><\/td><\/tr>
External communication<\/td>None<\/td><\/tr>
Version<\/td>2<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Screen Description<\/h2>\n\n\n\n

Input Screen<\/h3>\n\n\n\n

Step 1<\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Excel file<\/strong><\/p>\n\n\n\n

Select the excel file to add a data row to.<\/p>\n<\/div>\n<\/div>\n\n\n\n

Step 2<\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Sheet name<\/strong><\/p>\n\n\n\n

Select the sheet to add a data row to.<\/p>\n\n\n\n

Targeted table position or range (optional)<\/strong><\/p>\n\n\n\n

This option allows you to specify a range of cells to target. If not specified, the target is the entire sheet selected as [Sheet Name]<\/strong>. Refer to this page<\/a> about a targeted table position or range.<\/p>\n\n\n\n

Header row<\/strong><\/p>\n\n\n\n

Specify the header row. Refer to this page<\/a> about a header row.<\/p>\n\n\n\n

* Leave blank if the header row is not necessary. An alphabet is assigned automatically for a column name.<\/small><\/span><\/p>\n\n\n\n

Number of rows to add<\/strong><\/p>\n\n\n\n

Specify a number of rows added to the file.<\/p>\n\n\n\n

Specify column order (Optional)<\/strong><\/p>\n\n\n\n

If you want to limit rows to input, specify the column name. The column with no data become blank. You can increase or decrease columns to be displayed by pressing the Add \/ Delete buttons.<\/p>\n\n\n\n

* If multiple columns have the same name, they are displayed in order from left column to right.
\n* If not specified, all columns are displayed.<\/small><\/span><\/p>\n<\/div>\n<\/div>\n\n\n\n

Step 3<\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

The target table range<\/strong><\/p>\n\n\n\n

The target table range is displayed.<\/p>\n\n\n\n

Data<\/strong><\/p>\n\n\n\n

Input data to add. You can increase or decrease data rows by pressing the Add \/ Delete buttons.<\/p>\n\n\n\n

* [Link elements and rows] function is useful to paste group data.<\/small><\/span><\/p>\n<\/div>\n<\/div>\n\n\n\n

Result Screen<\/h3>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n

Press the Download button to download the file.<\/p>\n\n\n\n

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

The number of succeeded added data rows<\/strong><\/p>\n\n\n\n

The number of successfully added data rows is displayed.<\/p>\n\n\n\n

The number of failed added data rows<\/strong><\/p>\n\n\n\n

The number of data rows which were failed to add is displayed. Refer to this page<\/a> for example of failing to add.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

  Home > User guide > BOT > How to use the BOT editor > Extention> Excel(xlsx) > Excel(xlsx) \/ Add data row App overview Add a new data row to the Excel (xlsx) file. Extended Feature URL cbot-extension:\/\/cloud-bot:xlsx:add-data:2 Provider Cloud BOT official External communication None Version 2 Screen Description Input Screen Step 1 Excel file Select the excel file to add a data row to. Step 2 Sheet name Select the sheet to add a data row to. Targeted table position or range (optional) This option allows you to specify a range of cells to target. If not specified, the target is the entire sheet selected as [Sheet Name]. Refer to this page about a targeted table position or range. Header row Specify the header row. Refer to this page about a header row. * Leave blank if the header row is not necessary. An alphabet is assigned automatically for a column name. Number of rows to add Specify a number of rows added to the file. Specify column order (Optional) If you want to limit rows to input, specify the column name. The column with no data become blank. You can increase or decrease columns to be displayed […]<\/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=11852","footnotes":""},"categories":[39],"tags":[44],"class_list":["post-13388","post","type-post","status-publish","format-standard","hentry","category-excel_xlsx","tag-excelxlsx","en-US"],"_links":{"self":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/13388","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=13388"}],"version-history":[{"count":10,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/13388\/revisions"}],"predecessor-version":[{"id":31189,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/13388\/revisions\/31189"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=13388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=13388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=13388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}