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

Newsgroups	comp.lang.python
Date	2014-08-23 11:56 -0700
Message-ID	<37b3f703-a781-489f-b086-26b9c80df282@googlegroups.com> (permalink)
Subject	Python code to distinguish between data having, 2 different formats, in a given cell(MS Excel).
From	Ed Joz <edjoz1010@gmail.com>

Show all headers | View raw

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.

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Python code to distinguish between data having, 2 different formats, in a given cell(MS Excel). Ed Joz <edjoz1010@gmail.com> - 2014-08-23 11:56 -0700
  Re: Python code to distinguish between data having, 2 different formats, in a given cell(MS Excel). Mark Lawrence <breamoreboy@yahoo.co.uk> - 2014-08-23 20:15 +0100
  Re: Python code to distinguish between data having, 2 different formats, in a given cell(MS Excel). Denis McMahon <denismfmcmahon@gmail.com> - 2014-08-23 20:11 +0000

csiph-web