Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #76890

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

Show all headers | View raw

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

Back to comp.lang.python | Previous | Next — Previous in thread | 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