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

2015-08-16 Thread Sven Boden
Anyone know how to handle "#N/A" in Excel from win32com.client. I'm extracting data from an Excel file using win32com.client. Everything works fine except for when the value "#N/A" is entered in excel. An empty cell. I assumed I do something as if ws.Cells(r, c).Value is None: ... But th

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

2015-08-17 Thread Sven Boden
On Sun, Aug 16, 2015 at 7:27 PM, Albert-Jan Roskam 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 Excel fr