CSV operations in Excel advanced
- 版本:
- 已更新: 2022/10/10
CSV operations in Excel advanced
You can use some of the actions available in the Excel advanced package to perform various operations on a CSV file.
CSV actions in the Excel advanced package
The following table lists the actions that you can use with a CSV file:
Supported | Not Supported |
Open | Find next empty cell |
Set cell | Get cell colour |
Go to cell | Go to next empty cell |
Insert/Delete row column | Run macro |
Insert/Delete row column | Unhide all worksheets |
Get cell | Hide row/column in selection |
Find/Replace | Unhide row/column in selection |
Convert excel to pdf | Access password protected worksheet |
Delete cells | Protect/Unprotect workbook |
Set cell formula | Table related commands |
Create workbook | Create worksheet |
You can use the Loop action to retrieve data from each row in a CSV file. You can also use any of the above action that supports the use of a CSV file within a Loop action.
Note: All the other actions available in the Excel advanced
package that are not listed in the above table cannot be used with a CSV
file.