About the Author
Jonny Hackett

Jonny Hackett

Twitter

Jonny is a Senior Software Engineer and Mentor with 15+ years of experience in IT. As a Java Developer, avid SportingKC fan, and photographer (check him out on www.Facebook.com/no9photography.) , Jonny is also our resident Spring Batch expert.

Using Apache POI With Protected Excel Files

Jonny Hackett Java, Problem Solving, Spring Batch, Technology Snapshot 1 Comment

While working on a recent project at a client, we had the opportunity to refactor some data extracts that were using a commercial Excel writing library, which we then converted to using the Apache POI Library for Excel. These data extracts were reports that included some calculated values, and depending on the client, were required to be password protected. When completed, the reports would be emailed to the recipients configured for each client.

In this post, we discuss the challenge of delivering protected Microsoft documents via email. We introduce a Java code solution for emailing password-protected Excel files when using the Apache POI Library.

Some of the required calculations we chose to implement using Excel formulas. Implementing formulas wasn’t a hard task and worked for what was needed.

Spring Batch: Multiple Format Output Writer

Jonny Hackett Java, Spring, Spring Batch 1 Comment

Being a strong advocate of Spring Batch, I’ve always talked about the notion of Spring Batch providing developers with a framework that allows them to focus on solving business needs. By doing so, it allows developers to not spend an inordinate amount of time solving all of the technical aspects to support the solution. To illustrate what I mean by …

Spring Batch – Replacing XML Job Configuration With JavaConfig

Jonny Hackett Java, Spring, Spring Batch, Technology Snapshot 7 Comments

I recently assisted a client in getting up and running with a Spring Batch implementation. The team had decided to move forward with a JavaConfig-based configuration for their batch jobs instead of the traditional XML-based configuration. As this is becoming a more common approach to configuring Java applications, I felt it was time to update Keyhole’s Spring Batch series to show you how …

Processing Java Annotations Using Reflection

Jonny Hackett Java, Technology Snapshot 4 Comments

In my previous article covering Java Annotations, I outlined a recent use case and provided you with some examples of custom annotations and how they might be used. In this article, I’m going to take that a step further and give you a few examples of custom annotations and how you would process these custom annotations using the Java Reflection API. …