Hi, Not sure myself, unfortunately we do not have a comprehensive list of differences that are mandated by the formats themselves, but they are not a lot and surely in areas usually not used a lot, mostly the newer XML based formats support a few additional things that were not available at the time the binary format was built by Microsoft.
Dominik. On Thu, Oct 29, 2015 at 10:12 AM, Rohit Cha <[email protected]> wrote: > Can i know the some small "differences in some areas when one format supports > things that the other does not." as it may be helpful to my work in future > > On Thu, Oct 29, 2015 at 1:26 PM, Dominik Stadler <[email protected]> > wrote: > >> Hi, >> >> WorkbookFactory can open both file formats and will use the correct >> specific implementation internally automatically. >> >> As long as you stick to the Workbook, Sheet, Row, Cell interfaces (in >> contrast to XSSFWorkbook/HSSFWorkbook and related implementations), >> you should be able to work with both types of files. >> >> Functionality and behavior should be very similar for both types. >> There may be some small differences in some areas when one format >> supports things that the other does not. >> >> Dominik. >> >> On Thu, Oct 29, 2015 at 7:46 AM, Rohit Cha <[email protected]> >> wrote: >> > Does WorkbookFactory.create(input) can read both excel-2003 and >> excel-2007 >> > with out any exception or do we need to use xssf and hssf seperately for >> > each one >> > >> > >> > FileInputStream input = new FileInputStream( >> > >> > "/Users/Desktop/Spice+tool.xls"); >> > >> > >> > Workbook wb = WorkbookFactory.create(input); >> > >> > Sheet sheet = wb.getSheetAt(0); >> > >> > System.out.println(String.valueOf(sheet.getRow(11).getCell(0))); >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
