Can someone help me to solve the following code: I am trying to reterive the cells which are strikethrough and not strikethrough. But the below code shows all cells are 'not strikedthrough' return FALSE. But there are certain cells which are strikethrough in the Excelsheet. For those cells i want to see the corresponding results of TRUE. import win32com.client as win32 excel = win32.gencache.EnsureDispatch('Excel.Application') wb = excel.Workbooks.Open('C:/sample.xlsx') ws = wb.Worksheets("Sheet1") for j in range (3,5): for i in range (1,10): print ws.Cells(j,i).Value, ws.Cells(j,i).Font.Strikethrough excel.Application.Quit()
Dear KB, Pywin32 is an auxiliary extension program and requires <python release for windows> which could be downloaded from www.python.org/downloads/windows/ Please try un-install pywin32 and installing <python release for windows> first. If it works well, and if you need the auxiliary functionalities of pywin32, then try re-install pywin32. (when in doubt, please note that a 32 bit program should run okay on a 64 bit system). Thank you.
i tried to install it but whenever i try, "the windows has stopped working". It works fine till it shows the installation directory and python directory. And when I press "Next", it starts giving problems. Any help?