Removes a column from an excel file.
- Column index The index of the column tp be removed.
- File Path Path to xls/xlsx file.
- Sheet Name The name of the sheet from where to remove the column. It can be left blank if we want to load data from first sheet.
See General Properties.
See Out Error.
See Designer Properties above.
- Sheet Number The sheet number to read. If left empty, it will read all the sheets.
In this sample, we read all negative reviews for an amazon product and display confirmation dialog at the end with all the extracted reviews. We use read excel to read the csv file with extracted negative reviews.