I was wondering if there is a function to sort a working, opened and displayed Excel file by several columns.
My usecase is following:
- Receiving excel files via email
- Save excel attachment
- Read excel content → unsorted
- Use excel content in SAP and directly add new values to excel file, like status, result values etc.
- send same excel file to recepients with added content
I would like to work only with a sorted excel file, meaning to sort the file with step 3 - sorting by at least 3 columns in one step.
Knowing the function of sort dataTable, but this only helps if I work with an internal table only.