Пример #1
0
        /**
         * Adds cells to the specified sheet which test the various date formats
         *
         * @param s
         */
        private void writeDateFormatSheet(WritableSheet s)
        {
            WritableCellFormat wrappedText = new WritableCellFormat(WritableWorkbook.ARIAL_10_PT);
            wrappedText.setWrap(true);

            s.setColumnView(0, 20);
            s.setColumnView(2, 20);
            s.setColumnView(3, 20);
            s.setColumnView(4, 20);

            s.getSettings().setFitWidth(2);
            s.getSettings().setFitHeight(2);

            // TODO: CML - fix this with DateTime support
            //Calendar c = Calendar.getInstance(TimeZone.getTimeZone("GMT"));
            //c.set(1975, 4, 31, 15, 21, 45);
            //c.set(Calendar.MILLISECOND, 660);
            //Date date = c.getTime();
            //c.set(1900, 0, 1, 0, 0, 0);
            //c.set(Calendar.MILLISECOND, 0);

            //Date date2 = c.getTime();
            //c.set(1970, 0, 1, 0, 0, 0);
            //Date date3 = c.getTime();
            //c.set(1918, 10, 11, 11, 0, 0);
            //Date date4 = c.getTime();
            //c.set(1900, 0, 2, 0, 0, 0);
            //Date date5 = c.getTime();
            //c.set(1901, 0, 1, 0, 0, 0);
            //Date date6 = c.getTime();
            //c.set(1900, 4, 31, 0, 0, 0);
            //Date date7 = c.getTime();
            //c.set(1900, 1, 1, 0, 0, 0);
            //Date date8 = c.getTime();
            //c.set(1900, 0, 31, 0, 0, 0);
            //Date date9 = c.getTime();
            //c.set(1900, 2, 1, 0, 0, 0);
            //Date date10 = c.getTime();
            //c.set(1900, 1, 27, 0, 0, 0);
            //Date date11 = c.getTime();
            //c.set(1900, 1, 28, 0, 0, 0);
            //Date date12 = c.getTime();
            //c.set(1980, 5, 31, 12, 0, 0);
            //Date date13 = c.getTime();
            //c.set(1066, 9, 14, 0, 0, 0);
            //Date date14 = c.getTime();

            //// Built in date formats
            //SimpleDateFormat sdf = new SimpleDateFormat("dd MMM yyyy HH:mm:ss.SSS");
            //sdf.setTimeZone(TimeZone.getTimeZone("GMT"));
            //Label l = new Label(0, 0, "All dates are " + sdf.format(date), wrappedText);
            //s.addCell(l);

            //l = new Label(0, 1, "Built in formats",
            //              wrappedText);
            //s.addCell(l);

            //l = new Label(2, 1, "Custom formats");
            //s.addCell(l);

            DateTime date = DateTime.UtcNow;
            WritableCellFormat cf1 = new WritableCellFormat(DateFormats.FORMAT1);
            ExcelDateTime dt = new ExcelDateTime(0, 2, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            cf1 = new WritableCellFormat(DateFormats.FORMAT2);
            dt = new ExcelDateTime(0, 3, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            cf1 = new WritableCellFormat(DateFormats.FORMAT3);
            dt = new ExcelDateTime(0, 4, date, cf1);
            s.addCell(dt);

            cf1 = new WritableCellFormat(DateFormats.FORMAT4);
            dt = new ExcelDateTime(0, 5, date, cf1);
            s.addCell(dt);

            cf1 = new WritableCellFormat(DateFormats.FORMAT5);
            dt = new ExcelDateTime(0, 6, date, cf1);
            s.addCell(dt);

            cf1 = new WritableCellFormat(DateFormats.FORMAT6);
            dt = new ExcelDateTime(0, 7, date, cf1);
            s.addCell(dt);

            cf1 = new WritableCellFormat(DateFormats.FORMAT7);
            dt = new ExcelDateTime(0, 8, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            cf1 = new WritableCellFormat(DateFormats.FORMAT8);
            dt = new ExcelDateTime(0, 9, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            dt = new ExcelDateTime(0, 10, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            cf1 = new WritableCellFormat(DateFormats.FORMAT10);
            dt = new ExcelDateTime(0, 11, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            cf1 = new WritableCellFormat(DateFormats.FORMAT11);
            dt = new ExcelDateTime(0, 12, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            cf1 = new WritableCellFormat(DateFormats.FORMAT12);
            dt = new ExcelDateTime(0, 13, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            // Custom formats
            DateFormat df = new DateFormat("dd MM yyyy");
            cf1 = new WritableCellFormat(df);
            Label l = new Label(2, 2, "dd MM yyyy");
            s.addCell(l);

            dt = new ExcelDateTime(3, 2, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            df = new DateFormat("dd MMM yyyy");
            cf1 = new WritableCellFormat(df);
            l = new Label(2, 3, "dd MMM yyyy");
            s.addCell(l);

            dt = new ExcelDateTime(3, 3, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            df = new DateFormat("hh:mm");
            cf1 = new WritableCellFormat(df);
            l = new Label(2, 4, "hh:mm");
            s.addCell(l);

            dt = new ExcelDateTime(3, 4, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            df = new DateFormat("hh:mm:ss");
            cf1 = new WritableCellFormat(df);
            l = new Label(2, 5, "hh:mm:ss");
            s.addCell(l);

            dt = new ExcelDateTime(3, 5, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            df = new DateFormat("H:mm:ss a");
            cf1 = new WritableCellFormat(df);
            l = new Label(2, 5, "H:mm:ss a");
            s.addCell(l);

            dt = new ExcelDateTime(3, 5, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);
            dt = new ExcelDateTime(4, 5, date, cf1, ExcelDateTime.GMT);
            //			dt = new ExcelDateTime(4, 5, date13, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            df = new DateFormat("mm:ss.SSS");
            cf1 = new WritableCellFormat(df);
            l = new Label(2, 6, "mm:ss.SSS");
            s.addCell(l);

            dt = new ExcelDateTime(3, 6, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            df = new DateFormat("hh:mm:ss a");
            cf1 = new WritableCellFormat(df);
            l = new Label(2, 7, "hh:mm:ss a");
            s.addCell(l);

            //			dt = new ExcelDateTime(4, 7, date13, cf1, ExcelDateTime.GMT);
            dt = new ExcelDateTime(4, 7, date, cf1, ExcelDateTime.GMT);
            s.addCell(dt);

            // Check out the zero date ie. 1 Jan 1900
            //			l = new Label(0, 16, "Zero date " + sdf.format(date2),wrappedText);
            //			s.addCell(l);

            cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            //dt = new ExcelDateTime(0, 17, date2, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);

            // Check out the zero date + 1 ie. 2 Jan 1900
            //l = new Label(3, 16, "Zero date + 1 " + sdf.format(date5),
            //              wrappedText);
            //s.addCell(l);

            //cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            //dt = new ExcelDateTime(3, 17, date5, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);

            //// Check out the 1 Jan 1901
            //l = new Label(3, 19, sdf.format(date6),
            //              wrappedText);
            //s.addCell(l);

            //cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            //dt = new ExcelDateTime(3, 20, date6, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);

            //// Check out the 31 May 1900
            //l = new Label(3, 22, sdf.format(date7),
            //              wrappedText);
            //s.addCell(l);

            //cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            //dt = new ExcelDateTime(3, 23, date7, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);

            //// Check out 1 Feb 1900
            //l = new Label(3, 25, sdf.format(date8),
            //              wrappedText);
            //s.addCell(l);

            //cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            //dt = new ExcelDateTime(3, 26, date8, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);

            //// Check out 31 Jan 1900
            //l = new Label(3, 28, sdf.format(date9),
            //              wrappedText);
            //s.addCell(l);

            //cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            //dt = new ExcelDateTime(3, 29, date9, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);

            //// Check out 31 Jan 1900
            //l = new Label(3, 28, sdf.format(date9),
            //              wrappedText);
            //s.addCell(l);

            //cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            //dt = new ExcelDateTime(3, 29, date9, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);

            //// Check out 1 Mar 1900
            //l = new Label(3, 31, sdf.format(date10),
            //              wrappedText);
            //s.addCell(l);

            //cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            //dt = new ExcelDateTime(3, 32, date10, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);

            //// Check out 27 Feb 1900
            //l = new Label(3, 34, sdf.format(date11),
            //              wrappedText);
            //s.addCell(l);

            //cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            //dt = new ExcelDateTime(3, 35, date11, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);

            //// Check out 28 Feb 1900
            //l = new Label(3, 37, sdf.format(date12),
            //              wrappedText);
            //s.addCell(l);

            //cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            //dt = new ExcelDateTime(3, 38, date12, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);

            //// Check out the zero date ie. 1 Jan 1970
            //l = new Label(0, 19, "Zero UTC date " + sdf.format(date3),
            //              wrappedText);
            //s.addCell(l);

            //cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            //dt = new ExcelDateTime(0, 20, date3, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);

            //// Check out the WWI armistice day ie. 11 am, Nov 11, 1918
            //l = new Label(0, 22, "Armistice date " + sdf.format(date4),
            //              wrappedText);
            //s.addCell(l);

            //cf1 = new WritableCellFormat(DateFormats.FORMAT9);
            //dt = new ExcelDateTime(0, 23, date4, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);

            //// Check out the Battle of Hastings date Oct 14th, 1066
            //l = new Label(0, 25, "Battle of Hastings " + sdf.format(date14),
            //              wrappedText);
            //s.addCell(l);

            //cf1 = new WritableCellFormat(DateFormats.FORMAT2);
            //dt = new ExcelDateTime(0, 26, date14, cf1, ExcelDateTime.GMT);
            //s.addCell(dt);
        }
Пример #2
0
 /**
  * Copy constructor used for deep copying
  *
  * @param col the column
  * @param row the row
  * @param dt the date to copy
  */
 protected ExcelDateTime(int col, int row, ExcelDateTime dt)
     : base(col, row, dt)
 {
 }
Пример #3
0
 /**
  * Copy constructor used for deep copying
  *
  * @param col the column
  * @param row the row
  * @param dt the date to copy
  */
 protected ExcelDateTime(int col,int row,ExcelDateTime dt)
     : base(col,row,dt)
 {
 }