Please stop spamming the group. If someone has an answer for your
question they will post it.

I have created a file that creates a CSV file and stores it on the
server. After the file has been created, users can click on a link to
download it. This file can be opened using Excel and other spreadsheet
programs, but you will not get the same "nice" formatting you would
get that is displayed on HTML.

Here the code snippet:

<% try {
    String fileName = "/<directory to store file>/
export-"+request.getParameter("e")+".csv";
    DataOutputStream oFile = new DataOutputStream(new
FileOutputStream(fileName));

    StringBuffer sb = new StringBuffer();
    sb.append("User ID,Name,Email\n");

    db_query = "select user_id, name, email from TABLE'";
    db_result = stmt.executeQuery(db_query);
    while (db_result.next()) {
        sb.append( db_result.getString("user_id") +","+
db_result.getString("name") +","+ db_result.getString("email") +"\n");
    }

    oFile.writeBytes(sb.toString());
    oFile.close();

} catch (Exception e) {
    flag_error = true;
} %>

http://faq.javaranch.com/view?JspAndExcel

Tobi