Excel delete column question

Help Studio
, ,
1

Hi,
I am opening an Excel file and deleting a column. Sometimes I am getting “Excel not installed” error. So if I switch to workbook activities to avoid this error, how can I accomplish the same?

Thank you,

2

@A_Learner,

Unfortunately there is no activity in Workbook activities to delete a column. If even after Excel being available on the system you are getting the error “Excel not installed”, try finding the root cause.

If you want this accomplished with Workbook activities, you can use this approach:

  1. Read Range
  2. Delete the column from Datatable
  3. Write the modified Datatable back in the file
3
  1. Read Range
  2. Delete the column from Datatable
  3. Write the modified Datatable back in the file
    Do not require Excel to be installed.
    Compatible with all systems, including those without Excel.
1 Like
4

Excel is installed and I cannot find the root cause.

Than you.

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.