excel

A 2-post collection

Reading and parsing Excel Spreadsheet XML files with Java

Gustavo Santos 04 March 2015 | Tags: java apache poi excel excel spreadsheet xml excel 2003

On one of our projects, we were asked to implement a process that updates a database with values from an Excel file on a daily basis. The file is located at https://github.com/jbaysolutions/excel-xml-reader/raw/master/ActiveSubstance.xls. The problem with this file is its format. It's an...

Read More

Apache POI, translating Excel column number to letter

Gustavo Santos 08 June 2012 | Tags: java apache poi excel poi

Recently I had to write some code to generate excel files using Apache POI. One of the files was fairly complex and used formulas in a few cells. I found myself spending a few hours searching for a way to translate the indexed column numbers that POI uses to the...

Read More