import org.apache.poi.util.LocaleUtil; //导入依赖的package包/类
/**
 * Get EXCEL date as Java Calendar with given time zone.
 * @param date  The Excel date.
 * @param use1904windowing  true if date uses 1904 windowing,
 *  or false if using 1900 date windowing.
 * @param timeZone The TimeZone to evaluate the date in
 * @param roundSeconds round to closest second
 * @return Java representation of the date, or null if date is not a valid Excel date
 */
public static Calendar getJavaCalendar(double date, boolean use1904windowing, TimeZone timeZone, boolean roundSeconds) {
    if (!isValidExcelDate(date)) {
        return null;
    }
    int wholeDays = (int)Math.floor(date);
    int millisecondsInDay = (int)((date - wholeDays) * DAY_MILLISECONDS + 0.5);
    Calendar calendar;
    if (timeZone != null) {
        calendar = LocaleUtil.getLocaleCalendar(timeZone);
    } else {
        calendar = LocaleUtil.getLocaleCalendar(); // using default time-zone
    }
    setCalendar(calendar, wholeDays, millisecondsInDay, use1904windowing, roundSeconds);
    return calendar;
}
 

import org.apache.poi.util.LocaleUtil; //导入依赖的package包/类
private ByteArrayEditableData getData() throws IOException, TreeModelLoadException {
	if (packagePart instanceof PackagePropertiesPart) {
		return new ByteArrayEditableData("Property parts can't be exported.".getBytes(LocaleUtil.CHARSET_1252));
	}
	
	FileMagic fm;
	try (InputStream is = FileMagic.prepareToCheckMagic(packagePart.getInputStream())) {
		final ByteArrayEditableData data = new ByteArrayEditableData();
		fm = FileMagic.valueOf(is);
		if (fm == FileMagic.OLE2) {
			if (oleFile == null) {
				oleFile = copyToTempFile(is);
				OLETreeModel poifsNode = appContext.getBean(OLETreeModel.class, treeNode);
				poifsNode.load(oleFile);
				((TreeModelEntry)treeNode.getUserObject()).activate();
			}
			
			try (InputStream is2 = new FileInputStream(oleFile)) {
				data.loadFromStream(is2);
			}
		} else {
			data.loadFromStream(is);
		}
		return data;
	}
	
}
 

import org.apache.poi.util.LocaleUtil; //导入依赖的package包/类
private static Date parseYYYYMMDDDateInternal(String timeStr) throws FormatException {
    if(timeStr.length() != 10) {
        throw new FormatException("Bad length");
    }

    String yearStr = timeStr.substring(0, 4);
    String monthStr = timeStr.substring(5, 7);
    String dayStr = timeStr.substring(8, 10);
    int year = parseInt(yearStr, "year", Short.MIN_VALUE, Short.MAX_VALUE);
    int month = parseInt(monthStr, "month", 1, 12);
    int day = parseInt(dayStr, "day", 1, 31);

    Calendar cal = LocaleUtil.getLocaleCalendar(year, month-1, day);
    return cal.getTime();
}
 

import org.apache.poi.util.LocaleUtil; //导入依赖的package包/类
private static void generateSheetData(final Sheet sheet, final CellStyle style, short startingRow) {
  int currentRow = startingRow;
  // Create first row values
  Row row1 = sheet.createRow(currentRow++);
  row1.createCell(0).setCellValue(1.0);
  row1.createCell(1).setCellValue("One");
  row1.createCell(2).setCellValue("One");
  Cell c13 = row1.createCell(3);
  c13.setCellValue(LocaleUtil.getLocaleCalendar(1983, 04/*zero based*/, 18, 4, 0, 0));
  c13.setCellStyle(style);
  Cell c14 = row1.createCell(4);
  c14.setCellFormula("A2+1");
  // For formulas we read pre-computed values. Editors set the precomputed value by default. We need to add it here
  // explicitly as the library doesn't pre compute the formula value.
  c14.setCellValue(2.0d);
  row1.createCell(5).setCellValue(true);
  row1.createCell(6).setCellFormula("B2*20");
  row1.createCell(6).setCellValue("#ERROR");

  // Create second row values
  Row row2 = sheet.createRow(currentRow++);
  row2.createCell(0).setCellValue(2.0);
  row2.createCell(1).setCellValue("Two");
  row2.createCell(2).setCellValue("Two");
  Cell c23 = row2.createCell(3);
  c23.setCellValue(LocaleUtil.getLocaleCalendar(2013, 06/*zero based*/, 05, 5, 0, 1));
  c23.setCellStyle(style);
  Cell c24 = row2.createCell(4);
  c24.setCellFormula("A3+1");
  c24.setCellValue(3.0d);
  row2.createCell(5).setCellValue(false);
  row2.createCell(6).setCellFormula("B3*20");
  row2.createCell(6).setCellValue("#ERROR");

  // Create third row values
  Row row3 = sheet.createRow(currentRow++);
  row3.createCell(0).setCellValue(3.0);
  row3.createCell(1).setCellValue("Three and Three");
  row3.createCell(5).setCellValue(false);

  // Create fourth row values
  Row row4 = sheet.createRow(currentRow++);
  row4.createCell(0).setCellValue(4.0);
  row4.createCell(1).setCellValue("Four and Four, Five and Five");

  // Create fifth row values
  Row row5 = sheet.createRow(currentRow++);
  row5.createCell(0).setCellValue(5.0);

  sheet.addMergedRegion(new CellRangeAddress(startingRow + 2, startingRow + 2, 1, 2));
  sheet.addMergedRegion(new CellRangeAddress(startingRow + 2, startingRow + 4, 5, 5));
  sheet.addMergedRegion(new CellRangeAddress(startingRow + 3, startingRow + 4, 1, 2));
}
 

