ZK Spreadsheet

answered 2013-06-20 09:07:55 +0800

benbai
2228 ● 6
http://www.zkoss.org

Yes, you can write value to specific cell or read value from it, please refer to Get or Set Value, Formula, or Formatted Text

A simple sample below, you can test it with a .xls file that contains some text in cell B3 of first sheet.

test.zul

<zk>
    <window apply="test.TestComposer">
        <spreadsheet id="spreadsheet" src="/test.xls" width="350px" height="350px" />
        <button id="btn" label="write value" />
        <button id="btnTwo" label="get value" />
    </window>
</zk>

TestComposer.java

package test;

import org.zkoss.zk.ui.select.SelectorComposer;
import org.zkoss.zk.ui.select.annotation.Listen;
import org.zkoss.zk.ui.select.annotation.Wire;
import org.zkoss.zss.model.Range;
import org.zkoss.zss.model.Ranges;
import org.zkoss.zss.model.Worksheet;
import org.zkoss.zss.ui.Spreadsheet;

@SuppressWarnings("rawtypes")
public class TestComposer extends SelectorComposer {
    /**
     * 
     */
    private static final long serialVersionUID = -4098595424876104223L;
    @Wire
    Spreadsheet spreadsheet;

    @Listen ("onClick = #btn")
    public void writeValue () {
        int row = 3;
        int col = 3;
        Worksheet sheet = spreadsheet.getSelectedSheet();
        Range currentRange = Ranges.range(sheet, row, col);
        currentRange.setEditText("test");
    }
    @Listen ("onClick = #btnTwo")
    public void readValue () {
        int row = 2;
        int col = 1;
        Worksheet sheet = spreadsheet.getSelectedSheet();
        Range currentRange = Ranges.range(sheet, row, col);
        System.out.println(currentRange.getEditText());
    }
}