Json to excel convertion using java

Question

i've created an application for converting json to excel , The code works fine but nothing is writing into excel sheet generated. can anyone please tell me the reason for this.

jxl library for excel convertion

My code is given below

 public static void majin(String[] args) throws Exception
        {   

            WritableWorkbook wworkbook;
            wworkbook = Workbook.createWorkbook(new File("C:/SWD.csv"));
            WritableSheet wsheet = wworkbook.createSheet("SWD", 0);

            WritableFont cellFont = new WritableFont(WritableFont.TIMES, 12);
            cellFont.setColour(Colour.BLACK);
            WritableCellFormat cellFormat = new WritableCellFormat(cellFont);

            cellFormat.setBackground(Colour.WHITE); 
            cellFormat.setBorder(Border.ALL, BorderLineStyle.THIN);
            Label label = new Label(0, 0,"mydata",cellFormat);
            wsheet.setColumnView(0, 18);
            wsheet.addCell(label); 

        }

guide me how to get my json data into excel

Karthi
– Karthi

2016-12-19 07:59:38 +00:00
Commented Dec 19, 2016 at 7:59 — Karthi
– Karthi, Commented Dec 19, 2016 at 7:59

Bhushan · Accepted Answer · 2014-02-03 05:23:28Z

1

I guess you have missed following line to write data to excel file:

wsheet.write();

And you can close the file after writing data into file like:

wsheet.close();

answered Feb 3, 2014 at 5:23

Bhushan

6,19113 gold badges61 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Json to excel convertion using java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related