Examples of SpreadsheetBuilder

Examples of org.formulacompiler.spreadsheet.internal.loader.builder.SpreadsheetBuilder

104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
    xlsSettings.setMergedCellChecking( false );
    xlsSettings.setPropertySets( false );
    xlsSettings.setSuppressWarnings( true );
    try {
      final jxl.Workbook xlsWorkbook = jxl.Workbook.getWorkbook( _stream, xlsSettings );
      final SpreadsheetBuilder spreadsheetBuilder = new SpreadsheetBuilder( ComputationMode.EXCEL );

      loadConfig( xlsWorkbook );

      for (final jxl.Sheet xlsSheet : xlsWorkbook.getSheets()) {
        final SheetBuilder sheetBuilder = spreadsheetBuilder.beginSheet( xlsSheet.getName() );
        loadRows( xlsSheet, sheetBuilder );
        sheetBuilder.endSheet();
      }

      final BaseSpreadsheet workbook = spreadsheetBuilder.getSpreadsheet();
      loadNames( xlsWorkbook, workbook );
      return workbook;
    }
    catch (jxl.read.biff.BiffException e) {
      throw new SpreadsheetException.LoadError( "Error parsing " + _originalFileName, e );
View Full Code Here

Examples of org.formulacompiler.spreadsheet.internal.loader.builder.SpreadsheetBuilder

82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
    throw new SpreadsheetException.LoadError( "<content.xml> is missing in <" + _originalFileName + ">" );
  }

  private Spreadsheet readContent( String _fileName, InputStream _inputStream ) throws SpreadsheetException
  {
    final SpreadsheetBuilder spreadsheetBuilder = new SpreadsheetBuilder( ComputationMode.OPEN_OFFICE_CALC );

    try {
      final SpreadsheetParser spreadsheetParser = new SpreadsheetParser( spreadsheetBuilder, this.config );
      final Parser parser = new Parser( Collections.singletonMap( XMLConstants.Office.SPREADSHEET, spreadsheetParser ) );
      parser.parse( _inputStream );
    }
    catch (XMLStreamException e) {
      final Throwable nestedException = e.getNestedException();
      if (nestedException != null) {
        e.initCause( nestedException );
      }
      throw new SpreadsheetException.LoadError( "Error loading " + _fileName, e );
    }

    return spreadsheetBuilder.getSpreadsheet();
  }
View Full Code Here

Examples of pt.utl.ist.fenix.tools.spreadsheet.SpreadsheetBuilder

116
117
118
119
120
121
122
123
124
125
126
        try {
            try {
                SheetData<?> builder = exportTemplate(request, filter);
                response.setContentType("text/csv");
                response.setHeader("Content-disposition", "attachment; filename=template.tsv");
                new SpreadsheetBuilder().addSheet("template", builder)
                        .build(WorkbookExportFormat.TSV, response.getOutputStream());
                return null;
            } finally {
                response.flushBuffer();
            }
View Full Code Here

Examples of pt.utl.ist.fenix.tools.spreadsheet.SpreadsheetBuilder

102
103
104
105
106
107
108
109
110
111
112
        response.setContentType("application/vnd.ms-excel");
        response.setHeader("Content-disposition", "attachment; filename=" + getReportFilename(bean));

        final ServletOutputStream writer = response.getOutputStream();
        new SpreadsheetBuilder().addSheet(getReportFilename(bean), spreadsheet).addConverter(Money.class, new CellConverter() {
            @Override
            public Object convert(Object source) {
                return (source != null) ? ((Money) source).getAmount().doubleValue() : Double.valueOf(0d);
            }
        }).build(WorkbookExportFormat.EXCEL, writer);
View Full Code Here

Examples of pt.utl.ist.fenix.tools.spreadsheet.SpreadsheetBuilder

142
143
144
145
146
147
148
149
150
151
152
        try {
            response.setContentType("application/vnd.ms-excel");
            response.setHeader("Content-disposition", "attachment; filename=" + prefix + calculateMin(codes) + "-"
                    + calculateMax(codes) + "(" + codes.size() + ")" + ".xls");
            final ServletOutputStream writer = response.getOutputStream();
            new SpreadsheetBuilder().addSheet("lote", data).build(WorkbookExportFormat.EXCEL, writer);
            writer.flush();
            response.flushBuffer();
        } catch (IOException e) {
            throw new DomainException("error.rectorateSubmission.errorGeneratingMetadata", e);
        }
View Full Code Here

Examples of pt.utl.ist.fenix.tools.spreadsheet.SpreadsheetBuilder

241
242
243
244
245
246
247
248
249
250
251
        try {
            response.setContentType("application/vnd.ms-excel");
            response.setHeader("Content-disposition", "attachment; filename=" + prefix + min + "-" + max + "(" + codes.size()
                    + ")" + ".xls");
            final ServletOutputStream writer = response.getOutputStream();
            new SpreadsheetBuilder().addSheet("lote", data).build(WorkbookExportFormat.EXCEL, writer);
            writer.flush();
            response.flushBuffer();
        } catch (IOException e) {
            throw new DomainException("error.rectorateSubmission.errorGeneratingMetadata", e);
        }
View Full Code Here

Examples of pt.utl.ist.fenix.tools.spreadsheet.SpreadsheetBuilder

140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
            public int compare(Enrolment o1, Enrolment o2) {
                return o1.getPerson().getName().compareTo(o2.getPerson().getName());
            }
        });

        final SpreadsheetBuilder builder = new SpreadsheetBuilder();
        builder.addSheet(semester.getQualifiedName().replace("/", "_"), new SheetData<Enrolment>(enrolments) {

            @Override
            protected void makeLine(final Enrolment enrolment) {
                // TODO: add to phd resource bundle
                addCell(getMessageFromResource("label.phd.number"), enrolment.getRegistration().getNumber());
                addCell(getMessageFromResource("label.phd.name"), enrolment.getPerson().getName());
                addCell(getMessageFromResource("label.phd.email"), enrolment.getPerson()
                        .getInstitutionalOrDefaultEmailAddressValue());
            }
        });

        final ByteArrayOutputStream output = new ByteArrayOutputStream();
        builder.build(WorkbookExportFormat.EXCEL, output);
        return output.toByteArray();
    }
View Full Code Here

Examples of pt.utl.ist.fenix.tools.spreadsheet.SpreadsheetBuilder

151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
        ByteArrayOutputStream byteArrayOSForTransactions = new ByteArrayOutputStream();
        StringBuilder errors = new StringBuilder();

        SheetData[] reports = buildReport(errors);

        SpreadsheetBuilder spreadsheetBuilderForDebts = new SpreadsheetBuilder();
        SpreadsheetBuilder spreadsheetBuilderForExemptions = new SpreadsheetBuilder();
        SpreadsheetBuilder spreadsheetBuilderForTransactions = new SpreadsheetBuilder();

        spreadsheetBuilderForDebts.addSheet("dividas", reports[0]);
        spreadsheetBuilderForExemptions.addSheet("isencoes", reports[1]);
        spreadsheetBuilderForTransactions.addSheet("transaccoes", reports[2]);

        spreadsheetBuilderForDebts.build(WorkbookExportFormat.TSV, byteArrayOSForDebts);
        spreadsheetBuilderForExemptions.build(WorkbookExportFormat.TSV, byteArrayOSForExemptions);
        spreadsheetBuilderForTransactions.build(WorkbookExportFormat.TSV, byteArrayOSForTransactions);

        byteArrayOSForDebts.close();
        byteArrayOSForExemptions.close();
        byteArrayOSForTransactions.close();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.