Problem with Append range activity

[Olivera_Kalinic (Olivera Kalinić)]

In one part of process I use Append Range activity, but simetimes after that I’m getting an error

“Append Range: Exception from HRESULT: 0x800A03EC”

Please, how can I solve it?

[Yoichi]

HI,

The following topic might help you.

Excel - How to deal with Exception from HRESULT: 0x800A03EC

A few workarounds to the common error code 0x800A03EC. Before you check it out, please make sure you are running the latest available stable Excel package from our Official feed. If you have encountered this error during your Excel processing, please make sure: you can access the file your are working on (in case of shared drives → the file is not open by another user) the file is not open already open in a non-standard editing mode (read-only, password-protected, etc) there is no conflicti…

Regards,

[Sai.Srinivas]

@Olivera_Kalinic

Please Validate These steps first

This error message may occur due to several reasons, here are a few possible solutions:

1. Check if the path to the Excel file is correct. Make sure that the path you have provided in the “Append Range” activity is correct and the file exists in that location.
2. Check if the file is open in another program. Make sure that the Excel file is not open in another program. If it is open, close it and try running the process again.
3. Check if there are any invalid characters in the sheet name. Make sure that the sheet name provided in the “Append Range” activity does not contain any invalid characters such as “?”, “*”, etc.
4. Check if the sheet name is case-sensitive. Make sure that the sheet name is spelled correctly and that it is case-sensitive.
5. Check if the format of the data is correct. Make sure that the data you are trying to append is in the correct format and that it matches the format of the existing data in the sheet.
6. Check if the data table has any null values. Make sure that the data table you are trying to append to the excel sheet doesn’t have any null values.
7. Check if the datatable has headers or not. Make sure that the datatable you are trying to append has headers or not as per the sheet.
8. Check if the sheet is protected, you will not be able to append data to a protected sheet.

Let me if problem is not fixed

Thanks & Regards
Sai Srinivas

[Jose_Miguel (José Miguel)]

Use Write Range Workbook Activity Instead of Append Range Activity.