Examples of jxl.write.WritableSheet

jxl.write.WritableSheet
Interface for a worksheet that may be modified. The most important modification for a sheet is to have cells added to it

    try {
      WritableWorkbook workbook = null;
      WorkbookSettings ws = new WorkbookSettings();
      ws.setLocale(new Locale("en", "EN"));
      workbook = Workbook.createWorkbook(new File(_url), ws);
      WritableSheet s = workbook.createSheet("test", 0);
      WritableCellFormat cf1 = new WritableCellFormat(
          jxl.write.DateFormats.FORMAT2);


      jxl.write.DateTime dt = new jxl.write.DateTime(0, 1, new Date(),
          cf1);


      s.addCell(dt);


      workbook.write();
      workbook.close();
    } catch (Exception e) {
      e.printStackTrace();

View Full Code Here




  private void saveSheets( BaseSpreadsheet _wb, WritableWorkbook _xwb ) throws JXLException, SpreadsheetException
  {
    for (final BaseSheet s : _wb.getSheetList()) {
      final WritableSheet xs = _xwb.createSheet( s.getName(), s.getSheetIndex() );
      saveSheet( s, _xwb, xs );
    }
  }

View Full Code Here

    ByteArrayOutputStream output = new ByteArrayOutputStream();
    
    try 
    {
      WritableWorkbook wb = Workbook.createWorkbook(output);
      WritableSheet sheet = wb.createSheet("Foglio 1", 0);
      
      WritableFont wfBold = new WritableFont(WritableFont.COURIER, 8, WritableFont.BOLD);
      WritableCellFormat cfBold = new WritableCellFormat(wfBold);
      
      WritableFont wfNormal = new WritableFont(WritableFont.COURIER, 8, WritableFont.NO_BOLD);
      WritableCellFormat cfNormal = new WritableCellFormat(wfNormal);
      WritableCellFormat cfRight = new WritableCellFormat(wfNormal);
      cfRight.setAlignment(Alignment.RIGHT);
      
      WritableCellFormat cfRightBold = new WritableCellFormat(wfBold);
      cfRightBold.setAlignment(Alignment.RIGHT);
      
      DisplayFormat df = new NumberFormat("###,##0.00");
      WritableCellFormat cfNumber = new WritableCellFormat(wfNormal, df);
      cfNumber.setAlignment(Alignment.RIGHT);
      
      WritableCellFormat cfNumberBold = new WritableCellFormat(wfBold, df);
      cfNumberBold.setAlignment(Alignment.RIGHT);
      
      DisplayFormat df_ = new NumberFormat("########0");
      WritableCellFormat cfIntNumber = new WritableCellFormat(wfNormal, df_);
      cfIntNumber.setAlignment(Alignment.RIGHT);
      
      WritableCellFormat cfIntRightBold = new WritableCellFormat(wfBold, df_);
      cfIntRightBold.setAlignment(Alignment.RIGHT);
      
      WritableCellFormat cfIntRight = new WritableCellFormat(wfNormal, df_);
      cfIntRight.setAlignment(Alignment.RIGHT);
      
      Label cellValue;
      Number cellNumber;
      int col = 0;
      cellValue = new Label(col, 2, "", cfBold);
      sheet.setColumnView(col, 10);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Gruppo", cfBold);
      sheet.setColumnView(col, 10);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Mastro", cfBold);
      sheet.setColumnView(col, 10);
      sheet.addCell(cellValue);
      if(visible) 
      {
        col++;
        cellValue = new Label(col, 2, "Conto", cfBold);
        sheet.setColumnView(col, 10);
        sheet.addCell(cellValue);
      }
      col++;
      cellValue = new Label(col, 2, "Descrizione", cfBold);
      sheet.setColumnView(col, 40);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Dare", cfBold);
      sheet.setColumnView(col, 20);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Avere", cfBold);
      sheet.setColumnView(col, 20);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Dare extr.", cfBold);
      sheet.setColumnView(col, 20);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Avere Extr.", cfBold);
      sheet.setColumnView(col, 20);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Saldo Dare", cfBold);
      sheet.setColumnView(col, 20);
      sheet.addCell(cellValue);
      col++;
      cellValue = new Label(col, 2, "Saldo Avere", cfBold);
      sheet.setColumnView(col, 20);
      sheet.addCell(cellValue);
      
      int riga = 2;
      
      for (RowBilancio bilancio : listaBilancio) 
      {
        riga++;
        col = 0;
        if((StringUtility.checkNull(bilancio.getTipoAttivita())).equals("&#160;")) {
          cellValue = new Label(col, riga, "", cfNormal);
        } else {
          cellValue = new Label(col, riga, StringUtility.checkNull(bilancio.getTipoAttivita()), cfBold);
        }
        sheet.addCell(cellValue);
        
        col++;
        if((StringUtility.checkNull(bilancio.getGruppo())).equals("&#160;")) {
          cellValue = new Label(col, riga, "", cfIntNumber);
          sheet.addCell(cellValue);
        } else {
          cellNumber = new Number(col, riga, Integer.parseInt((StringUtility.checkNull(bilancio.getGruppo()))), cfIntRightBold);
          sheet.addCell(cellNumber);
        }
        
        col++;
        if((StringUtility.checkNull(bilancio.getMastro())).equals("&#160;")) {
          cellValue = new Label(col, riga, "", cfIntNumber);
          sheet.addCell(cellValue);
        } else {
          cellNumber = new Number(col, riga, Integer.parseInt((StringUtility.checkNull(bilancio.getMastro()))), cfIntRight);
          sheet.addCell(cellNumber);
        }
        
        if(visible) 
        {
          col++;
          if((StringUtility.checkNull(bilancio.getConto())).equals("&#160;")) {
            cellValue = new Label(col, riga, "", cfIntNumber);
            sheet.addCell(cellValue);
          } else {
            cellNumber = new Number(col, riga, Integer.parseInt((StringUtility.checkNull(bilancio.getConto()))), cfIntRight);
            sheet.addCell(cellNumber);
          }
        }
        
        col++;
        if((StringUtility.checkNull(bilancio.getDescrizione())).equals("&#160;")) {
          cellValue = new Label(col, riga, "", cfNormal);
        } else {
          
          if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
            || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
            cellValue = new Label(col, riga, StringUtility.checkNull(bilancio.getDescrizione()), cfBold);
          } else {
            cellValue = new Label(col, riga, StringUtility.checkNull(bilancio.getDescrizione()), cfNormal);
          }
        }
        sheet.addCell(cellValue);
        
        col++;
        
        if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
          || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getDare()), cfNumberBold);
        } else {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getDare()), cfNumber);
        }
        sheet.addCell(cellNumber);
        
        col++;
        if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
          || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getAvere()), cfNumberBold);
        } else {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getAvere()), cfNumber);
        }
        sheet.addCell(cellNumber);
        
        col++;
        if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
          || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getDareExtr()), cfNumberBold);
        } else {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getDareExtr()), cfNumber);
        }
        sheet.addCell(cellNumber);
        
        col++;
        if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
          || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getAvereExtr()), cfNumberBold);
        } else {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getAvereExtr()), cfNumber);
        }
        sheet.addCell(cellNumber);
        
        col++;
        if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
          || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getDareSaldo()), cfNumberBold);
        } else {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getDareSaldo()), cfNumber);
        }
        sheet.addCell(cellNumber);
        
        col++;
        if(NumberUtils.checkNull(bilancio.getTipoRiga()) == 0 || NumberUtils.checkNull(bilancio.getTipoRiga()) == 1 
          || NumberUtils.checkNull(bilancio.getTipoRiga()) == 2) {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getAvereSaldo()), cfNumberBold);
        } else {
          cellNumber = new Number(col, riga, NumberUtils.checkNull(bilancio.getAvereSaldo()), cfNumber);
        }
        sheet.addCell(cellNumber);
      }
      
      wb.write();
      wb.close();

