473,574 Members | 2,252 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

PyExcerlerator details

Hi, I'm using PyExcelerator, and it's great, but I can't figure out a
few things:
(1) I set the cell style to '0.00%' but the style does not work.

(2) I want to place a border around the cells( x1, y1, x2, y2 ) but I
can't find any example of doing that.
Well I do see ONE example, but it erases the cells if I do it after,
or when I write to the cells that erases the outline.
Surely I don't have to tediously set each cells border?

Jun 27 '08 #1
1 1274
A_H wrote:
Hi, I'm using PyExcelerator, and it's great,
If you are using the latest released version, it's not, IMO. Reading the
fixed-later bug reports on Sourceforge may prompt you to get the latest
version from svn. Reading the unfixed bug reports on Sourceforge may
prompt you to switch to xlwt (i.e. "Excel write"), a fork of
pyExcelerator (fixed known and unknown bugs, improved performance, and
runs under Python 2.3) -- available from

See also http://groups.google.com/group/python-excel [to which I've CCed
this reply].
but I can't figure out a
few things:
(1) I set the cell style to '0.00%' but the style does not work.
That isn't a style, it's a "number format". See num_formats.py in the
examples directory.
(2) I want to place a border around the cells( x1, y1, x2, y2 ) but I
can't find any example of doing that.
Well I do see ONE example, but it erases the cells if I do it after,
or when I write to the cells that erases the outline.
At the moment, neither pyExcelerator nor xlwt offer a style-setting
facility that's independent of the Worksheet.write method. It could well
be a useful enhancement.
Surely I don't have to tediously set each cells border?
Perhaps you could suggest what you think the API for setting a border on
a rectangle should be.

Each cell's border has to be set somehow. With a style_setting approach,
there are 8 different cases (4 sides and 4 corners). With an independent
border-setting approach, there would be only 4 different cases (4 sides)
.... this needs looking at to see how easily the existing data model
would support it.

Jun 27 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: sam1967 | last post by:
I know how to build forms with ASP and process user input. Now i want to take credit card payments via a form. i will then download the details and process them via our credit card machine. do i just create a regular ASP form and use a certificate on the server to encrypt the data ? ie https://server/getpaymentform.asp there is nothing...
by: Srinivasa Reddy K Ganji | last post by:
I have created a customer registration functionality which stores details of customers like name, address, country in a database. Now I am on to implementing the customer registration details update feature where in the customer can change all his details including change in country(country field is a drop down list). Customer details page...
by: Damian | last post by:
Hi everyone I'm having an issue with one of our applications. I'm getting the following error when attempting to log in to the site: Server Error in 'xxxxxxxxxxxxxxxx' Application. -------------------------------------------------------------------------------- Runtime Error Description: An application error occurred on the server. The...
by: hui | last post by:
I am trying to use an SQL Server 2000 to log the events, and have found somehow the contents in the details column get truncated. Details as following: The query I am using to retrieve details: select datalength(details), details from dbo.aspnet_WebEvent_Events A sample output row (slightly realigned for easy reading): 1842 Event...
by: SwatSoftwareDev | last post by:
Hi all, I have Master-Details-Details type of data i. e. every row of details table is attached with multiple rows of third table. What is the best approach (performance wise) to show this kind of Master Details Data on web forms ? Thanks in advance. Regards, Swat
by: brian.newman | last post by:
I'm trying to link a gridview to another gridview in a Master-Details architecture. But the Details list isn't filtering like it is suppossed to. It will show all items on page load and it won't remove any items when an item in the Masters list is selected. It shouldn't show anything until an item in the Master's list is selected and then...
by: chutney | last post by:
Dear all, please excuse the fact that this is not an explicit problem I have, but more of a general query. I have an Access database (2003) with a load of contact details in it. Including various fields for each contact, such as services they offer, where they are, main contact name etc. Some of these contact details will be out of date and...
by: randy.buchholz | last post by:
Been fighting this one for a while, looking for help. I have a simple page with a grid view and details view (just managing a single table). The details view is primarily used for creating new records, and the grid for display. Everything works fine unless there are no records in the table. In this case the details view does not show, so...
by: peter.c.bradley | last post by:
Hi folks, I have an Access report that has an unbound text box in the details section. The report also includes the standard headers and footers. The details section is populated by a query executed during the “Report_Open” event. Depending on the query, the details section can have 1 or more records and each record is a text string of...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.