Little problem while exporting JTable to excel

[adeeb alexander]

Hi all.
I am trying to export the JTable to excel file. I am facing two problems. The first is when ever an empty column is present i get null pointer exception. The second is when ever the number is there it is converted to scientific format i.e (e+023) like that. I need to save the number as it is. Some one has any idea about it. Please help me out. The code is below

    
	chooser = new JFileChooser();
			System.out.println("Done:");
			int state = chooser.showSaveDialog(null);
				File file = chooser.getSelectedFile();
				
				if (file != null && state == JFileChooser.APPROVE_OPTION)
				{
					try
					{
						BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(file));
					//	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();
								System.out.println(s);
								bufferedWriter.write(s+";");
								bufferedWriter.flush();
							}
							bufferedWriter.write(newline);
							
						}	
						bufferedWriter.close();
						JOptionPane.showMessageDialog(null, "Success");
					}catch(Exception e)
					{
					//	JOptionPane.showMessageDialog(null, "Failure");
					System.out.println("Error :" + e);
					}
				}

Thanks and Regards
alexander>

[Rob Spoor]

First, the NullPointerException. That's caused by this line:

String s = model.getValueAt(i,j).toString(); 

If the cell is empty, the value is quite often null. The following will fix that:

Object o = model.getValueAt(i, j);
String s = (o == null ? "" : o.toString());

I'm not using String.valueOf because that will put the String literal "null" into s when the cell is empty.

As for the formatting issue, use a proper Excel API like Apache POI or JExcelAPI. You can specify the cell type; Excel has a nasty habit of applying its own formatting when numbers get too large.