Updates

To download the software, please register for an account.



New Features



3/8/14 - copy_sheet and move_sheet and added for moving sheets between workbooks.


1/10/14 - Added special script features: running scripts with no visible Python shell and autolaunching scripts when a spreadsheet is opened.


11/11/13 - Added Cell.df, for writing pandas dataframes directly to Excel.


10/11/13 - UDF's are now disabled by default.


9/30/13 - Added all_cells function.


9/10/13 - Format copying added to Cells and CellRanges.


8/8/13 - multi-workbook functions and images.


8/5/13 - lock images function.


8/5/13 - Performance improvements.


7/14/13 - merge_cell changed to merge_range. Added unmerge_range, get_merged_range, recalc_mode, hide_row, hide_col, row_is_hidden, col_is_hidden.
Sped up CellRange copying.


5/20/13 - Performance improvements.


4/12/13 - Upgraded to Python 2.7.4. Python window now displays the title of the running script.


3/8/13 - The built-in editor now opens imported scripts automatically.


3/5/13 - Added hidden sheets, hyperlinks, functions for getting the last cell in a column, row or on a sheet, sheet and workbook recalculation, and vertical_range and horizontal_range.


2/12/13 - Added iPython.


2/8/13 - Added support for column letters in Cell and CellRange creation. (e.g. Cell(1, "A") works now).
Updated Cell.clear() to clear a cell, not just set its value to None.
Added cell copying in Cell.copy_from().


1/6/13 - Cell.formula now always returns strings. UDF timeout setting added.


12/12/12 - UDF's support optional arguments.


11/6 - Added cell alignment.


10/16 - Added cell comments.


10/15 - Added support for ActiveState Python.


10/11 - Added support for calling VBA from DataNitro, and DN from VBA.


10/5 - Added horizontal and vertical Cell properties. (This automatically fills in rows and columns from iterables.) Added saving.


10/2 - Added unicode support. Changed the syntax for active_sheet. Added support for 64-bit UDF's.


8/18 - Added support for Python 2.6 and above, including 3.0, 3.1, and 3.2, and 64-bit Python.


8/16 - Added the ability to refresh pivot tables.


8/14 - Added insert row and insert column.


7/23 - Added user defined functions.


7/19 - Added merge_cells. Changed the autofit syntax.


7/16 - Added the autofit command.


7/13 - Fixed issues with installation on non-administrator accounts.


7/6 - Empty cells now return None instead of 0.


7/4 - Happy Fourth of July!
Added cell.col as an alternative to cell.column, clear/delete for rows and columns, and the is_empty method for Cells and CellRanges.


7/3 - Added setting named ranges and the CellRange.position property.


6/29 - Added the forum.


6/27 - Added support for importing multiple scripts and saving imported scripts in a spreadsheet. Changed the active cell and active sheet syntax, and added support for interacting with the visible sheet. Note: The new active sheet and active cell syntax is not backwards compatible.
Also added a new demo video. The binomial pricing script and spreadsheet from the video are available for download, as is the ystockquote script for pulling data from yahoo finance, originally from http://goldb.org/ystockquote.html.


6/25 - Active cell and additional worksheet functions added.


6/21 - Support for cell formatting, cell colors, and dates added.