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
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