Examples of jxl.write.WritableWorkbook.createSheet()

jxl.write.WritableWorkbook.createSheet()
Creates, and returns a worksheet at the specified position with the specified name If the index specified is less than or equal to zero, the new sheet is created at the beginning of the workbook. If the index is greater than the number of sheet, then the sheet is created at the end of the workbook. @param name the sheet name @param index the index number at which to insert @return the new sheet

    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);

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, "ѧ���Ա�");

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());

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());

View Full Code Here


      relFile = new File(fileDir + File.separator + CapDate.getCurrentDate("yyyyMMdd") + "_ruleExport.xls");
      relFile.createNewFile();
      // 2. 產生 workbook
      workbook = Workbook.createWorkbook(relFile);
      WritableSheet sheet1 = workbook.createSheet("Tables", 0);
      WritableFont myFont = new WritableFont(WritableFont.createFont("Arial"), 12);
      WritableFont boldWhiteFnt = 
          new WritableFont(WritableFont.createFont("Arial"), 12, WritableFont.BOLD);
      boldWhiteFnt.setColour(Colour.WHITE);
      WritableFont blackFnt =

View Full Code Here

        WorkbookSettings wbSettings = new WorkbookSettings();


        wbSettings.setLocale(new Locale("en", "EN"));


        WritableWorkbook workbook = Workbook.createWorkbook(file, wbSettings);
        workbook.createSheet("PerformanceBenchmark", 0);
        WritableSheet excelSheet = workbook.getSheet(0);
        createLabel(excelSheet, testSummatyField);
        createContent(excelSheet, map);


        workbook.write();

View Full Code Here

0 1 2

TOP

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.