On Sun, Aug 16, 2015 at 7:27 PM, Albert-Jan Roskam sjeik_ap...@hotmail.com
wrote:
Date: Sun, 16 Aug 2015 09:53:32 -0700
Subject: -2146826246 in win32com.client for empty #N/A cell in Excel
From: sven.bo...@gmail.com
To: python-list@python.org
Anyone know how to handle #N/A in
Date: Sun, 16 Aug 2015 09:53:32 -0700
Subject: -2146826246 in win32com.client for empty #N/A cell in Excel
From: sven.bo...@gmail.com
To: python-list@python.org
Anyone know how to handle #N/A in Excel from win32com.client.
I'm extracting data from an Excel file using win32com.client.
For what it's worth, I use xlrd for this. http://www.python-excel.org/
Laura
--
https://mail.python.org/mailman/listinfo/python-list
On Mon, Aug 17, 2015 at 3:27 AM, Albert-Jan Roskam
sjeik_ap...@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?
Sven, you might do better to ask on a dedicated
On Sun, Aug 16, 2015, at 14:41, Chris Angelico wrote:
On Mon, Aug 17, 2015 at 3:27 AM, Albert-Jan Roskam
sjeik_ap...@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
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