{"id":18064,"date":"2023-03-22T15:31:07","date_gmt":"2023-03-22T06:31:07","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=18064"},"modified":"2024-11-02T18:13:26","modified_gmt":"2024-11-02T09:13:26","slug":"csv_edit_data","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/csv\/csv_edit_data\/","title":{"rendered":"CSV \/ Edit data"},"content":{"rendered":"\n

<\/i>   Home<\/a> > User guide<\/a> > BOT<\/a> > How to use the BOT editor<\/a> > Extention<\/a>> CSV<\/a> > CSV \/ 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 a CSV file.<\/p>\n\n\n\n

<\/div>\n\n\n\n
Extended Feature URL<\/td>cbot-extension:\/\/cloud-bot:csv:edit-data:2<\/td><\/tr>
Provider<\/td>Cloud BOT\nofficial<\/span>\n<\/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

CSV File<\/strong><\/p>\n\n\n\n

Select the target CSV file.<\/p>\n\n\n\n

Character code<\/strong><\/strong><\/p>\n\n\n\n

Select the character code of the CSV file.<\/p>\n\n\n\n

* It is identified automatically at default.<\/small><\/span><\/p>\n\n\n\n

Header row<\/strong><\/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.\n<\/small><\/span><\/p>\n\n\n\n

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

Specifies the starting row of data to be displayed. Click here<\/a> for more information on the data start row.<\/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

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

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

Specifies the starting line of the data range to be edited.<\/p>\n\n\n\n

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

*Specify the line specified in \"Data start line\" as the first line.<\/small><\/span><\/p>\n\n\n\n

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

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

Specifies 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 where data exists, rows with no data will be excluded from the data range to be edited.\n<\/small><\/span><\/p>\n\n\n\n

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

If you want to limit the columns to be displayed, specify the column name. Columns are displayed from the left in the order in which the column names are specified.<\/p>\n\n\n\n

You can increase or decrease data columns by pressing the Add \/ Delete buttons.<\/p>\n\n\n\n

* If the same column name exists, it will be displayed in order from the left column.<\/small><\/span><\/p>\n\n\n\n

* If not specified, all columns will be 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

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

<\/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<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

  Home > User guide > BOT > How to use the BOT editor > Extention> CSV > CSV \/ Edit data App overview Edit data in a CSV file. Extended Feature URL cbot-extension:\/\/cloud-bot:csv:edit-data:2 Provider Cloud BOT official External communication None Version 2 Screen description Input screen Step 1 CSV File Select the target CSV file. Character code Select the character code of the CSV file. * It is identified automatically at default. 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 start row Specifies the starting row of data to be displayed. Click here for more information on the data start row. Step 2 Number of Data rows Display the number of data rows in the target table range. Specifies the starting line of the data range to be edited. Data row to start editing *Specify the line specified in \"Data start line\" as the first line. *If a negative value is specified, it indicates the number of lines from the last line of the existing data lines. (e.g., if \"-2\" is specified, the second line […]<\/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=18008","footnotes":""},"categories":[38],"tags":[47,57],"class_list":["post-18064","post","type-post","status-publish","format-standard","hentry","category-csv","tag-csv","tag-57","en-US"],"_links":{"self":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/18064","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=18064"}],"version-history":[{"count":10,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/18064\/revisions"}],"predecessor-version":[{"id":31198,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/18064\/revisions\/31198"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=18064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=18064"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=18064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}