Examples of output.ExcelFileFormulas

output.ExcelFileFormulas
Represents an Excel spreadsheet file and the process of populating it with the results of AlgebraToSpreadsheet. Do not forget to {@link #close} any instance - otherwise the file will not be written.

            @Override
            public void write(int b) {
                // nop
            }
        };
        this.eff = new ExcelFileFormulas(os);
        this.wb = eff.getWorkbookForTestPurposes();
        this.sheet = wb.getSheetAt(0);
        this.evaluated = false;
        this.resultRelation = null;
    }

View Full Code Here

            String xlsxOutputPath = String.format("%s/%s.xlsx", file.getParent(), Files.getNameWithoutExtension(file.toString()));
            System.out.println(String.format("Writing %s", xlsxOutputPath));


            try (
                FileOutputStream out = new FileOutputStream(xlsxOutputPath);
                ExcelFileFormulas excel = new ExcelFileFormulas(out)
            )
            {
                excel.addResult(result, QUIET_LAYOUT);
            } catch (FormulaParseException | IOException e) {
                System.err.format("Error: could not write file '%s'\n", xlsxOutputPath);
            }
        }
    }

View Full Code Here

     *
     * @throws FormulaParseException
     * @throws IOException      the file could not be written or closed
     */
    public void writeExcel(FileOutputStream file, Result r) throws FormulaParseException, IOException {
        try (ExcelFileFormulas excel = new ExcelFileFormulas(file)) {
            excel.addResult(r, BASIC_LAYOUT);
        }
    }

View Full Code Here

     * @throws IOException the file could not be open, written or closed
     */
    public void writeExcel(String fileName, Result r) throws FormulaParseException, IOException {
        try (
            FileOutputStream out = new FileOutputStream(fileName);
            ExcelFileFormulas excel = new ExcelFileFormulas(out)
        )
        {
            excel.addResult(r, BASIC_LAYOUT);
        }
    }

View Full Code Here

                    try (OutputStream os = new OutputStream() {
                        @Override
                        public void write(int b) throws IOException {
                            // nop
                        }};
                        ExcelFileFormulas eff = new ExcelFileFormulas(os)) {
                        eff.addResult(result, ExcelFileFormulas.QUIET_LAYOUT);
                    } catch (IOException e) {
                        throw new RuntimeException("internal error");
                    }
                } catch (ParseCancellationException | TranslationException e) {
                    throw new RuntimeException("internal error");

View Full Code Here

            }


            // TODO move the following inner try block outside the outer try block
            try (
                FileOutputStream out = new FileOutputStream(xlsxFile);
                ExcelFileFormulas excel = new ExcelFileFormulas(out);
            )
            {
                for (Result result : results) {
                    excel.addResult(result, QUIET_LAYOUT);
                }
                message0 = String.format("Done saving '%s'.", xlsxFilename);
                messageType0 = JOptionPane.INFORMATION_MESSAGE;
                includeOpenOption0 = true;
            } catch (Exception e) {

View Full Code Here

TOP

Related Classes of output.ExcelFileFormulas

adipe.translate.example.dir.App

adipe.translate.example.wizard.App

core.ColumnLabels

core.Evaluation

core.example.AlgebraToSpreadsheet

core.Formulas

org.apache.poi.ss.usermodel.Cell

org.apache.poi.ss.usermodel.CellStyle

org.apache.poi.ss.usermodel.ClientAnchor

org.apache.poi.ss.usermodel.Comment

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.