java 获取文本框值_在Java中从Excel获取文本框值

这将有助于阅读您的Excel表格

HSSFWorkbook workbook = new HSSFWorkbook(fs);

for (HSSFObjectData obj : workbook.getAllEmbeddedObjects()) {

//the OLE2 Class Name of the object

String oleName = obj.getOLE2ClassName();

if (oleName.equals("Worksheet")) {

DirectoryNode dn = (DirectoryNode) obj.getDirectory();

HSSFWorkbook embeddedWorkbook = new HSSFWorkbook(dn, fs, false);

//System.out.println(entry.getName() + ": " + embeddedWorkbook.getNumberOfSheets());

readSheetElements(embeddedWorkbook);

} else if (oleName.equals("Document")) {

DirectoryNode dn = (DirectoryNode) obj.getDirectory();

HWPFDocument embeddedWordDocument = new HWPFDocument(dn, fs);

//System.out.println(entry.getName() + ": " + embeddedWordDocument.getRange().text());

} else if (oleName.equals("Presentation")) {

DirectoryNode dn = (DirectoryNode) obj.getDirectory();

SlideShow embeddedPowerPointDocument = new SlideShow(new HSLFSlideShow(dn, fs));

//System.out.println(entry.getName() + ": " + embeddedPowerPointDocument.getSlides().length);

} else {

if(obj.hasDirectoryEntry()){

// The DirectoryEntry is a DocumentNode. Examine its entries to find out what it is

DirectoryNode dn = (DirectoryNode) obj.getDirectory();

for (Iterator entries = dn.getEntries(); entries.hasNext();) {

Entry entry = (Entry) entries.next();

//System.out.println(oleName + "." + entry.getName());

}

} else {

// There is no DirectoryEntry

// Recover the object's data from the HSSFObjectData instance.

byte[] objectData = obj.getObjectData();

}

}

}

public void readSheetElements(HSSFWorkbook embeddedWorkbook) {

HSSFSheet hSSFSheet = embeddedWorkbook.getSheet(0);

java.util.Iterator rowItr = hSSFSheet .rowIterator() ;

while(rowItr .hasNext()) {

java.util.Iterator cellItr = rowItr.next().cellIterator() ;

// read cell value from each cell

}