/** * A factory method which takes in an excel file and reads in the contents. * * @param is an open stream which is the the excel 97 spreadsheet to parse * @param ws the settings for the workbook * @return a workbook instance * @exception IOException * @exception BiffException */ public static Workbook getWorkbook(InputStream is, WorkbookSettings ws) throws IOException, BiffException { File dataFile = new File(is, ws); Workbook workbook = new WorkbookParser(dataFile, ws); workbook.parse(); return workbook; }
sharedStrings = new SharedStrings(); nameRecords = new HashMap(); fonts = wp.getFonts(); formatRecords = wp.getFormattingRecords(); wbProtected = false; settings = ws; rcirCells = new ArrayList(); styles = new Styles(); outputFile = new File(os, ws, wp.getCompoundFile()); containsMacros = wp.containsMacros(); if (wp.getCountryRecord() != null) countryRecord = new CountryRecord(wp.getCountryRecord()); addInFunctionNames = wp.getAddInFunctionNames(); xctRecords = wp.getXCTRecords(); if (wp.getExternalSheetRecord() != null) externSheet = new ExternalSheetRecord(wp.getExternalSheetRecord()); jxl.read.biff.SupbookRecord[] readsr = wp.getSupbookRecords(); supbooks = new ArrayList(readsr.length); if (wp.getDrawingGroup() != null)
int fromSheetIndex = fromWorkbook.getIndex(fromSheet); NameRecord[] nameRecords = fromWorkbook.getNameRecords(); String[] names = toWorkbook.getRangeNames(); int nameSheetIndex = fromWorkbook.getExternalSheetIndex (nameRanges[j].getExternalSheet());
workbook.getDrawingGroup()); drawings.add(d2); msoRecord = null; workbook, workbook, workbook.getSettings()); if (dataValidation != null) if (!workbook.getWorkbookBof().isBiff8()) charts.add(chart); if (workbook.getDrawingGroup() != null) workbook.getDrawingGroup().add(chart); if (msoRecord != null && workbook.getDrawingGroup() != null) workbook.getDrawingGroup().setDrawingsOmitted(msoRecord, objRecord);
Sheet s = getSheet(getExternalSheetIndex(ranges[0].getExternalSheet())); int col = ranges[0].getFirstColumn(); int row = ranges[0].getFirstRow();
getExternalSheetIndex(ranges[i].getExternalSheet()), ranges[i].getFirstColumn(), ranges[i].getFirstRow(), getLastExternalSheetIndex(ranges[i].getExternalSheet()), ranges[i].getLastColumn(), ranges[i].getLastRow());
while (bof != null && getNumberOfSheets() < boundsheets.size()) (getNumberOfSheets()); s.setName(br.getName()); s.setHidden(br.isHidden()); addSheet(s); (getNumberOfSheets()); s.setName(br.getName()); s.setHidden(br.isHidden()); addSheet(s);
DrawingGroup dg = wp.getDrawingGroup();
int fromSheetIndex = fromWorkbook.getIndex(fromSheet); NameRecord[] nameRecords = fromWorkbook.getNameRecords(); String[] names = toWorkbook.getRangeNames(); int nameSheetIndex = fromWorkbook.getExternalSheetIndex (nameRanges[j].getExternalSheet());
workbook.getDrawingGroup()); drawings.add(d2); msoRecord = null; workbook, workbook, workbook.getSettings()); if (dataValidation != null) if (!workbook.getWorkbookBof().isBiff8()) charts.add(chart); if (workbook.getDrawingGroup() != null) workbook.getDrawingGroup().add(chart); if (msoRecord != null && workbook.getDrawingGroup() != null) workbook.getDrawingGroup().setDrawingsOmitted(msoRecord, objRecord);
Sheet s = getSheet(getExternalSheetIndex(ranges[0].getExternalSheet())); int col = ranges[0].getFirstColumn(); int row = ranges[0].getFirstRow();
getExternalSheetIndex(ranges[i].getExternalSheet()), ranges[i].getFirstColumn(), ranges[i].getFirstRow(), getLastExternalSheetIndex(ranges[i].getExternalSheet()), ranges[i].getLastColumn(), ranges[i].getLastRow());
while (bof != null && getNumberOfSheets() < boundsheets.size()) (getNumberOfSheets()); s.setName(br.getName()); s.setHidden(br.isHidden()); addSheet(s); (getNumberOfSheets()); s.setName(br.getName()); s.setHidden(br.isHidden()); addSheet(s);
DrawingGroup dg = wp.getDrawingGroup();
sharedStrings = new SharedStrings(); nameRecords = new HashMap(); fonts = wp.getFonts(); formatRecords = wp.getFormattingRecords(); wbProtected = false; settings = ws; rcirCells = new ArrayList(); styles = new Styles(); outputFile = new File(os, ws, wp.getCompoundFile()); containsMacros = wp.containsMacros(); if (wp.getCountryRecord() != null) countryRecord = new CountryRecord(wp.getCountryRecord()); addInFunctionNames = wp.getAddInFunctionNames(); xctRecords = wp.getXCTRecords(); if (wp.getExternalSheetRecord() != null) externSheet = new ExternalSheetRecord(wp.getExternalSheetRecord()); jxl.read.biff.SupbookRecord[] readsr = wp.getSupbookRecords(); supbooks = new ArrayList(readsr.length); if (wp.getDrawingGroup() != null)
Workbook workbook = new WorkbookParser(dataFile, ws); workbook.parse();
objRecord, drawingData, workbook.getDrawingGroup(), sheet); drawings.add(drawing); objRecord, drawingData, workbook.getDrawingGroup(), workbookSettings); objRecord, drawingData, workbook.getDrawingGroup(), workbookSettings); drawings.add(comboBox); objRecord, drawingData, workbook.getDrawingGroup(), workbookSettings); objRecord, drawingData, workbook.getDrawingGroup(), workbookSettings); if (workbook.getDrawingGroup() != null) // can be null for Excel 95
/** * A factory method which takes in an excel file and reads in the contents. * * @param is an open stream which is the the excel 97 spreadsheet to parse * @param ws the settings for the workbook * @return a workbook instance * @exception IOException * @exception BiffException */ public static Workbook getWorkbook(InputStream is, WorkbookSettings ws) throws IOException, BiffException { File dataFile = new File(is, ws); Workbook workbook = new WorkbookParser(dataFile, ws); workbook.parse(); return workbook; }
objRecord, drawingData, workbook.getDrawingGroup(), sheet); drawings.add(drawing); objRecord, drawingData, workbook.getDrawingGroup(), workbookSettings); objRecord, drawingData, workbook.getDrawingGroup(), workbookSettings); drawings.add(comboBox); objRecord, drawingData, workbook.getDrawingGroup(), workbookSettings); objRecord, drawingData, workbook.getDrawingGroup(), workbookSettings); if (workbook.getDrawingGroup() != null) // can be null for Excel 95
Workbook workbook = new WorkbookParser(dataFile, ws); workbook.parse();