{"id":13392,"date":"2022-10-03T09:46:16","date_gmt":"2022-10-03T00:46:16","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=13392"},"modified":"2024-11-02T18:05:52","modified_gmt":"2024-11-02T09:05:52","slug":"excel_xlsx_add_sheet","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/excel_xlsx\/excel_xlsx_add_sheet\/","title":{"rendered":"Excel(xlsx) \/ Add sheet"},"content":{"rendered":"\n<div style=\"height:5px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/docs.c-bot.pro\/en\/\"><i class=\"fas fa-book\"> <\/i> &nbsp; Home<\/a> &gt; <a href=\"https:\/\/docs.c-bot.pro\/en\/user_guide\">User guide<\/a> &gt; <a href=\"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/\">BOT<\/a> &gt; <a href=\"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/\">How to use the BOT editor<\/a> &gt; <a href=\"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\">Extention<\/a>&gt; <a href=\"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/excel_xlsx\">Excel(xlsx)<\/a> &gt; Excel(xlsx) \/ Add sheet<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large is-resized extension_icon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2022\/08\/icon-s_96p_excel.png\" alt=\"\" class=\"wp-image-10680\" width=\"75\" height=\"75\"\/><\/figure>\n\n\n\n<h2 id=\"outline__1\" class=\"wp-block-heading\">App overview<\/h2>\n\n\n\n<p>Add a new sheet to an Excel file with a .xlsx extension.<\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Extended Feature URL<\/td><td>cbot-extension:\/\/cloud-bot:xlsx:add-sheet:2<\/td><\/tr><tr><td>Provider<\/td><td>Cloud BOT <span style=\"margin-left: 2px ; padding: 2px 7px; border:0px solid #000 ; background-color: #007bff ; border-radius: 5px ; color: #ffffff ; font-size: 0.7em;\" class=\"badge\">official<\/span><\/td><\/tr><tr><td>External communication<\/td><td>None<\/td><\/tr><tr><td>Version<\/td><td>2<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 id=\"outline__2\" class=\"wp-block-heading\">Screen description<\/h2>\n\n\n\n<h3 id=\"outline__2_1\" class=\"wp-block-heading\">Input Screen<\/h3>\n\n\n\n<h4 id=\"outline__2_1_1\" class=\"wp-block-heading\">Step 1<\/h4>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"760\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2024\/07\/img_xlsx_addsheet_edit_en-1024x760.png\" alt=\"\" class=\"wp-image-30241\"\/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Table starting position<\/strong><\/p>\n\n\n\n<p class=\"extension_guide_body\">Specify the table starting row to display.<\/p>\n\n\n\n<p><strong>Header row<\/strong><\/p>\n\n\n\n<p class=\"extension_detail_item_body\">Specify the header row. Refer to <a href=\"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/about_input_fields\/#outline__1\" data-type=\"URL\" data-id=\"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/header\/\">this page<\/a> about a header row.<\/p>\n\n\n\n<p class=\"extension_guide_body\"><span style=\"color:#0693e3\" class=\"tadv-color\"><small>* 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<p><strong>Data starting row<\/strong><\/p>\n\n\n\n<p class=\"extension_guide_body\">Specify the data starting row to display. Refer to <a href=\"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/about_input_fields\/#outline__2\" data-type=\"URL\" data-id=\"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/start_row\/\">this page<\/a> about a header row.<\/p>\n\n\n\n<p><strong>Number of columns<\/strong><\/p>\n\n\n\n<p class=\"extension_guide_body\">Specify the number of data columns to write.<\/p>\n\n\n\n<p><strong>Number of rows<\/strong><\/p>\n\n\n\n<p class=\"extension_guide_body\">Specify the number of data rows to write.<\/p>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 id=\"outline__2_1_2\" class=\"wp-block-heading\">Step 2<\/h4>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"614\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2024\/07\/img_xlsx_addsheet_input_1_en-1024x614.png\" alt=\"\" class=\"wp-image-30242\"\/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Column name<\/strong><\/p>\n\n\n\n<p class=\"extension_detail_item_body\">Enter the column name.<\/p>\n\n\n\n<p class=\"extension_detail_item_body\">You can increase or decrease columns by pressing the Add \/ Delete buttons.<\/p>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 id=\"outline__2_1_3\" class=\"wp-block-heading\">Step 3<\/h4>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"891\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2024\/07\/img_xlsx_addsheet_input_2_en-1024x891.png\" alt=\"\" class=\"wp-image-30243\"\/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Data<\/strong><\/p>\n\n\n\n<p class=\"extension_detail_item_body\">Input data. You can increase or decrease data rows by pressing the Add \/ Delete buttons.<\/p>\n\n\n\n<p class=\"extension_guide_body\"><span style=\"color:#0693e3\" class=\"tadv-color\"><small>* [Link elements and rows] function is useful to paste group data.<\/small><\/span><\/p>\n\n\n\n<p><strong>Excel file<\/strong><\/p>\n\n\n\n<p class=\"extension_guide_body\">Select the Excel file to add a sheet to.<\/p>\n\n\n\n<p><strong>Sheet name<\/strong><\/p>\n\n\n\n<p class=\"extension_guide_body\">Enter any name (option).<\/p>\n<\/div>\n<\/div>\n\n\n\n<h3 id=\"outline__2_2\" class=\"wp-block-heading\">Result Screen<\/h3>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"176\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2024\/07\/img_xlsx_addsheet_download_en-1024x176.png\" alt=\"\" class=\"wp-image-30244\"\/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"extension_guide_body\">Press the Download button to download the file.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Home &gt; User guide &gt; BOT &gt; How to use the BOT editor &gt; Extention&gt; Excel(xlsx) &gt; Excel(xlsx) \/ Add sheet App overview Add a new sheet to an Excel file with a .xlsx extension. Extended Feature URL cbot-extension:\/\/cloud-bot:xlsx:add-sheet:2 Provider Cloud BOT official External communication None Version 2 Screen description Input Screen Step 1 Table starting position Specify the table starting row to display. 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. Data starting row Specify the data starting row to display. Refer to this page about a header row. Number of columns Specify the number of data columns to write. Number of rows Specify the number of data rows to write. Step 2 Column name Enter the column name. You can increase or decrease columns by pressing the Add \/ Delete buttons. Step 3 Data Input data. You can increase or decrease data rows by pressing the Add \/ Delete buttons. * [Link elements and rows] function is useful to paste group data. Excel file Select the Excel file to add a sheet [&hellip;]<\/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=11816","footnotes":""},"categories":[39],"tags":[44],"class_list":["post-13392","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\/13392","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=13392"}],"version-history":[{"count":10,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/13392\/revisions"}],"predecessor-version":[{"id":31188,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/13392\/revisions\/31188"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=13392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=13392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=13392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}