This is the home of the Related Project - ExportXLS space.

Navigate space

ExportXLS Web Client Plugin


As of v.3.3, this plugin provides the following functions:

It can be downloaded from the Download Page (at codeplex).


Refer to this Installation Guide and this User's manual for details.

Please refer to the built-in help ("Plugin Help" tab) for concise information after installation.

 Usage Case Suggestions

 Browser Compatibilities

 i2b2 version compatibilities

This version (v3.3) is compatible with i2b2 v.1.3-1.7.

 Version History of this Plugin


Initial release, for i2b2 v1.5. 
By Mauro Bucalo, Universita' di Pavia, Italy.

June 2011


Updated for i2b2 v1.6. 
By Mauro Bucalo, Universita' di Pavia, Italy.

Jan. 2012


Updated for i2b2 v1.3-1.6, Internet Explorer compatibilities; added flexible column exclusion, table title & caption, leading row count column, and other enhancements.
By Wayne Chan, University of Massachusetts Medical School, Worcester, USA; and Mauro Bucalo, Universita' di Pavia, Italy.

Feb. 2012


Major upgrade; many new features (CSV export, detailed tabulating of all observations, formatting options, paged queries...), heavily re-engineered.
By Axel Newe, Friedrich Alexander University Erlangen-Nuremberg, Germany.

Feb. 2013


Added options of using a subset of a large patient set; fixed blank 'Birth year' bug; added 'locality' column per request; added more user-friendly feedback (estimated run-time, etc.), help & hint; added server failure termination & notification. (for UMass Med School internal use only)
By Wayne Chan, University of Massachusetts Medical School, Worcester, USA.

Nov. 2013


Added support of displaying observation blobs (for users with appropriate access) and added several useful columns to the output option of '1 row per observation (detailed, 1 column per observation detail)'.
By PARIS Nicolas, Hôpital Ambroise Paré, Boulogne, France; and Wayne Chan, University of Massachusetts Medical School, Worcester, USA.

Mar. 2014

Release Notes

Version 3.3

Version 3.2

Version 3.0

Version 2.0

Based on feedback and input from other researchers, we have made the following updates, adjustments, enhancements, and fixes that may better serve everyone in the i2b2 community:

  1. Updated patient_list params to render this plugin compatible with i2b2 v1.3; and fixed a problem in the version for i2b2 v1.6 (it should now work on i2b2 v1.3-v1.6). 
  2. Added table title and caption to the resulting output table.
  3. Added new 1st column for patient row counts (no column title).
  4. Renamed the "StateCity" column title to "State/City".
  5. Removed any leading and trailing redundant "Zip codes" values from each state value string.
  6. Defaulted to using "concept_cd" for each selected concept entry if neither "tval_char" nor "nval_num" is available.
  7. Improved efficiencies.
  8. Facilitated the flexible dropping of any columns (that may contain data too sensitive or personal) from the resulting output table.
  9. Fixed the Internet Explorer (IE) hang problem.
  10. Fixed the missing "concept" columns on IE problem.
  11. Fixed the blank "patient_IDs" (when "Include Patient Date" not selected) on IE problem.
  12. Fixed table content getting cutoff on IE problem.
  13. Centered content in each table cell of the resulting output table.
  14. Added unique time-stamp to name of exported XLS file.
  15. Updated the description of this plugin displayed (in the available plugin list).
  16. Added more descriptions in the "Specify Data" and "Plugin Help" tab pages.
  17. Updated plugin category from "text" to "standard".

This new release is packed with installation guide and version supplementary note, and is available from the Google Code project download page set up for it, as well as the UMass Med School MICARD Downloads page.

 About Us

Please don't hesitate to contact us concerning any questions or problems.  Thanks.

Copyright 2011-2014 Universita' di Pavia,University of Massachusetts Medical School, Friedrich-Alexander-University Erlangen-Nuremberg, & Hôpital Ambroise Paré. 

Terms of Use

This plugin is published under the GNU GPL v3 license

This software is distributed as a plugin to the i2b2 v1.3-1.7 webclient framework, and may be used free of charge. It is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.