Examples of SpreadSheet

com.projity.pm.graphic.spreadsheet.SpreadSheet

org.formulacompiler.spreadsheet.Spreadsheet

Represents a spreadsheet model in memory. It can be constructed from different spreadsheet file formats, for example Excel .xls and .xml, and OpenOffice Calc (see {@link SpreadsheetCompiler#loadSpreadsheet(java.io.File)}). It serves as input to the {@link SpreadsheetToEngineCompiler} implementations and thus decouples engine compilation fromthe different spreadsheet file formats supported by AFC.

The spreadsheet model is immutable except for one thing. As a convenience, you can add custom range names to be used by {@link #getCell(String)}, {@link #getRange(String)}, and {@link #getRangeNames()}. These are never used internally to resolve formula references and do not affect the semantics of the spreadsheet model. We support this convenience so that code already written against the {@link #getCell(String)} API can transparently profit from namesextracted from a spreadsheet's layout, for instance.

The handling of additional range names is not thread-safe.

This interface is an API only. Do not implement it yourself. @see SpreadsheetLoader @see SpreadsheetBuilder @see SpreadsheetToEngineCompiler @author peo

org.jopendocument.dom.spreadsheet.SpreadSheet

org.zkoss.zss.ui.Spreadsheet

Spreadsheet is a rich ZK Component to handle EXCEL like behavior, it reads the data from a data model( {@link Book}) and interact with this model by event.
You can assign a Book by {@link #setBook(Book)} or just set the .xls file location by {@link #setSrc(String)}. You also need to set two attributes to restrict max rows and columns to show on client side by {@link #setMaxrows(int)} and {@link #setMaxcolumns(int)}.
To use Spreadsheet in .zul file, just use <spreadsheet/> tag like any other ZK Components.
An simplest example :
<spreadsheet src="/WEB-INF/xls/my.xls" maxrows="300" maxcolumns="80"
height="400px" width="90%" /> @author dennischen

pt.utl.ist.fenix.tools.util.excel.Spreadsheet

    }


    public ActionForward exportXLS(ActionMapping mapping, ActionForm form, HttpServletRequest request,
            HttpServletResponse response) throws IOException {
        ExternalSupervisorViewsBean bean = getRenderedObject("sessionBean");
        final Spreadsheet spreadsheet = generateSpreadsheet(bean);


        response.setContentType("application/vnd.ms-excel");
        response.setHeader("Content-disposition", "attachment; filename=" + getFilename(bean) + ".xls");
        spreadsheet.exportToXLSSheet(response.getOutputStream());
        response.getOutputStream().flush();
        response.flushBuffer();
        return null;
    }

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

Examples of SpreadSheet

Examples of pt.utl.ist.fenix.tools.util.excel.Spreadsheet