Abhishek Mishra

 Profile Answers by Abhishek Mishra 

• Oct 8th, 2014

 

Account,LastName,FirstName,Balance,CreditLimit,AccountCreated,Rating
101,Reeves,Keanu,9315.45,10000.00,1/17/1998,A
312,Butler,Gerard,90.00,1000.00,8/6/2003,B
868,Hewitt,Jennifer Love,0,17000.00,5/25/1985,B
761,Pinkett-Smith,Jada,49654.87,100000.00,12/5/2006,A
317,Murray,Bill,789.65,5000.00,2/5/2007,C

Code
package com.northconcepts.datapipeline.examples.cookbook;


 


import java.io.File;


 


import com.northconcepts.datapipeline.core.DataReader;


import com.northconcepts.datapipeline.csv.CSVReader;


import com.northconcepts.datapipeline.fixedwidth.FixedWidthWriter;


import com.northconcepts.datapipeline.job.JobTemplate;


 


public class WriteACsvFileToFixedWidth {


     


    public static void main(String[] args) throws Throwable {


        DataReader reader = new CSVReader(new File("example/data/input/credit-balance-01.csv"))


            .setFieldNamesInFirstRow(true);


         


        FixedWidthWriter writer = new  FixedWidthWriter(new File("example/data/output/credit-balance-02.fw"));


        writer.addFields(8);


        writer.addFields(16);


        writer.addFields(16);


        writer.addFields(12);


        writer.addFields(14);


        writer.addFields(16);


        writer.addFields(7);


         


        JobTemplate.DEFAULT.transfer(reader, writer);


    }


 


}

Dusmanta

• Nov 12th, 2014

 

Use Apachae POI jar for this
HSSFSheet sheet = workBook.createSheet("testXls");

Code
// Code to Auto size the column widths


        for(int columnPosition = 0; columnPosition< 5; columnPosition++) {


             sheet.autoSizeColumn((short) (columnPosition));


        }