从Excel中的Java获取文本框的值

本文介绍了从Excel中的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(); }