/** * Create a new CTWorkbook with all values set to default */ private void onWorkbookCreate() { workbook = CTWorkbook.Factory.newInstance(); // don't EVER use the 1904 date system CTWorkbookPr workbookPr = workbook.addNewWorkbookPr(); workbookPr.setDate1904(false); setBookViewsIfMissing(); workbook.addNewSheets(); POIXMLProperties.ExtendedProperties expProps = getProperties().getExtendedProperties(); expProps.getUnderlyingProperties().setApplication(DOCUMENT_CREATOR); sharedStringSource = (SharedStringsTable)createRelationship(XSSFRelation.SHARED_STRINGS, this.xssfFactory); stylesSource = (StylesTable)createRelationship(XSSFRelation.STYLES, this.xssfFactory); stylesSource.setWorkbook(this); namedRanges = new ArrayList<>(); namedRangesByName = new ArrayListValuedHashMap<>(); sheets = new ArrayList<>(); pivotTables = new ArrayList<>(); }
private void translateSheetName(XSSFSheet sheet, String rawName, String translatedName) { ExtendedProperties extendedProperties = sheet.getWorkbook().getProperties().getExtendedProperties(); CTProperties props = extendedProperties.getUnderlyingProperties(); String[] sheetNames = props.getTitlesOfParts().getVector().getLpstrArray(); int i = 0; for( String sheetName : sheetNames ){ if(rawName.equals(sheetName)){ sheetNames[i] = translatedName; break; } i++; } }
POIXMLProperties props = currentXSSFWorkbook.getProperties(); POIXMLProperties.CoreProperties coreProp=props.getCoreProperties(); POIXMLProperties.CustomProperties custProp = props.getCustomProperties();
private boolean checkFilteredXSSF() { XSSFWorkbook currentXSSFWorkbook = (XSSFWorkbook) this.currentWorkbook; POIXMLProperties props = currentXSSFWorkbook.getProperties(); SimpleDateFormat format = new SimpleDateFormat(MSExcelParser.DATE_FORMAT);
/** * Create a new CTWorkbook with all values set to default */ private void onWorkbookCreate() { workbook = CTWorkbook.Factory.newInstance(); // don't EVER use the 1904 date system CTWorkbookPr workbookPr = workbook.addNewWorkbookPr(); workbookPr.setDate1904(false); setBookViewsIfMissing(); workbook.addNewSheets(); POIXMLProperties.ExtendedProperties expProps = getProperties().getExtendedProperties(); expProps.getUnderlyingProperties().setApplication(DOCUMENT_CREATOR); sharedStringSource = (SharedStringsTable)createRelationship(XSSFRelation.SHARED_STRINGS, this.xssfFactory); stylesSource = (StylesTable)createRelationship(XSSFRelation.STYLES, this.xssfFactory); stylesSource.setWorkbook(this); namedRanges = new ArrayList<>(); namedRangesByName = new ArrayListValuedHashMap<>(); sheets = new ArrayList<>(); pivotTables = new ArrayList<>(); }
workbook.createSheet("Workbook Properties"); POIXMLProperties props = workbook.getProperties();
/** * Create a new CTWorkbook with all values set to default */ private void onWorkbookCreate() { workbook = CTWorkbook.Factory.newInstance(); // don't EVER use the 1904 date system CTWorkbookPr workbookPr = workbook.addNewWorkbookPr(); workbookPr.setDate1904(false); CTBookViews bvs = workbook.addNewBookViews(); CTBookView bv = bvs.addNewWorkbookView(); bv.setActiveTab(0); workbook.addNewSheets(); POIXMLProperties.ExtendedProperties expProps = getProperties().getExtendedProperties(); expProps.getUnderlyingProperties().setApplication(DOCUMENT_CREATOR); sharedStringSource = (SharedStringsTable)createRelationship(XSSFRelation.SHARED_STRINGS, XSSFFactory.getInstance()); stylesSource = (StylesTable)createRelationship(XSSFRelation.STYLES, XSSFFactory.getInstance()); namedRanges = new ArrayList<XSSFName>(); sheets = new ArrayList<XSSFSheet>(); }