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


Groups > comp.lang.python > #95416

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

From Nobody <nobody@nowhere.invalid>
Newsgroups comp.lang.python
Subject Re: -2146826246 in win32com.client for empty #N/A cell in Excel
Date 2015-08-16 22:37 +0100
Organization A noiseless patient Spider
Message-ID <pan.2015.08.16.21.37.51.335000@nowhere.invalid> (permalink)
References <29fb0de6-2d4a-4392-9c85-8f1633ad5454@googlegroups.com>

Show all headers | View raw


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/

Back to comp.lang.python | Previous | NextPrevious in thread | Next 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