Sponsored Content
Top Forums Shell Programming and Scripting **python** unable to read the background color in python Post 302911759 by giridhar276 on Saturday 2nd of August 2014 09:28:44 PM
Old 08-02-2014
**python** unable to read the background color in python

I am working on requirement on spreadsheet in python scripting.

I have a spreadsheet containing cell values and with background color.

I am able to read the value value but unable to get the background color of that particular cell.

Actually my requirement is to read the cell value along with the background color and display the same in html table.

Here I am able to display the cell value but not with background color.

Could you please suggest the required library which suits my requiremnet with some example code.


Code:
import openpyxl
wb = openpyxl.load_workbook(filename = r'empty.xlsx')
sheet_ranges = wb['range']
print sheet_ranges['D18'].value

 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Python- Changing background color on Button click

Hi, I am trying to write a python program which changes background color on click of button. However i am stuck up. Instead of changing the color currently it is creating a new frame every time. please look at the code and let me know how to correct it #!/usr/bin/env python from Tkinter... (0 Replies)
Discussion started by: vickylife
0 Replies

2. Shell Programming and Scripting

Python Binary File Read and Parse

Hi to everyone :), i have a challenge right now in python that for now needs a bit of help in one part of the c0de. The task is create a new file with the name of the file defined by the ASCII content between the 3 byte and the 16 byte that is parsed from the binary file, the file is over 20 Mb i... (0 Replies)
Discussion started by: drd0spt
0 Replies

3. Shell Programming and Scripting

[Solved] Unable to call a python script from bash

Hi, I am trying to run a python script embedded in bash script. But is throwing me an error. Please help. Script: #!/bin/bash nohup /usr/bin/python /opt/web/http.py & Error: /usr/bin/python: can't open file '/opt/web/http.py': No such file or directory Please help me on this. (6 Replies)
Discussion started by: maddy26615
6 Replies

4. Shell Programming and Scripting

Need python script to read a file

more data.txt user1:psw1:Moni,Admi user2:psw2:Depl,Moni,Admi I wish to perform the following task on the data.txt in my python script 1. read line by line data.txt 2. Once you read the first line split it using delimiter ":" i.e "user1" "psw1" & "Moni,Admi" 3. split the 3rd string i.e... (4 Replies)
Discussion started by: mohtashims
4 Replies

5. Shell Programming and Scripting

How is html code read, compared to say python?

so, the first line of bash, perl, python, ruby, and similar languages must contain the path to the interpreter...i.e. #!/bin/perl, or #!/bin/python. so in the case of a perl script, for instance, a perl script cannot and will never run if the perl program is not installed/present on the system. ... (9 Replies)
Discussion started by: SkySmart
9 Replies

6. Windows & DOS: Issues & Discussions

How to execute python script on remote with python way..?

Hi all, I am trying to run below python code for connecting remote windows machine from unix to run an python file exist on that remote windows machine.. Below is the code I am trying: #!/usr/bin/env python import wmi c = wmi.WMI("xxxxx", user="xxxx", password="xxxxxxx")... (1 Reply)
Discussion started by: onenessboy
1 Replies

7. Shell Programming and Scripting

Feed python with read line in shell

Hello, I am running under ubuntu 14.04. I have a python file bringing requested data. When I run, it asks me to enter query info. After that, it gives the data if anything matched can be found. What I need to accomplish is, instead of entering the requested data from keyboard, to put all... (11 Replies)
Discussion started by: baris35
11 Replies

8. Programming

Create a C source and compile inside Python 1.4.0 to 3.7.0 in Python for ALL? platforms...

Hi all... As you know I like making code backwards compatible for as many platforms as possible. This Python script was in fact dedicated for the AMIGA A1200 using Pythons 1.4.0, 1.5.2, 1.6.0, 2.0.1, and 2.4.6 as that is all we have for varying levels of upgrades from a HDD and 4MB FastRam... (1 Reply)
Discussion started by: wisecracker
1 Replies

9. Shell Programming and Scripting

Unable to print python array in shell script loop.

