excel Tutorials, Tips & Tricks

24 Mar, 2015

Excel Macro: Evaluating Formulas Dynamically

In this post, we will see how excel formulas can be picked-up dynamically in excel macros. This tutorial also covers applying cell formats dynamically. Lets consider the following example. For data setup, we open...

Java

28 Nov, 2012

Read / Write Excel file in Java using Apache POI

Apache POI is a powerful Java library to work with different Microsoft Office file formats such as Excel, Power point, Visio, MS Word etc. The name POI was originally an acronym for Poor Obfuscation Implementation,...