excel Tutorials, Tips & Tricks

Excel Macro: Evaluating Formulas Dynamically

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...

Read / Write Excel file in Java using Apache POI

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...