Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #76887 > unrolled thread
| Started by | Ed Joz <edjoz1010@gmail.com> |
|---|---|
| First post | 2014-08-23 11:56 -0700 |
| Last post | 2014-08-23 20:11 +0000 |
| Articles | 3 — 3 participants |
Back to article view | Back to comp.lang.python
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
| From | Ed Joz <edjoz1010@gmail.com> |
|---|---|
| Date | 2014-08-23 11:56 -0700 |
| Subject | Python code to distinguish between data having, 2 different formats, in a given cell(MS Excel). |
| Message-ID | <37b3f703-a781-489f-b086-26b9c80df282@googlegroups.com> |
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.
[toc] | [next] | [standalone]
| From | Mark Lawrence <breamoreboy@yahoo.co.uk> |
|---|---|
| Date | 2014-08-23 20:15 +0100 |
| Message-ID | <mailman.13348.1408821375.18130.python-list@python.org> |
| In reply to | #76887 |
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
[toc] | [prev] | [next] | [standalone]
| From | Denis McMahon <denismfmcmahon@gmail.com> |
|---|---|
| Date | 2014-08-23 20:11 +0000 |
| Message-ID | <ltasi0$t36$1@dont-email.me> |
| In reply to | #76887 |
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, denismfmcmahon@gmail.com
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.python
csiph-web