Looking for the latest version? Download xlslib-package-2.4.0.zip (1.2 MB)
Name Modified Size Downloads / Week Status
Totals: 3 Items   1.2 MB 154
xlslib-old 2013-03-11 11 weekly downloads
README.txt 2014-06-12 5.6 kB 2222 weekly downloads
xlslib-package-2.4.0.zip 2013-04-13 1.2 MB 132132 weekly downloads
Latest xlslib News -------------------------- -------------------------- NEWS Jan 26 2014: the "notes" feature finally works - getting it to work was a huge undertaking, and required added any drawing objects to the file. However, now much of the work required to support images is done. If you have an interest in adding image files to your files, then add a comment under the "Discussion" topic "Images". -------------------------- NEWS Jan 6 2014: the formula class was enhanced to support Array Formulas. In addition, there is a new file in the "targets/test" directory, formulas.cpp, that has many examples of how to construct various types of formulas. -------------------------- This library allows a C++, C, or Objective-C programmer to dynamically construct Excel spreadsheets in code. A few test files in the test directory demonstrate usage. Note that you need some understanding of how Excel itself functions: workbooks, sheets, cells etc. While the sample code should get you started, not all functionality is explained. To delve deeper, you can read the excellent OpenOffice translation of the MS documents (the latter being extremely difficult for mere mortals to read): http://www.openoffice.org/sc/excelfileformat.pdf . -------------------------- Visual Studio, RadStudio, CodeBlocks, and BSD users can find projects in the xlslib/xlslib/build directory. Mac and iOS programmers can use JXLS at https://github.com/JanX2/JXLS. [The DHxls library project on this site is out of date and no longer supported.] Others should cd into the xlslib/xlslib directory, then: # ./bootstrap # if first attempt fails ./configure make make check make install RELEASE NOTES: Release 2.4.0 April 14, 2013 - Units for 'sheet' row height is now in TWIPS (same as the Excel spec) - xlslib strings now in their own namespace (thanks to Ger!) - xlstypes.h now more aware of newer C++ compilers with 16bit strings - Improved and more MSVS project files, updates to other build projects - "C" bridge now supports formulas - Formulas now support references to other sheets - Formulas now support FUNC_IF - DHxls now ARCified - Revised DHxls framework for Mac (using Xcode 4.6) - New DHxls library for iOS (using Xcode 4.6) Release 2.3.4 January 15, 2012 - the "area" feature for formulas was not exposed - so exposed it. Thus can now do SUMS(area): expression_node_factory_t& maker = wb.GetFormulaFactory(); cell_t *c1 = sh->number(0, 0, 1.1); sh->number(0, 1, 2.2); cell_t *c2 = sh->number(0, 2, 3.3); expression_node_t *pExpFormula = maker.f(FUNC_SUM, maker.area(*c1, *c2, CELL_RELATIVE_A1)); sh->formula(0, 3, pExpFormula, true); Release 2.3.0 January 2, 2012 - new feature: attach a HyperLink to a cell with optional '#' mark Can be any type of cell - number, label, etc. Also in bridge. - new feature: can now set default values for column width and row height - support for building the project with CodeBlock, RadStudio, and BDS - blocks now outputted per Excel specification - hopefully fixed the md5 checksums in "make check" - code was reformatted with uncrustify to make it easier for me to support - header cleanup so only required headers in the interface files - headers in the include directory are now placed in subdirectories. IMPORTANT NOTE: You should uninstall the old library first using old source (Version 2.2.0, archive still visible), only then install the latest 2.3.0. Or, you can do it manually. Look at the /usr/local/include/xlslib folder should be directories and only one file, xlslib.h. - one known bug - creating an empty spreadsheet with no cells is broken. File is corrupt according to Excel. This was broken, fixed, now broken again. Finally: each of the tests run in make check show 100% clean when run with valgrind! You can thank Ger Hobbelt for that! Release 2.2.0 November 11, 2011 - several bug fixes October 22, 2011 Release 2.1.0 - support for UTF-8 strings (must have iconv on your system) - fixed a problem where files exactly 130 512blocks long were unreadable - hopefully fixed the md5 checksums in "make check" - converted license from LGPL to BSD October 16, 2011 Release 2.0.0 - now using SST in support of text LABELs with strings > 255 (8224 bytes supported) - several bug fixes. - significant performance improvements - some support for Formulas (but no help right now) - see the mainC.cpp in test. November 26, 2009 Release 1.6.0 - release includes a configure script so bootstrapping is not always required - several bug fixes. - significant performance improvements - this is the last release on the original software base - version 2.0 will be quite different internally and much faster June 21, 2009 Release 1.5.0 - huge number of bug fixes. - performance improvements - 30x faster - will create a 64000x256 sheet in about 3 minutes. - now enables creation of document properties - DHxls Objective-C Framework (SVN repository, trunk/DHxls) October 25, 2008 Release 1.2.0 - Unicode support (upgrade format to BIFF8) along with previous ASCII - unlimited size - tested with 256 columns by 64000 rows - additional formatting options with the new BIFF8 (look in header files) February 9, 2008 Release 1.0.0 - buildable as 32 or 64 bit - added a "C" interface to support C-only applications - requires only the inclusion of a single header file: - general code cleanup and fixes April 25th, 2007 Release 0.2.5 - several code and makefile fixes so the project would build - fixes to the test application so it would build - license was changed to the Lesser GLP September 1st, 2004 Release 0.2.1. First stable usable release.
Source: README.txt, updated 2014-06-12