xlsLib

Latest xlslib News This library allows a C++, C, or Objective-C programmer to dynamically construct Excel spreadsheets in code. A few test files in the test folder demonstrate usage. Visual Studio, RadStudio, CodeBlocks, and BSD users can find projects in the xlslib/xlslib/build directory. Mac and iOS programmers can use the DHxls library projects (with test projects) in the DHxls folder. 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.