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: 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: References: <29fb0de6-2d4a-4392-9c85-8f1633ad5454@googlegroups.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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: 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 On Sun, Aug 16, 2015, at 14:41, Chris Angelico wrote: > On Mon, Aug 17, 2015 at 3:27 AM, Albert-Jan Roskam > 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.