Zk Excel export problem

asked 2015-02-03 09:10:54 +0800

emreturka
9 ● 2

updated 2015-02-04 13:14:46 +0800

I want to export an excel from Listbox.I have researched and used zk's documentation codes.Here is the codes;

@Listen("onClick = #excelImageId")
public void getExcelFile() {
    ByteArrayOutputStream out = new ByteArrayOutputStream();

    ExcelExporter exporter = new ExcelExporter();
    exporter.export(kayitListBoxId, out);

    AMedia amedia = new AMedia("FirstReport.xlsx", "xls",
            "application/file", out.toByteArray());
    Filedownload.save(amedia);
    out.close();
}

Here is the zul file;

                <listbox id="kayitListBoxId"
                    emptyMessage="Kayıt yok!" model="${win$composer.kayitModelList}"
                    checkmark="true" mold="paging" pageSize="9">
                    <auxhead>
                        <auxheader colspan="2">
                            <textbox id="filterName" instant="true"
                                width="100px" />
                        </auxheader>
                        <auxheader colspan="2">
                            <hlayout>
                                <textbox id="filterSurname"
                                    instant="true" width="100px" />
                                <space width="85px" />
                                <textbox id="filterEposta"
                                    width="100px" />
                            </hlayout>
                        </auxheader>
                        <auxheader colspan="2">
                            <hlayout>
                                <textbox id="filterDogumTarihi"
                                    instant="true" width="100px" />
                                <space width="80px" />
                                <combobox id="filterCinsiyet" />
                            </hlayout>
                        </auxheader>
                        <auxheader colspan="2">
                            <combobox id="filterStudyDeg" />
                        </auxheader>
                    </auxhead>
                    <listhead>
                        <listheader width="32px" />
                        <listheader label="Ad" align="center"
                            sort="auto(ad)" width="190px" />
                        <listheader label="Soyad" align="center"
                            sort="auto(soyad)" width="190px" />
                        <listheader label="E-Posta" align="center"
                            width="190px" sort="auto(eposta)" />
                        <listheader label="Doğum Tarihi"
                            width="190px" align="center" sort="auto(dogumtarihi)" />
                        <listheader label="Cinsiyet" align="center"
                            sort="auto(cinsiyet)" width="190px" />
                        <listheader label="Tahsil" align="center"
                            sort="auto(tahsil)" width="190px" />
                    </listhead>
                    <template name="model">
                        <listitem>
                            <listcell />
                            <listcell label="${each.ad}" />
                            <listcell label="${each.soyad}" />
                            <listcell label="${each.eposta}" />
                            <listcell label="${each.dogumtarihi}" />
                            <listcell label="${each.cinsiyet}" />
                            <listcell label="${each.tahsil}" />
                        </listitem>
                    </template>
                </listbox>
                <separator width="700px" />
                <button id="deleteButtonId" label="Sil"
                    image="/widgets/img/delete.png" />
                <space spacing="20px" />
                <button id="updateButtonId" label="Güncelle"
                    image="/widgets/img/update.png" />
                <space spacing="20px" />
                <image id="excelImageId"
                    src="/widgets/img/excelFile.png" />
                <space spacing="100px" />
                <label id="recordNumberLabel" />
            </window>

exporter.export(kayitListBoxId, out); is giving error.The error is that "The type org.zkoss.poi.ss.usermodel.Row cannot be resolved. It is indirectly referenced from required .class files".What is the best or short way export an excel in zk framework.