Python code to distinguish between data having, 2 different formats, in a given cell(MS Excel).

Ed Joz edjoz1010 at gmail.com
Sat Aug 23 14:56:29 EDT 2014


I got an excel sheet having,2 blocks of data in 2 different formats, in any given cell.

Lets take cell A1 for example, 1st block has font = Arial, character size =10 2nd block has font = Times New Roman, character size = 16 OR **no data**

sample: "abcd123

PQRS456"

A python code need to be developed. It should check every cell, and print the data whose, font = Times New Roman & character size = 16 .If the cell is not having any data in that format, '0' should be printed.The data can be printed into a notepad.

Please suggest a sample python code.



More information about the Python-list mailing list