{"id":18059,"date":"2023-03-22T15:23:26","date_gmt":"2023-03-22T06:23:26","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=18059"},"modified":"2024-11-02T18:07:40","modified_gmt":"2024-11-02T09:07:40","slug":"excel_xlsx_edit_data","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/excel_xlsx\/excel_xlsx_edit_data\/","title":{"rendered":"Excel(xlsx) \/ Edit data"},"content":{"rendered":"\n

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

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

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

Edit data in an Excel file with a .xlsx extension.<\/p>\n\n\n\n

<\/div>\n\n\n\n
Extended Feature URL<\/td>cbot-extension:\/\/cloud-bot:xlsx:edit-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 target Excel file.<\/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><\/strong><\/p>\n\n\n\n

Select the sheet to edit.<\/p>\n\n\n\n

Targeted table position or range (optional)<\/strong><\/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 of choice. Refer to this page<\/a> about a targeted table position or range.<\/p>\n\n\n\n

* If the same header exists, they are displayed in order from left column to right.<\/small><\/span><\/p>\n\n\n\n

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

Specify the header row. Refer to\u00a0this page<\/a>\u00a0about 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

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

Specify the data starting row. Refer to\u00a0this page<\/a>\u00a0about a data starting row.<\/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

Target table range<\/strong><\/strong><\/p>\n\n\n\n

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

Number of data rows<\/strong><\/strong><\/p>\n\n\n\n

The number of data rows in the target table range is displayed.<\/p>\n\n\n\n

Data row to start editing<\/strong><\/strong><\/p>\n\n\n\n

Specify the starting row of the data range to be edited.<\/p>\n\n\n\n

*The specified \"Data starting row\" will be the first row.<\/small><\/span><\/p>\n\n\n\n

*If a negative value is specified, it indicates the number of rows from the last line of the existing data rows. (e.g., if \"-2\" is specified, the second row from the last row is the starting line to be edited.<\/small><\/span><\/p>\n\n\n\n

Number of data rows to editing<\/strong><\/strong><\/p>\n\n\n\n

Specify the number of rows to be edited from the number of rows specified in \"Data Rows to Start Editing.<\/p>\n\n\n\n

*If you specify a range that exceeds the range in which data exists, rows with no data are excluded from the data range to be edited.\n<\/small><\/span><\/p>\n\n\n\n

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

If you want to limit the column to display, specify the column name. Columns are displayed in the order in which the names are specified, from left column to right. 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.
* If not specified, all columns are displayed.<\/small><\/span><\/p>\n\n\n\n

Display format<\/strong><\/strong><\/p>\n\n\n\n

Specify the display format of numbers and formulas from \"formatted value\" or \"raw value\". Refer to this page<\/a> about raw value.<\/p>\n\n\n\n

Date format<\/strong><\/strong><\/p>\n\n\n\n

Specify the date format.<\/p>\n\n\n\n

Time format<\/strong><\/strong><\/p>\n\n\n\n

Specify the time format.<\/p>\n<\/div>\n<\/div>\n\n\n\n

Step 4<\/h4>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\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.\n<\/small><\/span><\/p>\n<\/div>\n<\/div>\n\n\n\n

[ Display Processing]<\/strong><\/p>\n\n\n\n

For a file with a large amount of data, an error may occur due to timeout (*) of display processing.<\/p>\n\n\n\n

The following methods will reduce the load on the display process.<\/p>\n\n\n\n

    \n
  • Specify \"raw value\" as a display format.<\/li>\n\n\n\n
  • Specify column order and range of number of rows of data to be displayed<\/li>\n<\/ul>\n\n\n\n

    * Display processing will result in a timeout error in 29 seconds.<\/p>\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<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

      Home > User guide > BOT > How to use the BOT editor > Extention> Excel(xlsx) > Excel(xlsx) \/ Edit data App overview Edit data in an Excel file with a .xlsx extension. Extended Feature URL cbot-extension:\/\/cloud-bot:xlsx:edit-data:2 Provider Cloud BOT official External communication None Version 2 Screen description Input screen Step 1 Excel file Select the target Excel file. Step 2 Sheet name Select the sheet to edit. 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 of choice. Refer to this page about a targeted table position or range. * If the same header exists, they are displayed in order from left column to right. Header row Specify the header row. Refer to\u00a0this page\u00a0about 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. Refer to\u00a0this page\u00a0about a data starting row. Step 3 Target table range The target table range is displayed. Number of data rows The number of data rows in the target table range is displayed. Data row to start […]<\/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=18026","footnotes":""},"categories":[39],"tags":[],"class_list":["post-18059","post","type-post","status-publish","format-standard","hentry","category-excel_xlsx","en-US"],"_links":{"self":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/18059","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=18059"}],"version-history":[{"count":10,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/18059\/revisions"}],"predecessor-version":[{"id":31190,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/18059\/revisions\/31190"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=18059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=18059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=18059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}