<zk>
	<window border="none" width="100%" height="100%" apply="org.zkoss.support.igm.CellDataComposer">
	</window>
</zk>

package org.zkoss.support.igm;

import java.io.File;

import org.zkoss.zk.ui.WebApps;
import org.zkoss.zk.ui.select.SelectorComposer;
import org.zkoss.zss.api.Importer;
import org.zkoss.zss.api.Importers;
import org.zkoss.zss.api.model.Book;
import org.zkoss.zss.ui.Spreadsheet;
import org.zkoss.zul.Window;

public class CellDataComposer extends SelectorComposer<Window> {

	private static final long serialVersionUID = -257374661283941797L;

	private Spreadsheet ss;
	private Importer importer = Importers.getImporter();

	public void doAfterCompose(Window comp) throws Exception {
		super.doAfterCompose(comp);
		ss = new Spreadsheet();
		ss.setHflex("1");
		ss.setVflex("1");
		ss.setShowFormulabar(true);
		ss.setShowContextMenu(true);
		ss.setShowToolbar(true);
		ss.setShowSheetbar(true);
		ss.setMaxVisibleRows(100);
		ss.setMaxVisibleColumns(40);
		Book loadedBook = importer.imports(new File(WebApps.getCurrent().getRealPath("/WEB-INF/books/sample.xlsx")), "sample.xlsx");
		ss.setBook(loadedBook);
		ss.setParent(comp);
	}

}