{"id":13356,"date":"2022-10-03T09:46:24","date_gmt":"2022-10-03T00:46:24","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=13356"},"modified":"2024-11-02T18:05:16","modified_gmt":"2024-11-02T09:05:16","slug":"excel_xlsx_create","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/excel_xlsx\/excel_xlsx_create\/","title":{"rendered":"Excel(xlsx) \/ Create new"},"content":{"rendered":"\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) \/ Create new<\/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>Create 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:create:1<\/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>1<\/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=\"752\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2022\/12\/EN_xlsx_create_new_01-1024x752-1.jpg\" alt=\"\" class=\"wp-image-16397\"\/><\/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.<\/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 row to start writing. 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 data starting 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 columns in the file to create.<\/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 rows in the file to create.<\/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=\"631\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2022\/12\/EN_xlsx_create_new_02-1024x631-1.jpg\" alt=\"\" class=\"wp-image-16398\"\/><\/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\n\n\n<p class=\"extension_guide_body\"><span style=\"color:#ff0000\" class=\"tadv-color\"><small>[Note]<br>\nIf the header row is left blank in Step 1, Alphabets are assigned to each column name and you cannot enter these column names in Step 2.<\/small><\/span><\/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=\"885\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2022\/12\/EN_xlsx_create_new_03-1024x885-1.jpg\" alt=\"\" class=\"wp-image-16399\"\/><\/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 to add. 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.\n<\/small><\/span><\/p>\n\n\n\n<p><strong>File name<\/strong><\/p>\n\n\n\n<p class=\"extension_guide_body\">Enter any file name.<\/p>\n\n\n\n<p><strong>Sheet name<\/strong><\/p>\n\n\n\n<p class=\"extension_guide_body\">Enter any name.<\/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=\"257\" src=\"https:\/\/docs.c-bot.pro\/wp-content\/uploads\/2022\/12\/EN_xlsx_create_new_04-1024x257-1.jpg\" alt=\"\" class=\"wp-image-16400\"\/><\/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) \/ Create new App overview Create an Excel file with a .xlsx extension. Extended Feature URL cbot-extension:\/\/cloud-bot:xlsx:create:1 Provider Cloud BOT official External communication None Version 1 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. Data starting row Specify the row to start writing. Refer to this page about a data starting row. Number of columns Specify the number of columns in the file to create. Number of rows Specify the number of rows in the file to create. Step 2 Column name Enter the column name. You can increase or decrease columns by pressing the Add \/ Delete buttons. [Note] If the header row is left blank in Step 1, Alphabets are assigned to each column name and you cannot enter these column names in Step 2. Step 3 Data Input data to add. You can increase or decrease data rows by pressing the Add \/ Delete buttons. * [&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=11773","footnotes":""},"categories":[39],"tags":[44],"class_list":["post-13356","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\/13356","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=13356"}],"version-history":[{"count":10,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/13356\/revisions"}],"predecessor-version":[{"id":31187,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/13356\/revisions\/31187"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=13356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=13356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=13356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}