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

Path	csiph.com!news.mixmin.net!newsreader4.netcologne.de!news.netcologne.de!bcyclone01.am1.xlned.com!bcyclone01.am1.xlned.com!newsfeed.xs4all.nl!newsfeed8.news.xs4all.nl!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<random832@fastmail.us>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.008
X-Spam-Evidence	'H': 0.98; 'S': 0.00; '16,': 0.03; 'python)': 0.05; 'integer,': 0.09; 'received:internal': 0.09; 'variant,': 0.09; '3:27': 0.16; 'integer.': 0.16; 'message- id:@webmail.messagingengine.com': 0.16; 'received:10.202': 0.16; 'received:10.202.2': 0.16; 'received:66.111': 0.16; 'received:66.111.4': 0.16; 'received:messagingengine.com': 0.16; 'wrote:': 0.16; '2015': 0.20; 'aug': 0.20; 'am,': 0.23; 'code,': 0.23; 'header:In-Reply-To:1': 0.24; 'mon,': 0.24; 'signed': 0.24; 'chris': 0.26; 'helpful': 0.27; 'error': 0.27; 'values': 0.28; 'looks': 0.29; '32-bit': 0.29; 'excel': 0.29; 'subject:/': 0.30; 'returned': 0.32; 'problem': 0.33; '(and': 0.36; 'to:addr:python- list': 0.36; 'received:10': 0.37; 'no,': 0.38; 'received:66': 0.38; 'someone': 0.38; 'mean': 0.38; 'means': 0.39; 'does': 0.39; 'to:addr:python.org': 0.40; 'some': 0.40; 'from:no real name:2**0': 0.60; 'header:Message-Id:1': 0.61; 'information': 0.63; 'url:%1': 0.67; 'url:11': 0.72; 'subject: #': 0.79; 'url:wordpress': 0.79; '.net,': 0.91
DKIM-Signature	v=1; a=rsa-sha1; c=relaxed/relaxed; d=fastmail.us; h= content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-sasl-enc :x-sasl-enc; s=mesmtp; bh=Lt5DRa910gEjDMyVTtYS1BHsheE=; b=pj/z0U bughOE+0evVaET0nJ0S/+wxxhNztx+vfR5cgD/4BpFC1NJj6COJmQCKPa6HNJapF Wyind8YB2l4xYtw+z2Pzpsc3Rb0n6FTPXPfe10Ja45Wb86fZelUOkzsrnH56SGn8 3P3GMzB/WQXkp45wd7hXX0FaaXPxfQV7xKKIg=
DKIM-Signature	v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-sasl-enc:x-sasl-enc; s=smtpout; bh=Lt5DRa910gEjDMy VTtYS1BHsheE=; b=jlXTUH/96Ev50yLRklazVPg494SM57iSFqPqkF7sopP7OeS bbONOhYPMD0xdyIJMGGBsimMhDGu1kPNKZIN0itQOYds+dkoVtU4g4DAERuj3yMB 4YrTlpQHSlC98ATKXFD/2nnG6mHsTfg8q0wI7HN6S3AYnpTNqo582bOsF9/4=
X-Sasl-Enc	mcsLGkzya9Nf/iA20ZqmzUqqbi+JQPybUbeDyuZMRHys 1439761170
From	random832@fastmail.us
To	python-list@python.org
MIME-Version	1.0
Content-Transfer-Encoding	7bit
Content-Type	text/plain
X-Mailer	MessagingEngine.com Webmail Interface - ajax-4fee8ba5
Subject	Re: -2146826246 in win32com.client for empty #N/A cell in Excel
Date	Sun, 16 Aug 2015 17:39:30 -0400
In-Reply-To	<CAPTjJmpYp3mX1a1dQTWxdDdBeBqqvayoXVRTGQAC2MwzKWcVow@mail.gmail.com>
References	<29fb0de6-2d4a-4392-9c85-8f1633ad5454@googlegroups.com> <DUB123-W150215EF62F35B4D653625837A0@phx.gbl> <CAPTjJmpYp3mX1a1dQTWxdDdBeBqqvayoXVRTGQAC2MwzKWcVow@mail.gmail.com>
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.20+
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.46.1439761174.4764.python-list@python.org> (permalink)
Lines	20
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1439761174 news.xs4all.nl 2861 [2001:888:2000:d::a6]:59031
X-Complaints-To	abuse@xs4all.nl
X-Received-Bytes	4600
X-Received-Body-CRC	2681181148
Xref	csiph.com comp.lang.python:95417

Show key headers only | 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