DMottab.blogspot.com

POI HSSFComment: Una manera simple de añadir un comentario en una celda de excel usando el metodo cell.setCellComment(). public class ExcelTools { public static void main(String[] args){ //escribirExcel(); //leerExcel(); validarValoresDuplicadosLista(); System.out.println("Ejemplo Finalizado."); } public static void escribirExcel(){ try{ //Se crea el libro Excel HSSFWorkbook wb = new HSSFWorkbook(); //Se crea una nueva hoja dentro del libro HSSFSheet sheet = wb.createSheet("HojaEjemplo"); //Se crea una fila dentro de la hoja HSSFRow row = sheet.createRow((short)0); HSSFPatriarch patr = sheet.createDrawingPatriarch(); //Creamos celdas de varios tipos row.createCell((short)0).setCellValue(1); row.createCell((short)1).setCellValue(1.2); row.createCell((short)2).setCellValue("ejemplo...

FORMULAS CON JEXCEL p ublic class JExcelTesting { //private WritableWorkbook workbook = null; public JExcelTesting() throws IOException { // TODO Auto-generated constructor stub WritableWorkbook workbook = Workbook.createWorkbook(new File("C:/Testing.xls")); WorkbookSettings wbs=new WorkbookSettings(); wbs.setCellValidationDisabled(true); wbs.setDrawingsDisabled(true); wbs.setFormulaAdjust(false); wbs.setMergedCellChecking(false); wbs.setRationalization(false); wbs.setSuppressWarnings(true); wbs.setUseTemporaryFileDuringWrite(false); wbs.setAutoFilterDisabled(true); wbs.setArrayGrowSize(20*1024*1024); workbook.createSheet("Testing Page", 1); WritableSheet sheet = workbook.getSheet("Testing Page"); WritableFont wf = new WritableFont(WritableFont.ARIAL, 8); WritableCellFormat wcf = new WritableCellFormat(wf); CellView cv = new Cel...

Escribir un Excel con JExcel Liberias que utiliza import java.io.File; import java.util.Date; import jxl.*; import jxl.write.*; //Declaro la variable WritableWorkbook workbook = Workbook.createWorkbook(new File("output.xls")); //Creo una hoja en el workbook generado WritableSheet sheet = workbook.createSheet("First Sheet", 0); //Ahora solo queda agregar información a las celdas. Label label = new Label(0, 2, "A label record"); sheet.addCell(label); Number number = new Number(3, 4, 3.1459); sheet.addCell(number); // Luego que todas las celdas estan cargadas guardamos el workbook workbook.write(); workbook.close(); Formateo de datos Formato en celdas WritableFont arial10font = new WritableFont(WritableFont.ARIAL, 10); WritableCellFormat arial10format = new WritableCellFormat (arial10font); Label label2 = new Label(1,0, "Arial 10 point label", arial10format); sheet.addCell(label2); Formatear numeros WritableCellFormat integerFormat = new WritableCel...