Spreadsheet Data Model
From Documentation
⧼coll-notfound_msg⧽
Return to Documentation.
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()
change sheet example
spreadsheet model
- book
- sheet
- cell
- Range