{"id":13398,"date":"2022-10-03T09:46:13","date_gmt":"2022-10-03T00:46:13","guid":{"rendered":"https:\/\/docs.c-bot.pro\/?p=13398"},"modified":"2024-11-02T18:04:21","modified_gmt":"2024-11-02T09:04:21","slug":"excel_xlsx_viewer","status":"publish","type":"post","link":"https:\/\/docs.c-bot.pro\/en\/user_guide\/bot\/b-bot_editer\/extension\/excel_xlsx\/excel_xlsx_viewer\/","title":{"rendered":"Excel(xlsx) \/ Viewer"},"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) \/ Viewer<\/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

Displays a table of data from 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:view: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 name of the selected file.<\/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 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 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

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

Specify the data starting row. Refer to this page<\/a> about 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><\/p>\n\n\n\n

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

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

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

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

Specify the data starting row to display.<\/p>\n\n\n\n

* The specified \"Data starting row\" will be the first row.
\n* The negative number indicates that the row numbers are to be counted from the end of the data.<\/small>\n<\/span><\/p>\n\n\n\n

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

Specify the number of data in the displayed row.<\/p>\n\n\n\n

* If you enter a value that exceeds the number of data to be displayed, all the data to be displayed will be displayed.<\/small><\/span><\/p>\n\n\n\n

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

If you want to limit columns to display, specify the column name. Columns are displayed in 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><\/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><\/p>\n\n\n\n

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

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

Specify the time format.<\/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

Display the data in the file as a table.<\/p>\n<\/div>\n<\/div>\n\n\n\n

[About display prosess]<\/strong><\/p>\n\n\n\n

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

In that case, the load of display processing can be reduced by doing the following.<\/p>\n\n\n\n

    \n
  • Specify the display format as \u201cRaw value\u201d.<\/li>\n\n\n\n
  • Specify the order and the range of data row to display.<\/li>\n<\/ul>\n\n\n\n

    * Display processing will result in a timeout error in 29 seconds.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Home > User guide > BOT > How to use the BOT editor > Extention> Excel(xlsx) > Excel(xlsx) \/ Viewer App overview Displays a table of data from an Excel file with a .xlsx extension. Extended Feature URL cbot-extension:\/\/cloud-bot:xlsx:view: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 name of the selected file. 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 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. Refer to this page about a data starting row. Step 3 Target table range The target table range is displayed. Number of data rows […]<\/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=11748","footnotes":""},"categories":[39],"tags":[],"class_list":["post-13398","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\/13398","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=13398"}],"version-history":[{"count":9,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/13398\/revisions"}],"predecessor-version":[{"id":31186,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/posts\/13398\/revisions\/31186"}],"wp:attachment":[{"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/media?parent=13398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/categories?post=13398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.c-bot.pro\/wp-json\/wp\/v2\/tags?post=13398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}