Breaking News: Grepper is joining You.com. Read the official announcement!

How To Export Records From JTable To MS Excel

Add Answer

Mappy Show answered on May 6, 2022 Popularity 9/10 Helpfulness 1/10

answer How To Export Records From JTable To MS Excel

related Export records from JTable to Excel_Java

related datatable export to excel

How To Export Records From JTable To MS Excel

Comment

public void toExcel(JTable table, File file){
    try{
        TableModel model = table.getModel();
        FileWriter excel = new FileWriter(file);

        for(int i = 0; i < model.getColumnCount(); i++){
            excel.write(model.getColumnName(i) + "\t");
        }

        excel.write("\n");

        for(int i=0; i< model.getRowCount(); i++) {
            for(int j=0; j < model.getColumnCount(); j++) {
                excel.write(model.getValueAt(i,j).toString()+"\t");
            }
            excel.write("\n");
        }

        excel.close();

    }catch(IOException e){ System.out.println(e); }
}

Popularity 9/10 Helpfulness 1/10 Language java

Source: sites.google.com

Tags: excel export java jtable records

Link to this answer
Share Copy Link

Contributed on May 06 2022

Mappy Show

0 Answers Avg Quality 2/10

Closely Related Answers

Export records from JTable to Excel_Java

Comment

public void toExcel(JTable table, File file){
    try{
        TableModel model = table.getModel();
        FileWriter excel = new FileWriter(file);

        for(int i = 0; i < model.getColumnCount(); i++){
            excel.write(model.getColumnName(i) + "\t");
        }

        excel.write("\n");

        for(int i=0; i< model.getRowCount(); i++) {
            for(int j=0; j < model.getColumnCount(); j++) {
                excel.write(model.getValueAt(i,j).toString()+"\t");
            }
            excel.write("\n");
        }

        excel.close();

    }catch(IOException e){ System.out.println(e); }
}

Popularity 6/10 Helpfulness 3/10 Language cpp

Source: www.codegrepper.com

Tags: c++ export jtable records

Link to this answer
Share Copy Link

Contributed on Sep 03 2022

Jeffrey Obada, CRM

0 Answers Avg Quality 2/10

datatable export to excel

Comment

using OfficeOpenXml;

// Assuming you have a DataTable called "dataTable"
// Create a new Excel package
using (ExcelPackage excelPackage = new ExcelPackage())
{
    // Create a new sheet in the Excel package
    ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet1");

    // Write the column headers
    for (int i = 0; i < dataTable.Columns.Count; i++)
    {
        worksheet.Cells[1, i + 1].Value = dataTable.Columns[i].ColumnName;
    }

    // Write the data rows
    for (int row = 0; row < dataTable.Rows.Count; row++)
    {
        for (int column = 0; column < dataTable.Columns.Count; column++)
        {
            worksheet.Cells[row + 2, column + 1].Value = dataTable.Rows[row][column];
        }
    }

    // Save the Excel package to a file
    excelPackage.SaveAs(new FileInfo("data.xlsx"));
}

Popularity 9/10 Helpfulness 2/10 Language csharp

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 11 2023

YOU.com

0 Answers Avg Quality 2/10

How To Export Records From JTable To MS Excel

Contents

More Related Answers

How To Export Records From JTable To MS Excel

Closely Related Answers

Export records from JTable to Excel_Java

datatable export to excel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.