Hi Team, I have an excel which has multiple rows and each row can have multiple images associated with that , which are postioned on a specific cells of that particular row.I know while we are positioning a image on top of a cell, that is not associated with the cell and it is actually floting the sheet of the workbook.My target is to read those images and at the same time mapping that image with particular cell using apche POI. I have two questions actually: 1. Is there any way to associate an image with a excel cell so …

Member Avatar
+1 forum 0

hi.. I'm trying to read a .docx file using apache poi api methods.. But i'm facing a few problems.. Can anyone suggest me the changes to be made in this code?? package apiole; import java.io.*; import org.apache.poi.xwpf.extractor.XWPFWordExtractor; public class Apiole { public static void main(String[] args) throws IOException { File f = new File("D:\\vishal\\java_projects\\doc.docx"); InputStream in = new FileInputStream(f); String test = extractText(in); System.out.print("text: "+test); } public static String extractText(InputStream in) { XWPFDocument doc = new XWPFDocument(in); XWPFWordExtractor ex = new XWPFWordExtractor(doc); String text = ex.getText(); return text; } }

Member Avatar
Member Avatar
+0 forum 4

Hi, I am trying to add content to an excel sheet using the below code. However, when I open the excel sheet, nothing is added. Please advice. public class StepNoToExcel { HSSFWorkbook wb = null; String fileName = "C:\\StepNoForEvidences.xls"; File file = null; StepNoToExcel() { file = new File(fileName); if(!file.exists()) { try { file.createNewFile(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } wb = new HSSFWorkbook(); wb.createSheet("Step Number"); } public void addToWorkBook(String step) throws IOException { System.out.println(step); HSSFSheet sheet = wb.getSheetAt(wb.getActiveSheetIndex()); for(Row row : sheet) { Cell cell = row.createCell(0); if(cell.equals(Cell.CELL_TYPE_BLANK)) { cell.setCellValue(step); } } …

Member Avatar
Member Avatar
+0 forum 1

Hello Friends... I am new to jsp and i need to edit a .doc file present in a server using jsp! i tried googling and i got to know about "apache poi". this is working great for opening a doc file and also for writing a doc file but my problem is i have to edit a doc file and i have to save that file with same name! but i have two codes one to display doc file in textarea and another one to write one doc file to another one now i need both at one place that …

Member Avatar
Member Avatar
+0 forum 3

Microsoft it was disclosed today will become a sponsor of the Apache Software Foundation, forking over US$100,000 a year for theprivilege . In return, Redmond will gain access to the [URL=http://poi.apache.org/]Apache POI[/URL] project, a Java port of file formats of Microsoft's Office suite of applications. Based on Microsoft's history, I have my suspicions about the company's motives. Yes, it's been exhibiting a more open stance of late, but the sting of its exclusionary practices and once-closed file formats remains. But Microsoft has been moving toward opening its formats recently, and I'm willing to believe the move is yet another effort …

Member Avatar
Member Avatar
+0 forum 3

The End.