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

2014-08-23 Thread Ed Joz
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

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

2014-08-23 Thread Mark Lawrence
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

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

2014-08-23 Thread Denis McMahon
On Sat, 23 Aug 2014 11:56:29 -0700, Ed Joz wrote: Please suggest a sample python code. while program result not correct: fix program Note - we are not here to write your code for you, but we will try and help you develop your own code to do what you want. -- Denis McMahon,