Search: excel-get-workbook-sheets

Last modified by admin on 2022/04/24 04:58

Results 1 - 7 of 7 Page 1

Excel Remove Duplicates Range

Last modified by Giang Tran on 2022/05/13 06:24
Rendered document content
that are duplicated in a specified range. (*for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Range (String
of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check
Title
Excel Remove Duplicates Range
Location
Excel Activities
Excel Remove Duplicates Range
Raw document content
. [[image:image-20220505141832-1.png]] (*for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1
. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet in the workbook where the change must

Read Column

Last modified by VuNH54 on 2023/04/20 10:48
Rendered document content
) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell
, this is filled in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g
Location
Excel Activities
Raw document content
]] (* for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” * **Sheet name (String)*** - The sheet you want
" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName

Read Row

Last modified by Giang Tran on 2022/05/13 06:53
Rendered document content
) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell
in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C
Location
Excel Activities
Raw document content
]] (*for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” * **Sheet name (String)*** - The sheet
". E.g: "A1" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C

Excel Insert Columns Table

Last modified by VuNH54 on 2023/04/19 17:07
Rendered document content
position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you
) - Position you want to add. Sheet name (String)* - The name of the sheet in the workbook where the change
Title
Excel Insert Columns Table
Location
Excel Activities
Excel Insert Columns Table
Raw document content
-20220505141633-1.png]] (* for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table name (String
(String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table

Excel LookUp Range

Last modified by Giang Tran on 2022/05/13 06:22
Rendered document content
) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where you want to search
(String)* - The range where you want to perform the search. E.g: "A1:H5" Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Value (String) - The value that you
Title
Excel LookUp Range
Location
Excel Activities
Excel LookUp Range
Raw document content
]] (* for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet in the workbook where you want to search. E.g: "Sheet1" * **Range (String)*** - The range where you want
where you want to perform the search. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet

Excel Insert Or Delete Columns

Last modified by VuNH54 on 2023/04/19 17:08
Rendered document content
or removal begins. E.g: 2 Sheet name (String)* - The name of the sheet in the workbook where the change must
columns to the document. ・Delete: Remove columns from the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check
Title
Excel Insert Or Delete Columns
Location
Excel Activities
Excel Insert Or Delete Columns
Raw document content
**: Remove columns from the document. * **Sheet name (String)*** - The name of the sheet in the workbook
)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" == **Properties** == **Destination** * **Number

Excel Insert Or Delete Rows

Last modified by Giang Tran on 2022/05/13 06:19
Rendered document content
the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g
or removal begins. By default, this is filled in with 1. E.g: 2 Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Properties Destination Number of rows (Int32
Title
Excel Insert Or Delete Rows
Location
Excel Activities
Excel Insert Or Delete Rows
Raw document content
)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1
the document. * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made
Page 1
RSS feed for search on [excel-get-workbook-sheets]
Created by admin on 2022/04/17 14:38