import org.apache.poi.util.LocaleUtil; //导入依赖的package包/类
void checkForLocaleChange() {
    checkForLocaleChange(LocaleUtil.getUserLocale());
}
 

import org.apache.poi.util.LocaleUtil; //导入依赖的package包/类
/**
 * Creates a formatter using the {@link Locale#getDefault() default locale}.
 */
public ExcelHSSFDataFormatter() {
    this(LocaleUtil.getUserLocale());
}
 

import org.apache.poi.util.LocaleUtil; //导入依赖的package包/类
/**
 * Retrieves the proper Java type instance based on the Excel CellTypeEnum
 */
private Object getCellValue(Cell cell)
{
	Object value;

	// Empty cells are null, instead of BLANK
	if (cell == null)
	{
		return null;
	}

	switch (cell.getCellTypeEnum())
	{
		case STRING:
			value = cell.getStringCellValue();
			break;
		case NUMERIC:
			if (isCellDateFormatted(cell))
			{
				try
				{
					// Excel dates are LocalDateTime, stored without timezone.
					// Interpret them as UTC to prevent ambiguous DST overlaps which happen in other timezones.
					setUserTimeZone(LocaleUtil.TIMEZONE_UTC);
					Date dateCellValue = cell.getDateCellValue();
					value = formatUTCDateAsLocalDateTime(dateCellValue);
				}
				finally
				{
					resetUserTimeZone();
				}
			}
			else
			{
				value = cell.getNumericCellValue();
			}
			break;
		case BOOLEAN:
			value = cell.getBooleanCellValue();
			break;
		case FORMULA:
			value = getTypedFormulaValue(cell);
			break;
		default:
			value = null;
			break;
	}
	return value;
}
 

import org.apache.poi.util.LocaleUtil; //导入依赖的package包/类
/**
 * Creates a format tracking wrapper around the given listener, using
 * the {@link Locale#getDefault() default locale} for the formats.
 *
 * @param childListener the listener to be wrapped
 */
public FormatTrackingHSSFListenerPlus(HSSFListener childListener) {
    this(childListener, LocaleUtil.getUserLocale());
}
 

import org.apache.poi.util.LocaleUtil; //导入依赖的package包/类
/**
 * Given a Date, converts it into a double representing its internal Excel representation,
 *   which is the number of days since 1/1/1900. Fractional days represent hours, minutes, and seconds.
 *
 * @return Excel representation of Date (-1 if error - aoptest for error by checking for less than 0.1)
 * @param date the Date
 * @param use1904windowing Should 1900 or 1904 date windowing be used?
 */
public static double getExcelDate(Date date, boolean use1904windowing) {
    Calendar calStart = LocaleUtil.getLocaleCalendar();
    calStart.setTime(date);   // If date includes hours, minutes, and seconds, set them to 0
    return internalGetExcelDate(calStart, use1904windowing);
}
 

import org.apache.poi.util.LocaleUtil; //导入依赖的package包/类
/**
 * Get EXCEL date as Java Calendar with UTC time zone.
 * This is similar to {@link #getJavaDate(double, boolean)} but returns a
 * Calendar object that has UTC as time zone, so no daylight saving hassle.
 * @param date  The Excel date.
 * @param use1904windowing  true if date uses 1904 windowing,
 *  or false if using 1900 date windowing.
 * @return Java representation of the date in UTC, or null if date is not a valid Excel date
 */
public static Calendar getJavaCalendarUTC(double date, boolean use1904windowing) {
	return getJavaCalendar(date, use1904windowing, LocaleUtil.TIMEZONE_UTC, false);
}
 

import org.apache.poi.util.LocaleUtil; //导入依赖的package包/类
/**
 * Creates a formatter using the {@link Locale#getDefault() default locale}.
 *
 * @param  emulateCsv whether to emulate CSV output.
 */
public ExcelDataFormatter(boolean emulateCsv) {
    this(LocaleUtil.getUserLocale(), emulateCsv);
    this.localeIsAdapting = true;
}
 

import org.apache.poi.util.LocaleUtil; //导入依赖的package包/类
/**
 * Creates a format tracking wrapper around the given listener, using
 * the {@link Locale#getDefault() default locale} for the formats.
 */
public ExcelFormatTrackingHSSFListener(HSSFListener childListener) {
	this(childListener, LocaleUtil.getUserLocale());
}