Remove column from excel

Removes a column from an excel file.

Excel to Datatable designer

Properties#

Excel to Datatable properties

Input#

  1. Column index The index of the column tp be removed.
  2. File Path Path to xls/xlsx file.
  3. 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.

General Properties#

See General Properties.

Misc#

See Misc.

Out Error#

See Out Error.

Result#

See Designer Properties above.

Xls(x) configuration#

  1. Sheet Number The sheet number to read. If left empty, it will read all the sheets.

Example#

Amazon read reviews with confirmation

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.