View Full Code Here

            log((i + 1) + " CICLO");
            Integer ciclo = i + 1;
            logCsv(ciclo.toString());


            // Creo il foglio di lavodo xls
            WritableSheet sheet = XlsWriter.creteSheet(workbook, "CICLO" + ciclo, i);




            if ((randomModality) && (staticPriority)) {
                // modalità random, ricreo la lista ogni ciclo e la salvo per poi rieseguirla
                listaHtml = (ArrayList<String>) ActionManager.ISTANCE.doActionTest(ActionManager.ISTANCE.ACTION_GET_LIST_HTML_RAND, null);

View Full Code Here

      // ���ļ�
      WritableWorkbook book = Workbook.createWorkbook(new File(
          "students.xls"));


      // ������Ϊ"��һҳ"�Ĺ���������0��ʾ���ǵ�һҳ
      WritableSheet sheet = book.createSheet("��һҳ", 0);


      Label labelA = new Label(0, 0, "ѧ�����");
      Label labelB = new Label(1, 0, "ѧ������");
      Label labelC = new Label(2, 0, "ѧ������");
      Label labelD = new Label(3, 0, "ѧ���Ա�");
      Label labelE = new Label(4, 0, "ѧ������");
      Label labelF = new Label(5, 0, "ѧ���༶");


      // ������õĵ�Ԫ����ӵ���������
      sheet.addCell(labelA);
      sheet.addCell(labelB);
      sheet.addCell(labelC);
      sheet.addCell(labelD);
      sheet.addCell(labelE);
      sheet.addCell(labelF);


      /*
       * ����һ���������ֵĵ�Ԫ�� ����ʹ��Number��������·�����������﷨����
       */
      Label labelA1 = new Label(0, 1, "svk");
      Label labelB1 = new Label(1, 1, "����");
      Label labelC1 = new Label(2, 1, "S");
      Label labelD1 = new Label(3, 1, "A");
      Label labelE1 = new Label(4, 1, "E");
      Label labelF1 = new Label(5, 1, "��Q");


      sheet.addCell(labelA1);
      sheet.addCell(labelB1);
      sheet.addCell(labelC1);
      sheet.addCell(labelD1);
      sheet.addCell(labelE1);
      sheet.addCell(labelF1);


      // д�����ݲ��ر��ļ�
      book.write();
      book.close();
      System.out.println("�����ļ��ɹ�!");

View Full Code Here

  public static void writeExcelFile(List al, String excel_file_name) {
    try {
      // ���ļ�
      WritableWorkbook book = Workbook.createWorkbook(new File(
          excel_file_name));
      WritableSheet sheet = book.createSheet("��һҳ", 0);


      for (int i = 0; i < al.size(); i++) {
        List ao = (List) al.get(i);
        for (int k = 0; k < ao.size(); k++) {
          Label datas = new Label(i+1, k, ao.get(k).toString());
          sheet.addCell(datas);
        }
      }
      // д�����ݲ��ر��ļ�
      book.write();
      book.close();

View Full Code Here

  public static void writeExcelFile(List al) {
    try {
      // ���ļ�
      WritableWorkbook book = Workbook.createWorkbook(new File(
          excel_file_name));
      WritableSheet sheet = book.createSheet("��һҳ", 0);


      for (int i = 0; i < al.size(); i++) {
        List ao = (List) al.get(i);
        for (int k = 0; k < ao.size(); k++) {
          Label datas = new Label(i+1, k, ao.get(k).toString());
          sheet.addCell(datas);
        }
      }
      // д�����ݲ��ر��ļ�
      book.write();
      book.close();

View Full Code Here

    @Override
    protected void buildExcelDocument(Map<String, Object> model, WritableWorkbook workbook, HttpServletRequest request,
            HttpServletResponse response) throws Exception {
        Order order = (Order) model.get("order");


        WritableSheet sheet = workbook.createSheet("Order", 0);
        sheet.addCell(new Label(1, 1, "Order :" + order.getId()));
        sheet.addCell(new Label(1, 2, "Order Date"));
        sheet.addCell(new DateTime(2, 2, order.getOrderDate()));
        sheet.addCell(new Label(1, 2, "Delivery Date"));
        sheet.addCell(new DateTime(2, 2, order.getDeliveryDate()));


        sheet.addCell(new Label(1, 4, "Title"));
        sheet.addCell(new Label(2, 4, "Price"));
        sheet.addCell(new Label(3, 4, "#"));
        sheet.addCell(new Label(4, 4, "Total"));


        int row = 4;
        for (OrderDetail detail : order.getOrderDetails()) {
            row++;
            sheet.addCell(new Label(1, row, detail.getBook().getTitle()));
            sheet.addCell(new jxl.write.Number(2, row, detail.getBook().getPrice().doubleValue()));
            sheet.addCell(new jxl.write.Number(3, row, detail.getQuantity()));
            sheet.addCell(new jxl.write.Number(2, row, detail.getPrice().doubleValue()));
        }
    }

View Full Code Here

  public void testJExcel() throws Exception {
    AbstractJExcelView excelView = new UnixSafeAbstractJExcelView() {
      @Override
      protected void buildExcelDocument(Map<String, Object> model, WritableWorkbook wb,
          HttpServletRequest request, HttpServletResponse response) throws Exception {
        WritableSheet sheet = wb.createSheet("Test Sheet", 0);
        // test all possible permutation of row or column not existing
        sheet.addCell(new Label(2, 4, "Test Value"));
        sheet.addCell(new Label(2, 3, "Test Value"));
        sheet.addCell(new Label(3, 4, "Test Value"));
        sheet.addCell(new Label(2, 4, "Test Value"));
      }
    };


    excelView.render(new HashMap<String, Object>(), request, response);


    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    assertEquals("Test Sheet", wb.getSheet(0).getName());
    Sheet sheet = wb.getSheet("Test Sheet");
    Cell cell = sheet.getCell(2, 4);
    assertEquals("Test Value", cell.getContents());
  }

View Full Code Here


    AbstractJExcelView excelView = new UnixSafeAbstractJExcelView() {
      @Override
      protected void buildExcelDocument(Map<String, Object> model, WritableWorkbook wb,
          HttpServletRequest request, HttpServletResponse response) throws Exception {
        WritableSheet sheet = wb.getSheet("Sheet1");
        // test all possible permutation of row or column not existing
        sheet.addCell(new Label(2, 4, "Test Value"));
        sheet.addCell(new Label(2, 3, "Test Value"));
        sheet.addCell(new Label(3, 4, "Test Value"));
        sheet.addCell(new Label(2, 4, "Test Value"));
      }
    };


    excelView.setApplicationContext(webAppCtx);
    excelView.setUrl("template");
    excelView.render(new HashMap<String, Object>(), request, response);


    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    Sheet sheet = wb.getSheet("Sheet1");
    Cell cell = sheet.getCell(0, 0);
    assertEquals("Test Template", cell.getContents());
  }

View Full Code Here

0 1 2 3

TOP

Related Classes of jxl.write.WritableSheet

baseconocimiento.ArchivoExcelBaseConocimiento

com.example.bookstore.web.view.OrderExcelView

com.fengjing.framework.springmvc.viewer.excel.JxlExcelRevenueReportView

com.iisigroup.cap.rule.handler.RuleTbMntHandler

com.impetus.kundera.benchmark.WriteToExcelFile

com.vsked.excel.ExcelOperate

edu.zzuli.util.ExcelHandle

gannuWSD.testing.XLSWriter

it.pdor.webapp.contabilita.stampeContabili.bilancio.BilancioExcel

jxl.demo.ReadWrite

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.