I think there is no ‘native’ solution for this. You might use R’s openxlsx to achieve that. Also there are Python libraries that would do the same.
edit: I notices that the R package somtimes removes more information from the Excel file than it should. So please handle with care. I will post an update if I could fix that.
kn_example_r_excel_remove_sheet.knwf (24.7 KB)