Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #95417

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

Show all headers | View raw

On Sun, Aug 16, 2015, at 14:41, Chris Angelico wrote:
> On Mon, Aug 17, 2015 at 3:27 AM, Albert-Jan Roskam
> <sjeik_appie@hotmail.com> wrote:
> > Does that number happen to be -1 * sys.maxint?
> 
> No, it's -1 * 0x7ff5f806. As a signed 32-bit integer, it's 0x800a07fa.
> Does either of those numbers mean anything?

That's a COM error code, for Excel error 2042, which (unsurprisingly)
means N/A.

http://stackoverflow.com/questions/7526640/any-ideas-why-excel-interop-reads-many-decimals-as-2146826246

Here's some information from someone having the same problem in .NET,
which may or may not be helpful

https://xldennis.wordpress.com/2006/11/22/dealing-with-cverr-values-in-net-%E2%80%93-part-i-the-problem/

It looks like the values are actually returned as a VT_ERROR variant,
which .NET (and apparently python) reads as an integer.

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

-2146826246 in win32com.client for empty #N/A cell in Excel Sven Boden <sven.boden@gmail.com> - 2015-08-16 09:53 -0700
  Re: -2146826246 in win32com.client for empty #N/A cell in Excel Chris Angelico <rosuav@gmail.com> - 2015-08-17 04:41 +1000
  Re: -2146826246 in win32com.client for empty #N/A cell in Excel Laura Creighton <lac@openend.se> - 2015-08-16 21:49 +0200
  Re: -2146826246 in win32com.client for empty #N/A cell in Excel Nobody <nobody@nowhere.invalid> - 2015-08-16 22:37 +0100
  Re: -2146826246 in win32com.client for empty #N/A cell in Excel random832@fastmail.us - 2015-08-16 17:39 -0400

csiph-web