poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniele Artini <art...@tiscali.it>
Subject Re: wrong Cell Value, help !
Date Wed, 05 Oct 2005 16:40:33 GMT
I'm new to the object programming /Java,
i need to write to an excel file the data in a JTable,
but i' don't understand where is the bug in my program file
TestExcel.java, can you help me to find it ? please ?

what exactly is "sheetviewer" and where can i download ?

thank you for your help.

acoliver@apache.org wrote:

> While it doesn't allow you to save, you do realize we have a
> renderer/table thing in scratchpad called "sheetviewer"...don't you?
>
> Daniele Artini wrote:
>
>> Hi,
>> with the following simple program,inside the test.xls file generated
>> the values of the all cell are repeated many times !
>> what's worng ?
>>
>> please help me
>>
>>
>> TestExcel.java:
>>
>> import java.awt.Dimension;
>> import java.awt.GridLayout;
>> import java.awt.event.ActionEvent;
>> import java.awt.event.ActionListener;
>> import java.awt.event.MouseAdapter;
>> import java.awt.event.MouseEvent;
>> import java.io.File;
>> import java.io.FileOutputStream;
>> import java.io.IOException;
>> import java.util.Calendar;
>>
>> import javax.swing.JButton;
>> import javax.swing.JFrame;
>> import javax.swing.JPanel;
>> import javax.swing.JScrollPane;
>> import javax.swing.JTable;
>>
>> import org.apache.poi.hssf.usermodel.HSSFCell;
>> import org.apache.poi.hssf.usermodel.HSSFCellStyle;
>> import org.apache.poi.hssf.usermodel.HSSFFont;
>> import org.apache.poi.hssf.usermodel.HSSFRow;
>> import org.apache.poi.hssf.usermodel.HSSFSheet;
>> import org.apache.poi.hssf.usermodel.HSSFWorkbook;
>>
>>
>>
>>
>> public class TestExcel extends JPanel implements ActionListener {
>>     private boolean DEBUG = false;
>>     private JTable table;
>>        private JButton      fileButton=new JButton("FILE");
>>        public TestExcel() {
>>         super(new GridLayout(1,0));
>>
>>         String[] columnNames = {"First Name",
>>                                 "Last Name",
>>                                 "Sport",
>>                                 "# of Years",
>>                                 "Vegetarian"};
>>
>>         Object[][] data = {
>>             {"Mary", "Campione",
>>              "Snowboarding", new Integer(5), new Boolean(false)},
>>             {"Alison", "Huml",
>>              "Rowing", new Integer(3), new Boolean(true)},
>>             {"Kathy", "Walrath",
>>              "Knitting", new Integer(2), new Boolean(false)},
>>             {"Sharon", "Zakhour",
>>              "Speed reading", new Integer(20), new Boolean(true)},
>>             {"Philip", "Milne",
>>              "Pool", new Integer(10), new Boolean(false)}
>>         };
>>
>>         table = new JTable(data, columnNames);
>>
>>         table.setPreferredScrollableViewportSize(new Dimension(500,
>> 70));
>>         this.fileButton.setActionCommand("FILE");
>>         this.fileButton.addActionListener(this);
>>         if (DEBUG) {
>>             table.addMouseListener(new MouseAdapter() {
>>                 public void mouseClicked(MouseEvent e) {
>>                     printDebugData(table);
>>                 }
>>             });
>>         }
>>
>>         //Create the scroll pane and add the table to it.
>>         JScrollPane scrollPane = new JScrollPane(table);
>>         this.add(this.fileButton);
>>         //Add the scroll pane to this panel.
>>         add(scrollPane);
>>     }
>>
>>     private void printDebugData(JTable table) {
>>         int numRows = table.getRowCount();
>>         int numCols = table.getColumnCount();
>>         javax.swing.table.TableModel model = table.getModel();
>>
>>         System.out.println("Value of data: ");
>>         for (int i=0; i < numRows; i++) {
>>             System.out.print("    row " + i + ":");
>>             for (int j=0; j < numCols; j++) {
>>                 System.out.print("  " + model.getValueAt(i, j));
>>             }
>>             System.out.println();
>>         }
>>         System.out.println("--------------------------");
>>     }
>>
>>     /**
>>      * Create the GUI and show it.  For thread safety,
>>      * this method should be invoked from the
>>      * event-dispatching thread.
>>      */
>>
>>     public static void main(String[] args) {
>>         //Schedule a job for the event-dispatching thread:
>>         //creating and showing this application's GUI.
>>        //Make sure we have nice window decorations.
>>        JFrame.setDefaultLookAndFeelDecorated(true);
>>
>>        //Create and set up the window.
>>        JFrame frame = new JFrame("SimpleTableDemo");
>>        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
>>
>>        //Create and set up the content pane.
>>        TestExcel newContentPane = new TestExcel();
>>        newContentPane.setOpaque(true); //content panes must be opaque
>>        frame.setContentPane(newContentPane);
>>
>>        //Display the window.
>>        frame.pack();
>>        frame.setVisible(true);
>>     }
>>     public void actionPerformed(ActionEvent e) {
>>        if (e.getActionCommand() == "FILE") {
>>           new ExcelSaveJTable(this.table);
>>                         }
>>    }
>>        public class ExcelSaveJTable {
>>        private  int MAX_ROW=65000;
>>        private  short FATTORE_CONV_WIDTH=60;
>>        private HSSFSheet foglioExcel;
>>        private HSSFWorkbook documentoExcel;
>>        private int colonne;
>>        private int righeTab;
>>        private JTable tabellaDati;
>>        private HSSFCellStyle stileCella,stileCellaInt;
>>              /**
>>         *
>>         * @param prmJTable JTable da cui leggere i dati
>>         *
>>         */
>>        public ExcelSaveJTable(JTable prmTabella){
>>
>>           documentoExcel = new HSSFWorkbook();
>>           foglioExcel = documentoExcel.createSheet("test");
>>           File FileOutput=new File("test.xls");
>>                   
>> righeTab=Math.min(this.MAX_ROW,prmTabella.getRowCount());
>>           colonne=prmTabella.getColumnCount();
>>           tabellaDati=prmTabella;
>>
>>           stileCella = documentoExcel.createCellStyle();
>>         
>> stileCella.setAlignment(HSSFCellStyle.ALIGN_FILL);                
>>                    stileCellaInt=documentoExcel.createCellStyle();
>>         
>> stileCellaInt.setAlignment(HSSFCellStyle.ALIGN_FILL);                
>>           scriviIntestazione();
>>
>>           int cnt=1;    
>>           while (cnt<=righeTab){
>>              scriviRigoDati(cnt);
>>              cnt++;
>>           }
>>                    //scrittura del file
>>           try{
>>             FileOutputStream fileExcelOut = new
>> FileOutputStream(FileOutput);
>>             documentoExcel.write(fileExcelOut);
>>             fileExcelOut.close();             }catch (IOException e) {
>>             System.out.println("Il file non e' stato scritto !
>> "+e.getMessage());
>>           }
>>                          }
>>
>>        private void scriviIntestazione(){
>>           //scrivo l'intestazione delle colonne
>>           HSSFRow rigo = foglioExcel.createRow(0);              
>> short i;
>>           HSSFFont fontIntestazione = documentoExcel.createFont();
>>           fontIntestazione.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
>>           stileCellaInt.setFont(fontIntestazione);
>>           for (i=0; i<colonne;i++){                   
>> foglioExcel.setColumnWidth((short)(i),(short)(tabellaDati.getColumnModel().getColumn(i).getPreferredWidth()*FATTORE_CONV_WIDTH));
>>
>>              HSSFCell cellaIntestazione = rigo.createCell((short)i);
>>              String str=tabellaDati.getColumnName(i);
>>              cellaIntestazione.setCellValue(str);
>>              stileCellaInt.setBorderBottom(HSSFCellStyle.BORDER_THIN);
>>              stileCellaInt.setBorderTop(HSSFCellStyle.BORDER_THIN);
>>              stileCellaInt.setBorderLeft(HSSFCellStyle.BORDER_THIN);
>>              stileCellaInt.setBorderRight(HSSFCellStyle.BORDER_THIN);
>>              cellaIntestazione.setCellStyle(stileCellaInt);
>>           }            }
>>              private void scriviRigoDati(int cnt){
>>           HSSFRow rigoDati = foglioExcel.createRow(cnt);
>>           int i;
>>           for (i=0; i<colonne;i++){
>>              HSSFCell cella = rigoDati.createCell((short)i);
>>                          Object datoCellaJTable
>> =tabellaDati.getValueAt(cnt-1,i);                           if
>> (datoCellaJTable instanceof Boolean){                              
>> cella.setCellValue(((Boolean)datoCellaJTable).booleanValue());
>>              } else if (datoCellaJTable instanceof Calendar){
>>                
>> cella.setCellValue((Calendar)datoCellaJTable);            
>>              } else if (datoCellaJTable instanceof Double){
>>               
>> cella.setCellValue(((Double)datoCellaJTable).doubleValue());            
>>              } else if (datoCellaJTable instanceof Short){
>>               
>> cella.setCellValue(((Short)datoCellaJTable).shortValue());            
>>              } else if (datoCellaJTable instanceof Integer){
>>               
>> cella.setCellValue(((Integer)datoCellaJTable).intValue());            
>>              } else { String valstr=(String)datoCellaJTable.toString();
>>                      if ((!(valstr==null)) && (valstr.length()>0)){
>>                         cella.setCellValue(valstr);
>>                      } else {
>>                         cella.setCellValue("");
>>                      }                           }
>>              cella.setCellStyle(stileCella);
>>           }            }
>>     }
>> }
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>
>>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message