EXCEL - Several have tried to help but nothing has worked, this is for StudioX

Hello, I am trying to perform multiple actions on an Excel, but it’s not working for me. Here is what I’m trying to do:

  • Delete unwanted columns
  • Keep only 2 columns
  • Filter 1 of those 2 columns that I kept

Several folks have tried to help but nothing has worked, this is for StudioX

Hi @jennifer.x.mora

Can you share the screenshot of the workflow where the error is popping out. and share an sample excel for reference too.

Regards,

Sure, here is the screenshot, the error is popping up at the “Read Range” activity

and here’s the dummy file, the highlighted columns are the ones i want to keep, all other columns i want to delete

dummy file.xlsx (11.6 KB)

Hi @jennifer.x.mora

I have attached the Zip file of the workflow process. Please check into the process.
Excel Task.zip (271.1 KB)

Hope it helps!!

Regards,

Hi @jennifer.x.mora

Can you try this-

  1. Drag and drop the “Excel file” card onto your StudioX workflow and select the Excel file you want to work with.
    Add the “Delete columns” action card.
    a. Specify the Excel file you want to modify.
    b. Select the columns you want to delete by clicking on the column headers or by specifying column names.
  2. Add the “Keep columns” action card.
    a. Specify the Excel file you want to modify.
    b. Select the columns you want to keep by clicking on the column headers or by specifying column names.
    c. Enable the “Keep only selected columns” option.
  3. Add the “Filter table” action card.
    a. Specify the Excel file you want to modify.
    b. Select the column you want to filter by clicking on the column header or by specifying the column name.
    c. Specify the filter criteria, such as text, numbers, or dates, to filter the column.
    d. Configure any additional filter options as needed.

Thanks!!

1 Like

Ty so much for replying, someone else has assisted with the issue, ty though! :slight_smile: :blush:

Hi @jennifer.x.mora ,

If the issue is resolved , Could you please close the thread/topic.

Happy automating.!

Cheers,
Gautham.