Book not found

Load An Excel File

the way to load an Excel file:

src Attribute

The simplest way to display Excel book file is setting Spreadsheet's src attribute to the file path which is a relative URI with respect to the web application root.

<spreadsheet src="/WEB-INF/startzss.xlsx" maxVisibleRows="150" maxVisibleColumns="40" />

API

Spreadsheet also provides API to load an Excel file. ZK Spreadsheet component's Spreadsheet.setSrc(String) can be called to display an Excel file programmatically. Similar to src attribute, this method accepts relative file path.

setSrc()

public class MyComposer extends SelectorComposer<Component> {

	@Wire("spreadsheet")
	Spreadsheet spreadsheet;
	
	@Override
	public void doAfterCompose(Component comp) throws Exception {
		super.doAfterCompose(comp);
		//initialize stuff here
		spreadsheet.setSrc("/WEB-INF/books/startzss.xlsx");

	}
}

setBook()

public class MyComposer extends SelectorComposer<Component> {

	@Wire("spreadsheet")
	Spreadsheet spreadsheet;
	
	@Override
	public void doAfterCompose(Component comp) throws Exception {
		super.doAfterCompose(comp);
		//initialize stuff here
		loadBook();
	}
	
	public void loadBook() throws IOException{
		Importer importer = Importers.getImporter();
		InputStream inputStream = WebApps.getCurrent().getResourceAsStream("/WEB-INF/books/startzss.xlsx");
		Book book = importer.imports(inputStream, "startzss");
		spreadsheet.setBook(book);
	}
}

component api

brief introduce some commonly-used API

• setSelectedSheet(String)
• getBook()

Spreadsheet

spreadsheet model

• book
• sheet
• cell
• Range