-2146826246 in win32com.client for empty #N/A cell in Excel

Nobody nobody at nowhere.invalid
Sun Aug 16 23:37:52 CEST 2015


On Sun, 16 Aug 2015 09:53:32 -0700, Sven Boden wrote:

> Anyone knows how to handle a "#N/A" cell in Excel in the proper way?

0x800A07FA is how xlErrNA (error 2042) is marshalled. This isn't specific
to Python; you'll get the same value using e.g C# or VB.NET.

There's a fairly thorough article on this topic at:

https://xldennis.wordpress.com/2006/11/22/
https://xldennis.wordpress.com/2006/11/29/



More information about the Python-list mailing list