Creating CSV to EXCEL file in java

in utopian-io •  7 years ago 

import java.io.FileOutputStream;
import java.io.FileReader;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

import au.com.bytecode.opencsv.CSVReader;

public class CreateCSVToExcel {
public void createCSVTOELs(String sourcePath,String destinationPath) throws Exception
{

            Workbook wb = new HSSFWorkbook();
            CreationHelper helper = wb.getCreationHelper();
            Sheet sheet = wb.createSheet("new sheet");

            CSVReader reader = new CSVReader(new FileReader(sourcePath));
            String[] line;
            int r = 0;
            while ((line = reader.readNext()) != null) {
                Row row = sheet.createRow((short) r++);

                for (int i = 0; i < line.length; i++)
                    row.createCell(i)
                       .setCellValue(helper.createRichTextString(line[i]));
            }

            // Write the output to a file
            FileOutputStream fileOut = new FileOutputStream(destinationPath);
            wb.write(fileOut);
            fileOut.close();
        
    }

}



Posted on Utopian.io - Rewarding Open Source Contributors

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Your contribution cannot be approved because 'blog posts' (or any category) is not suitable for code snippets.

You can contact us on Discord.
[utopian-moderator]