
my reqment is i have to parse the excel and i need to print the data in the table by using swing jtable or else ....can u give the solution please....

import java.io.*;
import java.awt.*;
import java.util.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.table.*;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
public class ExcelToJtable {
public static void main(String[] args) {
Vector headers = new Vector();
Vector data = new Vector();
File file = new File("c:/data.xls");
try {
Workbook workbook = Workbook.getWorkbook(file);
Sheet sheet = workbook.getSheet(0);
headers.clear();
for (int i = 0; i < sheet.getColumns(); i++) {
Cell cell1 = sheet.getCell(i, 0);
headers.add(cell1.getContents());
}
data.clear();
for (int j = 1; j < sheet.getRows(); j++) {
Vector d = new Vector();
for (int i = 0; i < sheet.getColumns(); i++) {
Cell cell = sheet.getCell(i, j);
d.add(cell.getContents());
}
d.add("\n");
data.add(d);
}
}
catch (Exception e) {
e.printStackTrace();
}
JTable table = new JTable();
DefaultTableModel model = new DefaultTableModel(data,headers);
int tableWidth = model.getColumnCount()* 150;
int tableHeight = model.getRowCount()* 25;
table.setPreferredSize(new Dimension(tableWidth, tableHeight));
table.setModel(model);
table.setAutoCreateRowSorter(true);
model = new DefaultTableModel(data, headers);
table.setModel(model);
table.setEnabled(false);
table.setRowHeight(25);
table.setRowMargin(4);
JScrollPane scroll = new JScrollPane(table);
JFrame f=new JFrame();
f.add(scroll);
f.setSize(600, 600);
f.setVisible(true);
}
}

Thanks buddyyy.... can i edit the rows........... thanks in advance............
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.