/* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package org.apache.poi.hssf.dev; import java.io.ByteArrayOutputStream; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.OutputStream; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; /** * Utility to test that POI produces readable output * after re-saving xls files. * * Usage: ReSave [-dg] input.xls * -dg initialize drawings, causes to re-build escher aggregates in all sheets * -bos only write to memory instead of a file */ public class ReSave { public static void main(String[] args) throws Exception { boolean initDrawing = false; boolean saveToMemory = false; for(String filename : args) { if(filename.equals("-dg")) { initDrawing = true; } else if(filename.equals("-bos")) { saveToMemory = true; } else { System.out.print("reading " + filename + "..."); try (FileInputStream is = new FileInputStream(filename); HSSFWorkbook wb = new HSSFWorkbook(is)) { System.out.println("done"); for(int i = 0; i < wb.getNumberOfSheets(); i++){ HSSFSheet sheet = wb.getSheetAt(i); if(initDrawing) { /*HSSFPatriarch dg =*/ sheet.getDrawingPatriarch(); } } String outputFile = filename.replace(".xls", "-saved.xls"); if (!saveToMemory) { System.out.print("saving to " + outputFile + "..."); } try (OutputStream os = saveToMemory ? new ByteArrayOutputStream() : new FileOutputStream(outputFile)) { wb.write(os); } System.out.println("done"); } } } } }