c# - writing long text in excel workbook using interop throws error? -


The COM error Exception from HRESULT: 0x800A03EC 

  throws the set_Value (type. Masing, data) in the statement given below;

If I paste the same XML manually into Excel then it works fine, but it does not work proactively. If I read the text as 100/300 then it works fine.

There is a limit if I remember correctly, some letters between 800 and 900) Walking around like this is almost impossible.

Try using an object linking connection and inserting data with SQL command. This can work better for you if you are required, you can use the interop for any formatting.


Comments

Post a Comment