Export Jtable contents to Excel format

Hi,
I need to export the values in the JTable component to be exported to MS - excel. Currently it is successfully exported as text file, but when I open in Ms-Excel, the contents are displayed in single cell. Here is the code I have used :

Code:

---

int state = chooser.showSaveDialog(null);
File file = chooser.getSelectedFile();
if (file != null && state == JFileChooser.APPROVE_OPTION)
{
        try
        {
                BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(file,true));
                PrintWriter fileWriter = new PrintWriter(bufferedWriter);

                for(int i=0; i<model.getRowCount(); ++i)
                {
                        for(int j=0; j<model.getColumnCount(); ++j)
                        {
                                String s = model.getValueAt(i,j).toString();
                                fileWriter.print(s);
                        }
                        fileWriter.println("");
                }       
                fileWriter.close();
                JOptionPane.showMessageDialog(null, "Success");
        }catch(Exception e)
        {
                JOptionPane.showMessageDialog(null, "Failure");
        }
}

---

You could try outputting them in CSV format i.e.

a,b,c
d,e,f
g,h,i

If you save it with a .csv extension I think Excel will then open it correctly.

Davey is right - the default import format for Excel is CSV (comma-delimited) format in .csv text files.

Each field should be separated from the next by commas, and each line should be separated from the next by a newline character ('\n'), or return and newline ("\r\n").

If any field contains the delimiter or a newline, surround it with double-quotes.

Use tabs as the delimiters for copy & pasting from the clipboard.

Today, most software exists, not to solve a problem, but to interface with other software...
I. O. Angell

Thanks for ur reply .It works fine.