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()
This is probably a temporary issue, I have installed this with ARCGIS 10.2 and run it with some ARC training data. The training script failed. The outcome was I could no longer start arcmap ( now sorted) and I still cannot open the python window and arc toolbox( dependant on python.acess ) So if you are an ARCUser take care and check before installing.
I can't download anything but the readme file, error 500 on sourceforge when browse files
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.