検索：excel-insert-rows

[1] About Data Service (en)

Sandbox (en)

表示されるドキュメントの内容

You can create tables right into wiki pages: Table with headers in the top row table header table header table header cell cell cell cell cell cell Table with headers in the top row and left

…

create links to attachments: XWikiLogo.png Images gif You can insert images in your wiki pages

ドキュメントの内容のソース

pages: == Table with headers in the top row == |= table header |= table header |= table header | cell | cell | cell | cell | cell | cell == Table with headers in the top row and left column == |= table

…

links to attachments: attach:XWikiLogo.png = Images = gif [[image:attach:cat.gif]] You can insert

Excel Delete Range (en)

表示されるドキュメントの内容

RCA.Activities.Excel.ExcelDeleteRange Description This activity allows deleting a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property fields. (* for mandatory) Properties Input Sheet Name (String) - The name

タイトル

Excel Delete Range

保存場所

Excel Activities

…

Excel Delete Range

ドキュメントの内容のソース

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property

Excel Read Range (en)

表示されるドキュメントの内容

of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet

…

only be used in the Excel Application Scope activity. (* is mandatory) In the body of activity

…

" Range (String) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Properties Input

タイトル

Excel Read Range

保存場所

Excel Activities

…

Excel Read Range

ドキュメントの内容のソース

" %) ((( RCA.Activities.Excel.ExcelReadRange == **Description** == This activity allows you to read the value of an Excel range and store

…

as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application

…

: "Sheet1" * **Range (String)** - The range from which you want to remove duplicate rows. E.g: "A1:H5

Excel Remove Duplicates Range (en)

表示されるドキュメントの内容

RCA.Activities.Excel.ExcelRemoveDuplicatesRange Description Deletes all the rows

…

) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Properties Input Range (String) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Sheet name (String)* - The name

タイトル

Excel Remove Duplicates Range

保存場所

Excel Activities

…

Excel Remove Duplicates Range

ドキュメントの内容のソース

" %) ((( RCA.Activities.Excel.ExcelRemoveDuplicatesRange == **Description** == Deletes all the rows that are duplicated in a specified range

…

" * **Range (String)** - The range from which you want to remove duplicate rows. E.g: "A1:H5" == **Properties** == **Input** * **Range (String)** - The range from which you want to remove duplicate rows

Read Row (en)

表示されるドキュメントの内容

RCA.Activities.Excel.ReadRow Description Reads the values from a row beginning with the cell

…

) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C

…

(String)* - The cell from which to start extracting the row data. By default, this is filled in with "A1

タイトル

Read Row

保存場所

Excel Activities

ドキュメントの内容のソース

" %) ((( RCA.Activities.Excel.ReadRow == **Description** == Reads the values from a row beginning with the cell specified

…

]] (*for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel

…

extracting the row data. By default, this is filled in with "A1". E.g: "A1" == **Properties

Excel Insert Or Delete Columns (en)

表示されるドキュメントの内容

to organize and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns Options

…

) - The number of columns you wish to add or remove. E.g: 1 Position (Int32) - The column where the insertion

…

to add or remove. E.g: 1 Position (Int32) - The column where the insertion or removal begins. E.g: 2

タイトル

Excel Insert Or Delete Columns

保存場所

Excel Insert Or Delete Columns

…

Excel Activities

ドキュメントの内容のソース

and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns **Options** * **CopyOrigin

…

)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet

…

)** - The column where the insertion or removal begins. E.g: 2 **Input** * **Change Mode (Dropdown List

Excel Insert Columns Table (en)

表示されるドキュメントの内容

the name of the activity to organize and structure your code better. E.g: [028225900] Excel Insert Columns

…

want to insert. E.g: "Table1" Column name (String) - Name of column you want to insert. E.g: "Column1" Properties Input Column name (String) - Name of column you want to insert. E.g: "Column1" Position (Int32

タイトル

Excel Insert Columns Table

保存場所

Excel Insert Columns Table

…

Excel Activities

ドキュメントの内容のソース

to organize and structure your code better. E.g: [028225900] Excel Insert Columns Table ))) {{velocity

…

)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want to insert. E.g: "Column1" == **Properties** == **Input** * **Column name (String)** - Name of column you

Excel Read Row (en)

表示されるドキュメントの内容

of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable

…

can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row

…

. E.g: "Sheet1" Starting Cell - The cell from which to start extracting the row data. By default

タイトル

Excel Read Row

保存場所

Excel Activities

…

Excel Read Row

ドキュメントの内容のソース

the values of an Excel row beginning from the cell specified in the StartingCell field: and stores

…

. You can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row

…

from which to start extracting the row data. By default, this is filled in with "A1". E.g: "A1

Excel Insert Or Delete Rows (en)

表示されるドキュメントの内容

) - The number of rows you wish to add or remove. E.g: 1 Position (Int32) - The row where the insertion

…

) - The number of rows you wish to add or remove. E.g: 1 Row Position (Int32) - The row where the insertion

…

edit the name of the activity to organize and structure your code better. E.g: [038325762] Excel Insert

タイトル

Excel Insert Or Delete Rows

保存場所

Excel Insert Or Delete Rows

…

Excel Activities

ドキュメントの内容のソース

. E.g: [038325762] Excel Insert Or Delete Rows **Options** * **CopyOrigin (Dropdown List

…

)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet

…

or remove. E.g: 1 * **Row Position (Int32)** - The row where the insertion or removal begins. By default