can i open microsoft excel file directly in spread sheet?

asked 2013-08-30 07:22:07 +0800

sivaprasadjvs
1 ● 2

updated 2013-08-30 09:47:57 +0800

HI All,

i'm using zk 6.5 can i open microsoft excel file directly in spread sheet with multiple sheets? my file is in .xls/.xlsx format and was formatted with colors with some columns hidden and some with merged cells and no.of rows arround 2000.

is there any limitations for no.of rows of data in the MS-excel spread sheet? while rendering into ZKSS.

i got the following exception : :

org.zkoss.poi.hssf.record.RecordInputStream$LeftoverDataException: Initialisation of record 0x87F left 19 bytes remaining still to be read. org.zkoss.poi.hssf.record.RecordInputStream.hasNextRecord(RecordInputStream.java:156) org.zkoss.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:231) org.zkoss.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:482) org.zkoss.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:293) org.zkoss.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:256) org.zkoss.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:200) org.zkoss.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:337) org.zkoss.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:318) org.zkoss.zss.model.impl.HSSFBookImpl.<init>(HSSFBookImpl.java:72) org.zkoss.zss.model.impl.ExcelImporter.importsFromStream(ExcelImporter.java:114) org.zkoss.zss.model.impl.ExcelImporter.importsFromURL(ExcelImporter.java:88) org.zkoss.zss.ui.Spreadsheet.getBook(Spreadsheet.java:452) org.zkoss.zss.ui.Spreadsheet.getSelectedSheet(Spreadsheet.java:593) org.zkoss.zss.ui.Spreadsheet.doInvalidate(Spreadsheet.java:4075) org.zkoss.zss.ui.Spreadsheet.invalidate(Spreadsheet.java:3483) org.zkoss.zss.ui.Spreadsheet.setSrc(Spreadsheet.java:653) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.zkoss.zk.ui.metainfo.Property.assign0(Property.java:284) org.zkoss.zk.ui.metainfo.Property.assign(Property.java:169) org.zkoss.zk.ui.metainfo.ComponentInfo.applyProperties(ComponentInfo.java:729) org.zkoss.zk.ui.impl.AbstractUiFactory.newComponent(AbstractUiFactory.java:101) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:798) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:767) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:676) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:640) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:813) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:767) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:676) org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:738) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:698) org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:640) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:391) org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:313) org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:214) org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:134) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

please let me know where i'm wrong...

please let me know if this is possible? or is there any other way to open. if i need to write a program then how to do meet the above conditions.

please reply me asap.

thanks