Create an utility to convert Microsoft excel spreadsheet to csv format.

I came across a scenario where I had to convert excel spreadsheets both xls and xlsx formats into csv programmatically .

My search for a library to achieve this landed me here Apache POI .   Apache POI is a Java API built for the purpose of handling Microsoft documents.

The site has an amazing collections of examples, with respect to each document type. For my scenario i.e handling excel sheets one can find list of examples available in the following link https://poi.apache.org/spreadsheet/examples.html .

I used the example ToCSV (http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java) and created a maven project. The project can be checked out from my git repo https://github.com/bharathdcs/exceltocsv .

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s