package PackExcel3;
import java.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import javax.*;
import javax.swing.*;
import javax.swing.event.*;
import jxl.*;
import jxl.LabelCell; //Para leer de la celda, no es necesario hasta que no se lea del excel.
import jxl.Workbook.*;
import jxl.write.*;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.WritableWorkbook.*;
import jxl.write.WritableSheet.*;;
WritableWorkbook libro;
WritableSheet hoja;
public interfaz(){
super("Ejem Excel 3");
definirventana();
definirelementos();
this.setVisible(true);
this.setSize(300, 200);
this.setResizable(false);
this.
setDefaultCloseOperation(JFrame.
EXIT_ON_CLOSE); }
private void definirventana(){
constraint.gridx = 0;
constraint.gridy = 0;
constraint.gridwidth = 1;
constraint.gridheight = 1;
constraint.weightx = 1.0;
constraint.weighty = 1.0;
this.getContentPane().add(jbtn_comenzar, constraint);
constraint.gridx = 1;
constraint.gridy = 0;
constraint.gridwidth = 1;
constraint.gridheight = 1;
constraint.weightx = 1.0;
constraint.weighty = 1.0;
this.getContentPane().add(jlbl_inf, constraint);
constraint.gridx = 0;
constraint.gridy = 1;
constraint.gridwidth = 1;
constraint.gridheight = 1;
constraint.weightx = 1.0;
constraint.weighty = 1.0;
this.getContentPane().add(jbtn_comenzar1, constraint);
constraint.gridx = 1;
constraint.gridy = 1;
constraint.gridwidth = 1;
constraint.gridheight = 1;
constraint.weightx = 1.0;
constraint.weighty = 1.0;
this.getContentPane().add(jlbl_inf1, constraint);
}
private void definirelementos(){
this.jbtn_comenzar.addActionListener(this);
this.jbtn_comenzar1.addActionListener(this);
}
if(ae.getSource() == jbtn_comenzar){
jlbl_inf.setText("Procesando 0");
crearWorkbook();
generar();
}
if(ae.getSource() == jbtn_comenzar1){
jlbl_inf1.setText("Procesando 1");
crearWorkbook();
generar1();
}
}
private void crearWorkbook(){
try{
libro
= Workbook.
createWorkbook(new File("Ejem3.xls")); hoja = libro.createSheet("HEJEM", 0);
}
}
private void generar(){
try{
hoja.addCell(label);
for(int i = 1; i < 10; i++){
hoja.addCell(numero);
}
libro.write();
libro.close();
jlbl_inf.setText("Fin ejecución");
}
}
private void generar1(){
try{
for(int a = 0; a < 10; a++){
hoja.addCell(label);
for(int i = 1; i < 50000; i++){
hoja.addCell(numero);
}
}
libro.write();
libro.close();
jlbl_inf1.setText("Fin ejecución");
}
}
}