Thread: How to change html data into excel in java?

Originally Posted by rgupta31

Suppose I have databse in which daliy I entered some information of student like roll no., class, age , sex, fee status etc. at the end of the month I want that a file will generate in the excel format that comprises of all the details of the student for the particular month. Please respond me as soon as possible. If you have code in java for this than it will be very helpul for me.

Thanks

What database are you using? Let me know and I will help you with the code..

Originally Posted by rgupta31

for 3rd page i does not understand how to initiate shall i make a button that have written Generate report and call an action event on that or make link on the main page to redirect that main page onto some other page???

Both of these methods would work. I would probably go for the action event on the button..

This tutorial will help you connect to the access database:

http://www.javaprogrammingforums.com...jdbc-java.html

You just need to select 'Microsoft Access Database' at the ODBC Data Source Administor stage.

No problem

If you get stuck then please post whatever code you have so far and hopefully I will be able to help you move forward.

rgupta31, please don't double post. Creating another duplicate thread won't make things happen any faster.

First you need to work out the logic for how you are going to do this.

I suggest you first connect to the database, extract the information line by line, and then write it out again as a .csv file. Chris provided you a link with information on .csv.

I already gave you the link to a tutorial on how to connect to the database and you can use this tutorial to write the csv file:

http://www.javaprogrammingforums.com...sing-java.html

This is untested but it will look something like this:

import java.sql.*;
import java.io.*;
 
public class Rgupta31 {
 
    /**
     * JavaProgrammingForums.com
     */    
    public static void main(String[] args) {
 
        try {
 
            String newLine = System.getProperty("line.separator");
 
            Writer output = null;
            File file = new File("ExcelFile.csv");
            output = new BufferedWriter(new FileWriter(file));
 
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:schooldb");
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery("Select * from [Sheet1$]");
 
            ResultSetMetaData rsmd = rs.getMetaData();
            int numberOfColumns = rsmd.getColumnCount();
 
            while (rs.next()) {
 
                for (int i = 1; i <= numberOfColumns; i++) {
                    if (i > 1)
                        System.out.print(", ");
                    String columnValue = rs.getString(i);
 
                    System.out.print(columnValue);
                    output.write(columnValue);
                    output.write(newLine);
 
                }
                System.out.println("");
            }
 
            st.close();
            con.close();
            output.close();
 
        } catch (Exception ex) {
            System.err.print("Exception: ");
            System.err.println(ex.getMessage());
        }
    }
}

Don't just try and run this without reading the JDBC tutorial first:

http://www.javaprogrammingforums.com...jdbc-java.html