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
.::SWF::Shape(3pm)					User Contributed Perl Documentation					.::SWF::Shape(3pm)

NAME
SWF::Shape - Shape class SYNOPSIS
use SWF::Shape; $shape = new SWF::Shape(); $dispitem = $movie->add($shape); DESCRIPTION
SWF::Shape is the fundamental object of a flash movie. METHODS
new SWF::Shape() Creates a new Shape object. $shape->movePenTo($x, $y) Move the Shape's (imaginary) pen location to ($x, $y) in the Shape's coordinate space. $shape->movePen($dx, $dy) Add ($dx, $dy) to the Shape's pen current location. $x = $shape->getPenX() Returns Pen's x-coordinates $y = $shape->getPenY() Returns Pen's y-coordinates ($x, $y) = $shape->getPen() Returns Pen's (x,y) coordinates $shape->drawLineTo($x, $y) Draw a line (using current line style, set by one of the setLine...() methods) from the current position to ($x, $y). $shape->drawLine($dx, $dy) Draw a line (using current line style set by one of the setLine...() methods) from the current position to displacement ($dx, $dy). $shape->drawCurveTo($controlx, $controly, $anchorx, $anchory) Draw a quadratic curve (using current line style, set by one of the setLine...() methods) from current pen position to ($anchorx, $anchory) using control point ($controlx, $controly). $shape->drawCurve($controldx, $controly, $anchorx, $anchory) Draw a quadratic curve (using current line style, set by one of the setLine...() methods) from current pen position to displacement ($anchordx, $anchordy) using displacement control point ($controldx, $controldy). $shape->drawCubicTo($bx,$by,$cx,$cx,$dx,$dy) $shape->drawCubic($bx,$by,$cx,$cx,$dx,$dy) Draw a cubic curve (using current line style). [ToDo: Add some more details and demo code] $shape->setLine($width, $r, $g, $b [,$a]) Sets Shape's line width and color (RGB). To remove the Shape's line style call $shape->hideLine(). The used line width for drawing is a product of $width argument and scale value set, see SWF::setScale($scale). Arguments $r, $g, $b stand for red, green and blue color parts, optional $a for alpha value. $shape->setLineStyle($width, $r, $g, $b [,$a]) This OLD deprecated method is documented here only for compatibility reason. The line width -in TWIPS units- is independent of Ming scale value (more bug than feature). $shape->setLine2($width, $r, $g, $b ,$a, $flags, $miterLimit) A new method available for SWF version >=8 setting shape's line width and color (RGBA) with additional control flags (see below) and miter limit. To remove the Shape's line style call $shape->hideLine(). The used line width for drawing is a product of $width argument and scale value set, see SWF::setScale($scale). Arguments $r, $g, $b, $a stand for red, green, blue and alpha color parts. $a is not optional here. Available flags are: Line cap style: select one of the following flags (default is round cap style) SWF_LINESTYLE_CAP_ROUND SWF_LINESTYLE_CAP_NONE SWF_LINESTYLE_CAP_SQUARE Line join style: select one of the following flags (default is round join style) SWF_LINESTYLE_JOIN_ROUND SWF_LINESTYLE_JOIN_BEVEL SWF_LINESTYLE_JOIN_MITER Scaling flags: disable horizontal / vertical scaling SWF_LINESTYLE_FLAG_NOHSCALE SWF_LINESTYLE_FLAG_NOVSCALE Enable pixel hinting to correct blurry vertical / horizontal lines: all anchors will be aligned to full pixels SWF_LINESTYLE_FLAG_HINTING Disable stroke closure: if no-close flag is set caps will be applied instead of joins. SWF_LINESTYLE_FLAG_NOCLOSE End-cap style: default round SWF_LINESTYLE_FLAG_ENDCAP_ROUND SWF_LINESTYLE_FLAG_ENDCAP_NONE SWF_LINESTYLE_FLAG_ENDCAP_SQUARE If join style is SWF_LINESTYLE_JOIN_MITER a miter limit factor must be set. Miter max length is then calculated as: max miter len = miter limit * width. If join style is not miter, this value will be ignored. $shape->setLineStyle2($width, $r, $g, $b ,$a, $flags, $miterLimit) This OLD deprecated method is mentioned here only for compatibility reason, you'd better use setLine2(). $shape->setLine2Filled($width, $fill, $flags, $miterLimit) A new method available for SWF version >=8 setting shape's line width and fill style, $fill is an object of SWF::Fill class. For other argument details see item $shape->setLine2(). $shape->setLine2StyleFilled($width, $fill, $flags, $miterLimit) This OLD deprecated method is mentioned here only for compatibility reason, you'd better use setLine2Filled(). $shape->hideLine() Remove the Shape's line, i.e. make lines painted after this method call invisible. $fill = $shape->addSolidFill($r, $g, $b [,$a]) $fill = $shape->addFill($r, $g, $b [,$a]) Adds a solid fill to $shape list of fill styles and returns an SWF::Fill object. This object is used with the "setLine()" method described below. The default value of $a is 0. $fill = $shape->addBitmapFill($bitmap [,FLAG]) $fill = $shape->addFill($bitmap [,FLAG]) Adds a bitmap fill to $shape list of fill styles and returns an SWF::Fill object. This object is used with the "setLine()" method described below. $bitmap is an SWF::Bitmap object while FLAG argument can be SWFFILL_TILED_BITMAP or SWFFILL_CLIPPED_BITMAP. Make sure to import these constants to your package before useing it, i.e. use the following statement: use SWF::Fill <list of constants>; The default value of FLAG is SWFFILL_TILED_BITMAP. $fill = $shape->addGradientFill($gradient [,FLAG]) $fill = $shape->addFill($gradient [,FLAG]) Adds a gradient fill to $shape list of fill styles and returns an SWF::Fill object. This object is used with the "setLine()" method described below. $gradient is an SWF::Gradient object while FLAG argument can be SWFFILL_LINEAR_GRADIENT or SWFFILL_RADIAL_GRADIENT, plus SWFFILL_FOCAL_GRADIENT for V8. Make sure to import these constants to your package before useing it, i.e. use the following statement: use SWF::Fill <list of constants>; The default value of FLAG is SWFFILL_LINEAR_GRADIENT. $shape->xs_setLeftFill($fill) $shape->setLeftFill($fill) Sets the fill on the left side of the edge. $fill is an SWF::Fill object returned from "addFill" method. $shape->setLeftFill($r, $g, $b [,$a]) This is another way of saying: my $fill = $shape->addSolidFill($r, $g, $b [,$a]); $shape->setLeftFill($fill); $shape->xs_setRightFill($fill) $shape->setRightFill($fill) Sets the fill on the right side of the edge. $fill is an SWF::Fill object returned from "addFill" method. $shape->setRightFill($r, $g, $b [,$a]) This is another way of saying: my $fill = $shape->addSolidFill($r, $g, $b [,$a]); $shape->setRightFill($fill); $shape->drawCircle($r) Draws a circle with radious $r, also changes current position. $shape->drawArc($r, $startAngle, $endAngle) Draws an arc with radious $r form start to end. $shape->useVersion(version) This function allows to set the shapes version information. The version is only a hint. If necessary the version is upgraded. Valid values: are 3 and 4. Value of 3 is default, but 4 if linestyle2 is used. Some shape features are available only for shape version 4 and SWF file version>=8. One example is the usage of focal gradients: $g = new SWF::Gradient(); $g->setFocalPoint(-0.9); $g->addEntry(0.000000,0xff,0x00,0x00,0xff); $g->addEntry(1.000000,0x00,0xff,0x00,0xff); $shape->useVersion(4); $shape->addGradientFill($g,SWFFILL_FOCAL_GRADIENT); $version = $shape->getVersion() Gets the current shape object version. $shape->dumpOutline() Returns a string describing shape's outline. After drawing in a shape expect getting a multi-line string like: moveto 368,5 curveto 348,5 327,1 curveto 307,-3 284,-15 etc. etc. $shape->end() Stops drawing on this shape and make the shape complete. Further method calls won't produce any lines, circles etc. By using this demo code later no circle is painted: $shape->drawLineTo(300,300); $shape->end(); $shape->drawCircle(200); $shape->drawGlyph($font, $cnumber [, $size]) Draws character of $cnumber of $font. Also Unicode fonts are possible, if the font does provide that, just like next example: $font=new SWF::Font("Thai-Bold.fdb"); $sh->drawGlyph($font, 0x0E44, 44); $shape->drawCharacterBounds($character) Draws an outer rectangle fitting for $character, an object of SWF::Character. $shape->setRenderHintingFlags(flags) Set render hinting flags. Possible values are SWF::Constants::SWF_SHAPE_USESCALINGSTROKES and SWF::Constants::SWF_SHAPE_USENONSCALINGSTROKES This method also will set version of this SWF::Shape object to 4. AUTHOR
Soheil Seyfaie (soheil at users.sourceforge.net), Albrecht Kleine SEE ALSO
SWF, SWF::Bitmap, SWF::Button, SWF::Constants, SWF::DisplayItem, SWF::Fill, SWF::Font, SWF::Gradient, SWF::Morph, SWF::Movie, SWF::MovieClip, SWF::TextField, SWF::Text, SWF::Character perl v5.14.2 2011-10-26 .::SWF::Shape(3pm)
All times are GMT -4. The time now is 09:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy