Article:		Opening Microsoft File Formats to Java
Subject:		reading and writing excel and database entries and writing it into new excelsheet
Date:		2007-03-05 22:47:57
From:		bhavna13
i m facing a problem while i m creating an excelsheet.as i have to create a new excel sheet and store the data by reading from other excelsheet or from a database. please help me to solve out this problem bhavna

Showing messages 1 through 2 of 2.

• reading and writing excel and database entries and writing it into new excelsheet
  2007-11-12 00:46:45  kumar12345 [View]
  
  
  how i will convert the excel sheet to PDF format with help of apache POI package in servlet and jsp in java. and what is the source code for this?

• reading and writing excel and database entries and writing it into new excelsheet
  2007-08-31 03:15:41  Rupali. [View]
  
  
  Hi Bhavna,
  I need to look into the kind of code or entries you have to fetch form data base. Well till then, i can give you the general code for the same. It may be like,,
  HSSFWorkbook workbook = new HSSFWorkbook();
  HSSFSheet sheet = workbook.createSheet("Report");
  
  FileOutputStream fileOutputStream = new FileOutputStream(exportFile);
  Iterator rowIterator = tabularRows.iterator();
  int rowCount = 0;
  while (rowIterator.hasNext()) {
  HSSFRow row = sheet.createRow(rowCount++);
  String rowToExport = (String) rowIterator.next();
  List<String> columnsToExportForRow = tokenizeString(rowToExport,
  your string from database);
  int cellCount = 0;
  if (columnsToExportForRow != null && columnsToExportForRow.size() > 0) {
  Iterator columnIterator = columnsToExportForRow.iterator();
  // System.out.println("\n");
  while (columnIterator.hasNext()) {
  HSSFCell cell = row.createCell((short) cellCount++);
  cell.setCellType(1); //store numbers as text
  cell.setCellValue((String) columnIterator.next());
  if (rowCount == 1) {
  /**
  * this is the header row. so decorate it
  */
  HSSFFont font = workbook.createFont();
  font.setFontHeightInPoints((short) 12);
  font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
  HSSFCellStyle style = workbook.createCellStyle();
  style.setFillBackgroundColor(HSSFColor.BLUE_GREY.index);
  style.setFont(font);
  cell.setCellStyle(style);
  }
  }// end of while (columnIterator.hasNext())
  }// end of if(columnsToExportForRow!=null && ...
  }// end of while(listIterator.hasNext())
  try {
  workbook.write(fileOutputStream);
  if (fileOutputStream != null) {
  fileOutputStream.close();
  }
  } catch (IOException e) {
  responseString = "The report could not be generated due to an internal error.";
  }
  }// end of if(tabularRows!=null && tabularRows.size()>0)
  } catch (FileNotFoundException e) {
  responseString = "The report could not be generated due to an internal error.";
  }
  return responseString;
  }
  
  
  Try this code out and let me know if anything more you need to know on it.
  Thanks.
  Rupali