I am unable to loop print a python string array in my unix shell script: ~/readarr.sh '{{ myarr }}' more readarr.sh echo "Parameter 1:"$1 MYARRAY= $1 IFS= MYARRAY=`python <<< "print ' '.join($MYARRAY)"` for a in "$MYARRAY"; do echo "Printing Array: $a" done Can you... (10 Replies)
Discussion started by: mohtashims
10 Replies
wml::std::grid(3)						     EN Tools							 wml::std::grid(3)

NAME
wml::std::grid - Layout Grid SYNOPSIS
#use wml::std::grid <grid [attributes]> <cell [attributes]>...</cell> : <cell [attributes]>...</cell> </grid> DESCRIPTION
The "<grid>" container tag provides a mixture between a HTML table and a TeX-like way of specifying its dimensions and the alignment of its cells. ATTRIBUTES
First the possible attributes for "<grid>": "summary" This attribute will be inserted into the "table" tag, see documentation of HTML 4.0 for details on why this attribute is recommended. "layout" This specifies the layout of the grid in X and Y dimension, i.e. "3x2" means 3 columns (x-dimension) and 2 rows (y-dimension). Default is "1x"NCELL where NCELL is the number of cell tags or in other words: Default is a top-down list. "align" This specifies the horizontal alignment of the cells in a row. The argument has to contain as many characters as there are cells in a row. The supported alignment characters are `"l"' (left), `"r"' (right) and `"c"' (center). Default is `"l...l"' (as much "l"'s as there are cells in a row). "valign" This specifies the vertical alignment of the cells in a column. The argument has to contain as many characters as there are cells in a column. The supported alignment characters are `"t"' (top), `"b"' (bottom) and `"m"' (middle). Default is `"t...t"' (as much "t"'s as there are cells in a column). "width" This is the corresponding attribute of the HTML "<table>" tag. Use it to set the width of the grid. Default is no specified width. "spacing" This is the corresponding attribute to "cellspacing" of the HTML "<table>" tag. Use it to set the spacing of cells in the grid, i.e. the space around the content of each cell. Default is 0 (no space). "padding" This is the corresponding attribute to "<cellpadding>" of the HTML "<table>" tag. Use it to set the padding between cells in the grid, i.e. the inter-cell space. Default is 0 (no space). "border" This is the corresponding attribute of the HTML "<table>" tag. Use it to set the border width of the grid. Default is 0 (no border). "bgcolor" This is the corresponding attribute of the HTML "<table>" tag. Use it to set the background color of the grid. Default is no specified color. "color" This sets the foreground (text) color of the grid's contents. Actually this sets the default for the same attribute of "<cell>". Default is no specified color. Second the possible attributes for "<cell>": "align" This is the corresponding attribute of the HTML "<td>" tag. Use it to set the horizontal alignment of the cell's contents. Default is taken from the same attribute of "<grid>". "valign" This is the corresponding attribute of the HTML "<td>" tag. Use it to set the vertical alignment of the cell's contents. Default is taken from the same attribute of "<grid>". "bgcolor" This is the corresponding attribute of the HTML "<td>" tag. Use it to set the background color of a particular cell. Default is no specified color. "color" This sets the foreground (text) color of the cell's contents. This is done via the HTML "<font>" tag. Default is no specified color or the color from the same attribute of "<grid>". "rowspan" This is the corresponding attribute of the HTML "<td>" tag. Use it to span a cell over more then one row of the grid. Default is 1 row. "colspan" This is the corresponding attribute of the HTML "<td>" tag. Use it to span a cell over more then one column of the grid. Default is 1 column. "width" This is the corresponding attribute of the HTML "<td>" tag. Use it to set the width of the cell. Default is no specified width. "height" This is the corresponding attribute of the HTML "<td>" tag. Use it to set the height of the cell. Default is no specified height. EXAMPLE
<grid bgcolor="#000000" color="#ffffff" layout="3x2" align="llr" valign="tm"> <cell>A</cell> <cell>B</cell> <cell>C</cell> <cell>D</cell> <cell>E</cell> <cell>F</cell> </grid> AUTHOR
Ralf S. Engelschall rse@engelschall.com www.engelschall.com REQUIRES
Internal: P1, P2, P3, P5 External: -- SEE ALSO
HTML <"table">-tag. EN Tools 2014-04-16 wml::std::grid(3)
All times are GMT -4. The time now is 09:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy