从Excel中的Java获取文本框的值 [英] Obtain textbox value from Excel in Java

问题描述

我有一个Excel文件，我需要从Excel文件里面读取文本框的值。

I have an Excel file and I need to read a value from a textbox inside that Excel file.

我使用的 org.apache.poi 的图书馆，我试图获得通过以下方式值：

I am using org.apache.poi library and I tried to obtain the value in the following way:

   List<HSSFObjectData> obj=workbook.getAllEmbeddedObjects();
   for(int i=0;i<obj.size();i++)
   {           
       HSSFTextbox t=(HSSFTextbox)obj.get(i);
   }

偏偏我不能投HSSFTextbox到HSSFObjectData元素。

Unfortunetly I couldn't cast HSSFTextbox to a HSSFObjectData element.

有谁知道怎么能这样做？

Does anyone know how could this be done?

推荐答案

也许你可以这样做：

    try {
        InputStream input = new FileInputStream("qa-textbox.xls");
        POIFSFileSystem fs = new POIFSFileSystem(input);
        HSSFWorkbook wb = new HSSFWorkbook(fs);
        HSSFSheet sheet = wb.getSheetAt(0);
        HSSFPatriarch pat = sheet.getDrawingPatriarch();
        List children = pat.getChildren();

        Iterator it = children.iterator(); 
        while(it.hasNext()) {           
            HSSFShape shape = (HSSFShape)it.next();
            if (shape instanceof HSSFTextbox){
              HSSFTextbox textbox = (HSSFTextbox)shape;
              HSSFRichTextString richString = textbox.getString();
              String str = richString.getString();
              System.out.println("String: " + str);
              System.out.println("String length: " + str.length());
            }
        }  
    } catch (IOException ex) {
        ex.printStackTrace();
    }

这篇关于从Excel中的Java获取文本框的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！