Today we're going to show how to read a XML file and convert it's entries to lines on an excel file. The XML file is located at https://github.com/jbaysolutions/xml-to-excel/blob/master/Publication1.xml?raw=true. The XML file's main nodes are "Substances", each one has a few...
Read More
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
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
