How to write the JTables Content into the CSV File.

for (int row = 0; row < yourJtable.getRowCount(); ++row){

for (int col = 0; col < yourJtable.getColumnCount(); ++col){

Object ob = yourJtable.getValueAt(row, col);

addCSV(ob);

}

}

hiwaa at 2007-7-12 8:30:51 >

Hi friend

When i use this same Program to wirte the Database records it wirtes exactly into the CSV File.

In My program i used this code to get the JTable's content

for (int row = 0; row < yourJtable.getRowCount(); ++row){

for (int col = 0; col < yourJtable.getColumnCount(); ++col){

Object ob = yourJtable.getValueAt(row, col);

}

}

After that i just passed the object to the Following code to write them into the CSV File

String rec = "";

for (int i=0; i ><fieldNames.length; i++)

{

rec +='\"'+fieldNames[i]+'\"';

rec+=",";

}

if (rec.endsWith(",")) rec=rec.substring(0, (rec.length()-1));

writing.println(rec);

//write values from result set to file

rec +="\""+ob+"\",";

if (rec.endsWith(",")) rec=rec.substring(0,(rec.length()-1));

writing.println(rec);

writing.close();

in the above code where ever you find ob, there i Placed the Resultset.getString().

It wrote the records which brought by the SQL.

now i am not able to write the JTable's Contend. the Previouse post of mine is a Working code. Could you please run that and give me good solution

Thank you for your Help

Cheers

Jofin>

jofin123a at 2007-7-12 8:30:51 >

Hi Friend

see here on this particular Block i have called the PrintWriters instance inside the for Loop.

for(int row=0;row<table.getRowCount();++row)

{

for(int col=0;col<table.getColumnCount();++col)

{

Object ob=table.getValueAt(row,col);

//exportApi(ob);

System.out.println(ob);

System.out.println("Connected");

String fieldNames[]={"BOOK ID","NAME","AUTHOR","PRICE"};

String rec = "";

for (int i=0; i ><fieldNames.length; i++)

{

rec +='\"'+fieldNames[i]+'\"';

rec+=",";

}

if (rec.endsWith(",")) rec=rec.substring(0, (rec.length()-1));

writing.println(rec);

//write values from result set to file

rec +="\""+ob+"\",";

if (rec.endsWith(",")) rec=rec.substring(0,(rec.length()-1));

writing.println(rec);

writing.close();

}

}

You can run My code and see. But i am not able to find out why it is not printing the Content inside the CSV File.

Thank you for your help

Cheers

Jofin>

jofin123a at 2007-7-12 8:30:51 >

Hi friends

I just managed to print the JTable's Content inside the CSV File.

But now the Problem is it is now problem is It does not Print the JTable's Content in row and Column wise. All the Records are printed in one Column itself.

This is My code Please run this code and give me a good solution to print exactly as it is in the JTable

import javax.swing.*;

import java.util.*;

import java.io.*;

import java.awt.*;

import java.awt.event.*;

import javax.swing.table.*;

public class Exporting extends JDialog implements ActionListener

{

private JRadioButton rby,rbn,rbr,rbnore,rbnorest;

private ButtonGroup bg;

private JPanel exportpanel;

private JButton btnExpots;

FileReader reading=null;

FileWriter writing=null;

JTable table;

JScrollPane scroll;

public Exporting()throws Exception

{

setSize(550,450);

setTitle("Export Results");

this.setLocation(100,100);

String Heading[]={"BOOK ID","NAME","AUTHOR","PRICE"};

String records[][]={{"B0201","JAVA PROGRAMING","JAMES","1234.00"},

{"B0202","SERVLET PROGRAMING","GOSLIN","1425.00"},

{"B0203","PHP DEVELOPMENT","SUNITHA","123"},

{"B0204","PRIAM","SELVI","1354"},

{"B0205","JAVA PROGRAMING","JAMES","1234.00"},

{"B0206","SERVLET PROGRAMING","GOSLIN","1425.00"},

{"B0207","PHP DEVELOPMENT","SUNITHA","123"},

{"B0208","PRIAM","SELVI","1354"}};

btnExpots= new JButton("Export");

btnExpots.addActionListener(this);

btnExpots.setBounds(140,200,60,25);

table = new JTable();

scroll=new JScrollPane(table);

((DefaultTableModel)table.getModel()).setDataVector(records,Heading);

System.out.println(table.getModel());

exportpanel= new JPanel();

exportpanel.add(btnExpots,BorderLayout.SOUTH);

exportpanel.add(scroll);

getContentPane().add(exportpanel);

setVisible(true);

}

public void actionPerformed(ActionEvent ae)

{

Object obj=ae.getSource();

Object ob=null;

try {

PrintWriter writing= new PrintWriter(new FileWriter("Report.csv"));

if(obj==btnExpots)

{

for(int row=0;row<table.getRowCount();row++)

{

for(int col=0;col<table.getColumnCount();col++)

{

ob=table.getValueAt(row,col);

String rec = "";

//write values from result set to file

rec +="\""+ob+"\",";

System.out.println(rec);

if (rec.endsWith(","))

rec=rec.substring(0,(rec.length()-1));

System.out.println(rec);

writing.format(rec);

}

}

writing.close();

}

}

catch(Exception ex)

{

ex.printStackTrace();

}

}

public static void main(String arg[]) throws Exception

{

Exporting ex= new Exporting();

}

}

Please help me on this Issue. I have been Lots of time to do this But i am not getting the Answer.

Thank you for your great help

Cheers

Jofin>

jofin123a at 2007-7-12 8:30:51 >