Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Manage Database Metadata with POI and Excel : Page 3

Set up quick and easy database metadata housekeeping with the Java Apache POI libraries and Microsoft Excel.




Application Security Testing: An Integral Part of DevOps

As you can see, the POI API mirrors the way Excel itself works. The objects created are simply abstractions of the elements that make up the Excel application's primary parts: workbook, worksheet, rows, and cells.

With this utility, you can easily create a database metadata container that anybody in your organization can access. While a certain amount of discipline is required to keep these worksheets up to date, the utility will allow you to begin improving your database housekeeping.

Doug Tillman is a veteran Java and Python developer turned Scrum Master.
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date