検索:excel-copy-sheet
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
- 33Activities
最終更新者
- 17Giang Tran
- 13VuNH54
- 2Nga Nguyen
- 1admin
最終更新日
- 3330日以前
作成日
- 3330日以前
アップロードした人
- 28Giang Tran
- 2VuNH54
アップロード日
- 3430日以前
Excel Copy Sheet (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Excel.ExcelCopySheet Description This activity allows you to copy a sheet from
…Destination Destination File Path (String)* - The workbook where you want to copy the sheet. If this field is left empty, the sheet is copied in the current scope workbook. This field supports only strings
- タイトル
Excel Copy Sheet
- 保存場所
Excel Copy Sheet
…Excel Activities
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelCopySheet == **Description** == This activity allows you to copy a sheet from a specified workbook
…the sheet. If this field is left empty, the sheet is copied in the current scope workbook. This field
…can edit the name of the activity to organize and structure your code better. E.g: Copy Sheet
Activities (en)
保存場所
- 表示されるドキュメントの内容
Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste Range Excel Copy Sheet Excel Delete Range Excel Get Workbook Sheet Excel Get Workbook Sheets Excel
…Save Workbook Excel Select Range Excel Select Sheet Excel Set Border Excel Set Range Color Excel
- 保存場所
Excel Activities
- ドキュメントの内容のソース
/Excel%20Close%20Workbook/]] * [[Excel Copy Paste Range>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20Copy%20Paste%20Range/]] * [[Excel Copy Sheet>>url:https
…/]] * [[Excel Get Workbook Sheet>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities
Excel Select Sheet (en)
保存場所
- 表示されるドキュメントの内容
a specified sheet, in order to perform further actions. (* for mandatory) Properties Input Sheet name (String)* - The name of the sheet from which to select the specified range. By default, this is filled
…. E.g: Select Sheet
- タイトル
Excel Select Sheet
- 保存場所
Excel Select Sheet
…Excel Activities
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelSelectSheet == **Description** == The activity allows you to select and execute a specified sheet
…) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet from which to select
…. You can edit the name of the activity to organize and structure your code better. E.g: Select Sheet
Excel Get Workbook Sheet (en)
保存場所
- 表示されるドキュメントの内容
for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope Activity. (* for mandatory) Properties Input Index (Int)* - The index of the sheet that you want
…code better. E.g: Get Workbook Sheet Output Sheet (String) - List of string that contains sheet names
- タイトル
Excel Get Workbook Sheet
- 保存場所
Excel Get Workbook Sheet
…Excel Activities
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheet == **Description** == This activity allows you to look for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope Activity. [[image:image
…)* **- The index of the sheet that you want to retrieve. This field supports only integers and Int32 variables
Excel Get Workbook Sheets (en)
保存場所
- 表示されるドキュメントの内容
for a sheet based on its index and returns its name as a String variable. This only can be used in Excel
…. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string that contains sheet names. It is written by their index order. Should assign to a variable.
- タイトル
Excel Get Workbook Sheets
- 保存場所
Excel Activities
…Excel Get Workbook Sheets
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheets == **Description** == This activity allows you to look for a sheet based on its index and returns its name as a String variable. This only can be used in Excel Application Scope Activity
…and structure your code better. E.g: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title
Excel Copy Paste Range (en)
保存場所
- 表示されるドキュメントの内容
Sheet Name (String)* - The name of the sheet where the data you want to copy located. By default
…RCA.Activities.Excel.ExcelCopyPasteRange Description This activity allows to copy a range or sheet (including values, formulas, table format, and cell format) and pastes it to another location
- タイトル
Excel Copy Paste Range
- 保存場所
Excel Copy Paste Range
…Excel Activities
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **Description** == This activity allows to copy a range or sheet (including values, formulas
…)*** - The sheet you want to paste the copied data into. This field supports only strings and String variables E.g: “TargetSheetName” **Input** * **Sheet Name (String)*** - The name of the sheet where the data you want to copy
Release Notes (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Excel Version 2.1.1.0 Bugs fixed [ExcelApplicationScope]Edit message when excel file is set password protected sheet. [ExportChart]Export chart missing when name file excel has chart
…characters. [ExcelApplicationScope] A loop opens Excel file in the background. Even though the workflow has
- ドキュメントの内容のソース
when excel file is set password protected sheet. * [ExportChart]Export chart missing when name file excel has chart name same. * [ExcelApplicationScope] At Textbox[Designer], change length when input more than 200 characters. * [ExcelApplicationScope] A loop opens Excel file in the background. Even though
[1] Release Notes (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Excel Version 2.1.1.0 Bugs fixed [ExcelApplicationScope]Edit message when excel file is set password protected sheet. [ExportChart]Export chart missing when name file excel has chart
…characters. [ExcelApplicationScope] A loop opens Excel file in the background. Even though the workflow has
- 保存場所
Excel Activities
- ドキュメントの内容のソース
when excel file is set password protected sheet. * [ExportChart]Export chart missing when name file excel has chart name same. * [ExcelApplicationScope] At Textbox[Designer], change length when input more than 200 characters. * [ExcelApplicationScope] A loop opens Excel file in the background. Even though
Append Range (en)
保存場所
- 表示されるドキュメントの内容
stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist
…of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file
…are supported. E.g: “C:\FolderName\ClientList.xlsx” Sheet Name - The name of the sheet in which to add
- 保存場所
Excel Activities
- ドキュメントの内容のソース
variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created
…) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want to use. If the Excel file to be used is located in the project folder, its relative path can be used
Excel Write Cell (en)
保存場所
- 表示されるドキュメントの内容
into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. (* is mandatory) In the body
- タイトル
Excel Write Cell
- 保存場所
Excel Activities
…Excel Write Cell
- ドキュメントの内容のソース
spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505113619-1.jpeg]] (* is mandatory