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

Examples of org.zkoss.zss.ui.Spreadsheet

    int row = (Integer) data.get("row");
    int col = (Integer) data.get("col");
    int mx = (Integer) data.get("mx");//x offset against body
    int my = (Integer) data.get("my");
    
    Spreadsheet spreadsheet = (Spreadsheet) comp;
    Worksheet sheet = ((Spreadsheet) comp).getSelectedSheet();
    if (!Utils.getSheetUuid(sheet).equals(sheetId))
      return;
    
    if ("lc".equals(type)) {

View Full Code Here

Examples of org.zkoss.zss.ui.Spreadsheet

    
    final Map data = (Map) request.getData();
    if (data == null || data.size() != 14)
      throw new UiException(MZk.ILLEGAL_REQUEST_WRONG_DATA, new Object[] {Objects.toString(data), SelectSheetCommand.class });
    
    Spreadsheet spreadsheet = ((Spreadsheet) comp);
    String sheetId = (String) data.get("sheetId");
    boolean cacheInClient = (Boolean) data.get("cache");
    int row = (Integer)data.get("row");
    int col = (Integer)data.get("col");
    
    //selection
    int top = (Integer)data.get("top");
    int right = (Integer)data.get("right");
    int bottom = (Integer)data.get("bottom");
    int left = (Integer)data.get("left");
    
    //highlight
    int highlightLeft = (Integer)data.get("hleft");
    int highlightTop = (Integer)data.get("htop");
    int highlightRight = (Integer)data.get("hright");
    int highlightBottom = (Integer)data.get("hbottom");
    
    //freeze
    int rowfreeze = AuRequests.getInt(data, "frow", -1);
    int colfreeze = AuRequests.getInt(data, "fcol", -1);
    
    Book book = spreadsheet.getBook();
    int len = book.getNumberOfSheets();
    for (int i = 0; i < len; i++) {
      Worksheet sheet = book.getWorksheetAt(i);
      if (sheetId.equals(((SheetCtrl)sheet).getUuid())) {
        spreadsheet.setSelectedSheetDirectly(sheet.getSheetName(), cacheInClient, row, col, 
            left, top, right, bottom,
            highlightLeft, highlightTop, highlightRight, highlightBottom,
            rowfreeze, colfreeze);
        break;
      }

View Full Code Here

Examples of org.zkoss.zss.ui.Spreadsheet

  
  public void onFocusedEvent(CellEvent event){
    int row=event.getRow();
    int col=event.getColumn();
    
    Spreadsheet targetSpreadsheet;
    if(event.getTarget()==ss[0])
      ss[1].moveEditorFocus("ss1", "ss1", "red", row, col);
    else
      ss[0].moveEditorFocus("ss0", "ss0", "green", row, col);
  }

View Full Code Here

Examples of org.zkoss.zss.ui.Spreadsheet

  Spreadsheet spreadsheet;
  Book book;
  


  public void afterCompose() {
    spreadsheet = new Spreadsheet();
    windowPopupOnceByName("fileOpenViewWin");
    windowPopupOnceByName("menuPrintWin");
        try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
    } catch (Exception e) {

View Full Code Here

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

        }
        new SpreadsheetXLSExporter().exportToXLSSheets(writer, spreadsheets);
    }


    private Spreadsheet buildReport(final Degree degree, final SortedSet<SecondCycleIndividualCandidacyProcess> name) {
        final Spreadsheet spreadsheet = new Spreadsheet(degree.getSigla(), getHeader());


        for (final SecondCycleIndividualCandidacyProcess process : name) {
            final Row row = spreadsheet.addRow();
            row.setCell(process.getPersonalDetails().getName());
            row.setCell(process.getPrecedentDegreeInformation().getConclusionGrade());
            row.setCell(process.getCandidacyProfessionalExperience());
            row.setCell(process.getPrecedentDegreeInformation().getDegreeAndInstitutionName());
            row.setCell(process.getCandidacyAffinity());

View Full Code Here

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


    public abstract void renderReport(Spreadsheet spreadsheet) throws Exception;


    @Override
    public QueueJobResult execute() throws Exception {
        final Spreadsheet spreadsheet = new Spreadsheet(getReportName());


        this.renderReport(spreadsheet);


        ByteArrayOutputStream byteArrayOS = new ByteArrayOutputStream();


        if ("csv".compareTo(getType()) == 0) {
            spreadsheet.exportToCSV(byteArrayOS, "\t");
        } else {
            spreadsheet.exportToXLSSheet(byteArrayOS);
        }


        final QueueJobResult queueJobResult = new QueueJobResult();
        queueJobResult.setContentType("application/txt");
        queueJobResult.setContent(byteArrayOS.toByteArray());

View Full Code Here

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

        Set<Degree> degreesToInclude =
                AcademicAccessRule.getDegreesAccessibleToFunction(AcademicOperationType.STUDENT_LISTINGS, Authenticate.getUser())
                        .collect(Collectors.toSet());


        final String filename = getResourceMessage("label.statistics") + "_" + executionYear.getName().replace('/', '-');
        final Spreadsheet spreadsheet = new Spreadsheet(filename);
        addStatisticsHeaders(spreadsheet);
        addStatisticsInformation(spreadsheet, executionYear, degreesToInclude);


        response.setContentType("application/vnd.ms-excel");
        response.setHeader("Content-disposition", "attachment; filename=" + filename + ".xls");
        ServletOutputStream writer = response.getOutputStream();


        spreadsheet.exportToXLSSheet(writer);
        writer.flush();
        response.flushBuffer();


        return null;
    }

View Full Code Here

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

    }


    public ActionForward exportXLS(ActionMapping mapping, ActionForm form, HttpServletRequest request,
            HttpServletResponse response) throws IOException {
        SpecialSeasonStatusTrackerBean bean = getRenderedObject();
        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;
    }

View Full Code Here

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

        strBuilder.append(bean.getExecutionSemester().getExecutionYear().getName());
        return strBuilder.toString();
    }


    private Spreadsheet generateSpreadsheet(SpecialSeasonStatusTrackerBean bean) {
        final Spreadsheet spreadsheet = createSpreadSheet();
        for (final Enrolment enrolment : bean.getEnrolments()) {
            final Row row = spreadsheet.addRow();


            row.setCell(enrolment.getRegistration().getPerson().getUsername());
            row.setCell(enrolment.getRegistration().getNumber());
            row.setCell(enrolment.getRegistration().getPerson().getName());
            row.setCell(enrolment.getRegistration().getPerson().getInstitutionalOrDefaultEmailAddressValue());

View Full Code Here

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


        return spreadsheet;
    }


    private Spreadsheet createSpreadSheet() {
        final Spreadsheet spreadsheet = new Spreadsheet(BundleUtil.getString(Bundle.APPLICATION, "list.students"));


        spreadsheet.setHeaders(new String[] {


        BundleUtil.getString(Bundle.APPLICATION, "label.username"),


        BundleUtil.getString(Bundle.APPLICATION, "label.number"),

View Full Code Here

0 1 2 3 4 5

TOP

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.