tech.nmfin.algoquant.web

Class SpreadsheetWorkbook

java.lang.Object

tech.nmfin.algoquant.web.SpreadsheetWorkbook

public final class SpreadsheetWorkbook
extends Object

Small OOXML export of one immutable snapshot; no desktop or spreadsheet runtime required.

Using this example. Packages existing snapshot data into OOXML worksheets and obtains scalar measure rows through PerformanceCsv. Numeric values remain numeric cells while display styles control decimal formatting. This utility writes exports without recalculating strategy performance.

Field Summary

Fields

Modifier and Type	Field and Description
static String	MIME
static String	NS

Constructor Summary

Constructors

Constructor and Description
SpreadsheetWorkbook()

Method Summary

Modifier and Type	Method and Description
static String	column(int index)
static void	entry(ZipOutputStream zip, String name, String body)
static byte[]	export(String[] names, String[] sheets)
static String	finish(StringBuilder s, String last, int row)
static void	header(StringBuilder s, String... labels)
static void	number(StringBuilder s, String cell, Double value, int style)
static String[]	sheetNames(String[] names)
static StringBuilder	start(int[] widths)
static String	statistics(List<AllPerformanceMeasures.Metric> metrics)
static String	table(String[] headers, List<List<Object>> rows)
static void	text(StringBuilder s, String cell, String value, int style)
static String	xml(String s)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

MIME

public static final String MIME

See Also:

Constant Field Values

NS

public static final String NS

See Also:

Constant Field Values

Constructor Detail

SpreadsheetWorkbook

public SpreadsheetWorkbook()

Method Detail

export

public static byte[] export(String[] names,
                            String[] sheets)
                     throws IOException

Throws:

IOException

statistics

public static String statistics(List<AllPerformanceMeasures.Metric> metrics)
                         throws IOException

Throws:

IOException

sheetNames

public static String[] sheetNames(String[] names)

column

public static String column(int index)

table

public static String table(String[] headers,
                           List<List<Object>> rows)

start

public static StringBuilder start(int[] widths)

header

public static void header(StringBuilder s,
                          String... labels)

finish

public static String finish(StringBuilder s,
                            String last,
                            int row)

text

public static void text(StringBuilder s,
                        String cell,
                        String value,
                        int style)

number

public static void number(StringBuilder s,
                          String cell,
                          Double value,
                          int style)

xml

public static String xml(String s)

entry

public static void entry(ZipOutputStream zip,
                         String name,
                         String body)
                  throws IOException

Throws:

IOException