Sponsored Content
Top Forums Shell Programming and Scripting **python** unable to read the background color in python Post 302911974 by Chubler_XL on Tuesday 5th of August 2014 02:53:37 AM
Old 08-05-2014
From the documentation I think your going to need to look at:

Code:
sheet_ranges['D18'].style.fill.fill_type
sheet_ranges['D18'].style.fill.start_color.index

fill_type might be something like openpyxl.style.Fill.FILL_SOLID and You may find it quite difficult to map all the different fill styles (Solid, 75% Grey, etc) to HTML backgrounds.

You will also have to convert the color indexes to RGB values.
 

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
QBrush(3qt)															       QBrush(3qt)

NAME
QBrush - Defines the fill pattern of shapes drawn by a QPainter SYNOPSIS
#include <qbrush.h> Inherits Qt. Public Members QBrush () QBrush ( BrushStyle style ) QBrush ( const QColor & color, BrushStyle style = SolidPattern ) QBrush ( const QColor & color, const QPixmap & pixmap ) QBrush ( const QBrush & b ) ~QBrush () QBrush & operator= ( const QBrush & b ) BrushStyle style () const void setStyle ( BrushStyle s ) const QColor & color () const void setColor ( const QColor & c ) QPixmap * pixmap () const void setPixmap ( const QPixmap & pixmap ) bool operator== ( const QBrush & b ) const bool operator!= ( const QBrush & b ) const RELATED FUNCTION DOCUMENTATION
QDataStream & operator<< ( QDataStream & s, const QBrush & b ) QDataStream & operator>> ( QDataStream & s, QBrush & b ) DESCRIPTION
The QBrush class defines the fill pattern of shapes drawn by a QPainter. A brush has a style and a color. One of the brush styles is a custom pattern, which is defined by a QPixmap. The brush style defines the fill pattern. The default brush style is NoBrush (depending on how you construct a brush). This style tells the painter to not fill shapes. The standard style for filling is SolidPattern. The brush color defines the color of the fill pattern. The QColor documentation lists the predefined colors. Use the QPen class for specifying line/outline styles. Example: QPainter painter; QBrush brush( yellow ); // yellow solid pattern painter.begin( &anyPaintDevice ); // paint something painter.setBrush( brush ); // set the yellow brush painter.setPen( NoPen ); // do not draw outline painter.drawRect( 40,30, 200,100 ); // draw filled rectangle painter.setBrush( NoBrush ); // do not fill painter.setPen( black ); // set black pen, 0 pixel width painter.drawRect( 10,10, 30,20 ); // draw rectangle outline painter.end(); // painting done See the setStyle() function for a complete list of brush styles. <center> [Image Omitted] </center> See also QPainter, QPainter::setBrush(), QPainter::setBrushOrigin(), Graphics Classes, Image Processing Classes, and Implicitly and Explicitly Shared Classes. MEMBER FUNCTION DOCUMENTATION
QBrush::QBrush () Constructs a default black brush with the style NoBrush (will not fill shapes). QBrush::QBrush ( BrushStyle style ) Constructs a black brush with the style style. See also setStyle(). QBrush::QBrush ( const QColor & color, BrushStyle style = SolidPattern ) Constructs a brush with the color color and the style style. See also setColor() and setStyle(). QBrush::QBrush ( const QColor & color, const QPixmap & pixmap ) Constructs a brush with the color color and a custom pattern stored in pixmap. The color will only have an effect for monochrome pixmaps, i.e. for QPixmap::depth() == 1. Pixmap brushes are currently not supported when printing on X11. See also setColor() and setPixmap(). QBrush::QBrush ( const QBrush & b ) Constructs a brush that is a shallow copy of b. QBrush::~QBrush () Destroys the brush. const QColor &; QBrush::color () const Returns the brush color. See also setColor(). bool QBrush::operator!= ( const QBrush & b ) const Returns TRUE if the brush is different from b; otherwise returns FALSE. Two brushes are different if they have different styles, colors or pixmaps. See also operator==(). QBrush &; QBrush::operator= ( const QBrush & b ) Assigns b to this brush and returns a reference to this brush. bool QBrush::operator== ( const QBrush & b ) const Returns TRUE if the brush is equal to b; otherwise returns FALSE. Two brushes are equal if they have equal styles, colors and pixmaps. See also operator!=(). QPixmap * QBrush::pixmap () const Returns a pointer to the custom brush pattern, or 0 if no custom brush pattern has been set. See also setPixmap(). Example: richtext/richtext.cpp. void QBrush::setColor ( const QColor & c ) Sets the brush color to c. See also color() and setStyle(). Example: picture/picture.cpp. void QBrush::setPixmap ( const QPixmap & pixmap ) Sets the brush pixmap to pixmap. The style is set to CustomPattern. The current brush color will only have an effect for monochrome pixmaps, i.e. for QPixmap::depth() == 1. Pixmap brushes are currently not supported when printing on X11. See also pixmap() and color(). Example: richtext/richtext.cpp. void QBrush::setStyle ( BrushStyle s ) Sets the brush style to s. The brush styles are: <center>.nf </center> On Windows, dense and custom patterns cannot be transparent. See the Detailed Description for a picture of all the styles. See also style(). BrushStyle QBrush::style () const Returns the brush style. See also setStyle(). RELATED FUNCTION DOCUMENTATION
QDataStream &; operator<< ( QDataStream & s, const QBrush & b ) Writes the brush b to the stream s and returns a reference to the stream. See also Format of the QDataStream operators. QDataStream &; operator>> ( QDataStream & s, QBrush & b ) Reads the brush b from the stream s and returns a reference to the stream. See also Format of the QDataStream operators. SEE ALSO
http://doc.trolltech.com/qbrush.html http://www.trolltech.com/faq/tech.html COPYRIGHT
Copyright 1992-2007 Trolltech ASA, http://www.trolltech.com. See the license file included in the distribution for a complete license statement. AUTHOR
Generated automatically from the source code. BUGS
If you find a bug in Qt, please report it as described in http://doc.trolltech.com/bughowto.html. Good bug reports help us to help you. Thank you. The definitive Qt documentation is provided in HTML format; it is located at $QTDIR/doc/html and can be read using Qt Assistant or with a web browser. This man page is provided as a convenience for those users who prefer man pages, although this format is not officially supported by Trolltech. If you find errors in this manual page, please report them to qt-bugs@trolltech.com. Please include the name of the manual page (qbrush.3qt) and the Qt version (3.3.8). Trolltech AS 2 February 2007 QBrush(3qt)
All times are GMT -4. The time now is 01:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy