how to use append activity for consolidating multiple excel files into one excel file??
Basically it is the same as write range, with the exceltion that the data from the DT is appended at the bottom of the existing data, instead of overwriting the existing data.
- Set an excel application scope which you want to append to
- Make sure the datatable you want to append has the same headers as the excel headers.
- use append range with your datatable to the desired sheet.
- Save if not saving automatically.
how to insert excel files data one by one in sql and show status side by side
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.