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

Mark Lawrence breamoreboy at yahoo.co.uk
Sat Aug 23 15:15:57 EDT 2014


On 23/08/2014 19:56, Ed Joz wrote:
> 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.
>

Start here http://www.python-excel.org/

-- 
My fellow Pythonistas, ask not what our language can do for you, ask
what you can do for our language.

Mark Lawrence




More information about the Python-list mailing list