This section shows changes and bug fixes in the XlsxWriter module.
set_table()
.intercept
, display_equation
and display_r_squared
.
Feature request #357.insert_image()
issue when handling images with zero dpi.
Issue #356.set_custom_property()
method to set custom document
properties.
Feature request #355.get_worksheet_by_name()
method to allow the retrieval of a
worksheet from a workbook via its name.external:
urls where the target/anchor contains spaces.
Issue #350.set_center_across()
format method.write_url()
exception when the URL contains two #
location/anchors. Note, URLs like this aren’t strictly valid and cannot be
entered manually in Excel.
Issue #330.set_x_axis()
.hyperlink_base
document property.
Feature request #306.with
context manager.
Pull request #239.insert_textbox()
and
Working with Textboxes for more details.
Feature request #107.set_x_axis()
.
Feature request #185.nan_inf_to_errors
Workbook()
constructor option to allow
mapping of Python nan/inf value to Excel error formulas in write()
and
write_number()
.
Feature request #150.add_table()
.
Feature request #216.set_header()
.
Feature request #134.insert_image()
images from byte streams to allow
images from URLs and other sources.
Feature request #118.write_datetime()
support for datetime.timedelta.
Feature request #128.insert_chart()
and
set_size()
.insert_image()
to control how
images are moved in relation to surrounding cells.
Feature request #117.error_bar
exceptions.
Issue #115.write()
methods.
Issue #108.inside_base
data label position in charts.set_calc_mode()
method to control automatic calculation of
formulas when worksheet is opened. Thanks to Chris Tompkinson.use_zip64()
method to allow ZIP64 extensions when writing
very large files.in_memory
mode.
Issue #102.set_column()
entries.
Issue #82.set_title()
none
option to turn off automatic titles.define_name()
name validation.conditional_format()
.in_memory
Workbook()
constructor option to allow XlsxWriter
to work on Google App Engine.
Feature request #28.position_axis
chart axis option.write_url()
.Workbook()
constructor options strings_to_formulas
and
strings_to_urls
to override default conversion of strings in write().insert_image()
for images that extend
over several cells.write()
function.write_boolean()
function to write Excel boolean values. Feature request
#37. Also added
explicit handling of Python bool values to the write()
function.Workbook()
constructor option
strings_to_numbers
default option to False so that there is no implicit
conversion of numbers in strings to numbers. The previous behavior can be
obtained by setting the constructor option to True.
Note This is a backward incompatibility.Workbook()
constructor option strings_to_numbers
to
override default conversion of number strings to numbers in write().Workbook()
constructor option default_date_format
to
allow a default date format string to be set. Feature request
#5.Added worksheet tables. See Working with Worksheet Tables and Example: Worksheet Tables.
Tested with the new Python stable releases 2.7.4 and 3.3.1. All tests now pass in the following versions:
- Python 2.6
- Python 2.7.2
- Python 2.7.3
- Python 2.7.4
- Python 3.1
- Python 3.2
- Python 3.3.0
- Python 3.3.1
There are now over 700 unit tests including more than 170 tests that compare against the output of Excel.
set_default_row()
method. See Example: Hiding Rows and Columns.freeze_panes()
and split_panes()
methods.
See Example: Freeze Panes and Split Panes .set_selection()
method to select worksheet cell or range of
cells.Workbook()
parameters 'tmpdir'
and
'date_1904'
.Workbook()
'constant_memory'
constructor property to
minimize memory usage when writing large files. See Working with Memory and Performance
for more details.data_validation()
method, Working with Data Validation and Example: Data Validation and Drop Down Lists.write_datetime()
method. GitHub issue
#3.
Thanks to Eduardo (eazb) and Josh English for the prompt.conditional_format()
method,
Working with Conditional Formatting and Example: Conditional Formatting.Added Python 2.6 support. All tests now pass in the following versions:
- Python 2.6
- Python 2.7.2
- Python 2.7.3
- Python 3.1
- Python 3.2
- Python 3.3.0
write_comment()
and Working with Cell Comments.insert_image()
worksheet method to support inserting PNG and
JPEG images into a worksheet. See also the example program
Example: Inserting images into a worksheet.write_rich_string()
worksheet method to allow writing of
text with multiple formats to a cell. Also added example program:
Example: Writing “Rich” strings with multiple formats.hide()
worksheet method to hide worksheets.set_first_sheet()
worksheet method.protect()
worksheet method to allow protection of cells
from editing. Also added example program: Example: Enabling Cell protection in Worksheets.Added worksheet methods:
set_zoom()
for setting worksheet zoom levels.right_to_left()
for middle eastern versions of Excel.hide_zero()
for hiding zero values in cells.set_tab_color()
for setting the worksheet tab color.
write_row()
and write_column()
worksheet methods.write_url()
worksheet method for writing hyperlinks to
a worksheet.Added the set_properties()
workbook method for setting document
properties.
Added several new examples programs with documentation. The examples now include:
- array_formula.py
- cell_indentation.py
- datetimes.py
- defined_name.py
- demo.py
- doc_properties.py
- headers_footers.py
- hello_world.py
- merge1.py
- tutorial1.py
- tutorial2.py
- tutorial3.py
- unicode_polish_utf8.py
- unicode_shift_jis.py
define_name()
method to create defined names and ranges
in a workbook or worksheet.worksheets()
method as an accessor for the worksheets in a
workbook.merge_range()
method to merge worksheet cells.Added final page setup methods to complete the page setup section.
Added page setup method.
Added page setup methods.
Added Python 3 support with help from John Evans. Tested with:
- Python-2.7.2
- Python-2.7.3
- Python-3.2
- Python-3.3.0
Added page setup methods.
Added page setup method.
Added page setup methods.