Hi,
I made application which needs to save the report file. I got report
file from the database and i got it as ResulSet.
I found in internet library calls CSVWriter which helps me save the
raport. The problem is that i dont know how to parse it to proper
Excel look.The code looks like this :
FileDialog d = new FileDialog(frame,"What file do you want to
save?",FileDialog.SAVE);
d.setFile("*.csv");
d.setDirectory(".");
d.show();
String saveFile;
if((saveFile = d.getFile()) != null) {
filename.setText(saveFile);
directory.setText(d.getDirectory());
try{
CSVWriter writer = new CSVWriter(new
FileWriter(directory.getText()+filename.getText()), ',');
writer.writeAll(rsDane2 , t);
writer.close();
}catch(java.sql.SQLException e){e.printStackTrace();}
catch(java.io.IOException f){ f.printStackTrace(); }
} else {
filename.setText("You pressed cancel");
directory.setText("");
}
Im looking for two solutions.
1) How can I convert saved csv file to Excel or diffrent type of file
( The prioritet is the data being visible ) Cause with comma,space,tab
whatever i cant see
anything :( And i need to do it in Java code
2) Maybe there is diffrent way to save ResultSet to the excel file.
This is really big array so i think the best way is to save it in
excel file
|
