本文介绍了从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(); }更多推荐
从Excel中的Java获取文本框的值
发布评论