CODEWITHSUNDEEP
c#exceloffice-interopexcel-interop
user2136168
user2136168

Reputation: 83

Excel Interop failed to write (HRESULT: 0x800A03EC)

I got an exception 0x800A03EC when I was trying to execute this command in Excel Interop

ws.get_Range("A2").Value= "=?9ABC"

It seems that interop doesn't like string that starts with "=?". I tried to solve the issue by setting Calculation mode to Manual, but unfortunately it wasn't the solution. Could anyone please tell me what I should do?

Thanks, Kam

Upvotes: 0

Views: 779

Answers (1)

Peter Albert
Peter Albert

Reputation: 17475

Excel will interpret values starting with = as formulas. Therefore, store it as '=?9ABC, as the ' tells Excel to interpret the string a text and not as formula.

Upvotes: 4

Related Questions