Problema ao ler arquivo Excel

Assuntos Gerais
#1

Alguem pode me ajudar?

[code]
HSSFWorkbook wb;
HSSFSheet sheet;
try{

        int linha =0;
        int coluna =0;

POIFSFileSystem fsRPD = new POIFSFileSystem(new FileInputStream(“C:\teste.xls”));
HSSFWorkbook wkRPD = new HSSFWorkbook(fsRPD);
sheet = wkRPD.getSheetAt(0);

        HSSFRow row = sheet.getRow(linha);
        HSSFCell cell = row.getCell((short)coluna);
        teste=cell.getStringCellValue();
        JOptionPane.showMessageDialog(null,teste);


    }catch (Exception e){
    e.printStackTrace();
    JOptionPane.showMessageDialog(null, e.getMessage());
    }[/code]

Erro:

] Unknown Ptg 60 (96)for named range: gsm
[WARNING] Unknown Ptg 60 (96)for named range: gsm
[WARNING] Unknown Ptg 60 (96)for named range: gsm
[WARNING] Unknown Ptg 60 (96)for named range: gsm
[WARNING] Unknown Ptg 60 (96)for named range: gsm
[WARNING] Unknown Ptg 60 (96)for named range: gsm
[WARNING] Unknown Ptg 60 (96)for named range: gsm
[WARNING] Unknown Ptg 60 (96)for named range: HTML_Control
[WARNING] Unknown Ptg 60 (96)for named range: HTML_Control
[WARNING] Unknown Ptg 60 (96)for named range: HTML_Control
[WARNING] Unknown Ptg 60 (96)for named range: HTML_Control
[WARNING] Unknown Ptg 60 (96)for named range: HTML_Control
[WARNING] Unknown Ptg 60 (96)for named range: HTML_Control
[WARNING] Unknown Ptg 60 (96)for named range: HTML_Control
[WARNING] Unknown Ptg 60 (96)for named range: STS1
[WARNING] Unknown Ptg 60 (96)for named range: STS1
[WARNING] Unknown Ptg 60 (96)for named range: STS1
[WARNING] Unknown Ptg 60 (96)for named range: STS1
[WARNING] Unknown Ptg 60 (96)for named range: STS1
[WARNING] Unknown Ptg 60 (96)for named range: STS1
[WARNING] Unknown Ptg 60 (96)for named range: STS1
Exception in thread “AWT-EventQueue-0” java.lang.OutOfMemoryError: Java heap space
at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:275)
at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:160)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:183)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:152)
at testeexcel.teste.jButton1ActionPerformed(teste.java:107)
at testeexcel.teste.access$000(teste.java:32)
at testeexcel.teste$1.actionPerformed(teste.java:57)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6263)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3255)
at java.awt.Component.processEvent(Component.java:6028)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)

#2 
POIFSFileSystem fsRPD = new POIFSFileSystem(new FileInputStream("C:\teste.xls"));

No String “C:\teste.xls” tenta botar “C:\teste.xls” para escapar o backslash, senão o compilador vai reconhecer como o comando “\t”.

Testa ai e me diz se funcionou…

Abraço

#3

Fiz o que vc pediu e funcionou com uma planilha de teste que Eu fiz, porém a planilha que realmente que tenho que ler, que não foi eu que fiz e tem mais de 10 Mb da o mesmo erro.

#4

Cara então não tenho idéia, talvez a formatação do conteudo do arquivo seja diferente…

#5

Consegui ajustar a memoria da JVM.

Agora tenho outra duvida…
tenho uma planilha excel de mais de 3000 linhas, preciso fazer um filtro na planilha e saber a linha e coluna desse filtro na planilha.

Tem ideia?

#6