Browsable SpreadsheetML Simplified Grammar

Grammar extracted by Vadim Zaytsev, see the Grammar Zoo entry for details: doc/office/spreadsheetml/simplified/extracted
Source used for this grammar: Hugo Brunelière, SpreadsheetMLSimplified 1.2, MSOfficeExcel_SpreadsheetMLSimplified.ecore, 2005/07/01

Summary

• Total 25 production rules with 26 top alternatives and 144 symbols.
• Vocabulary: 52 = 20 nonterminals + 2 terminals + 30 labels + 0 markers.
• Total 20 nonterminal symbols: 19 defined (Integer, String, Boolean, DateTimeType, ValueType, StringValue, NumberValue, DateTimeTypeValue, BooleanValue, ErrorValue, Workbook, Worksheet, Table, TableElement, ColOrRowElement, Column, Row, Cell, Data), 0 root (—), 1 top (TableElement), 1 bottom (Double ⁵).
• Total 2 terminal symbols: 2 keywords ("true", "false"), 0 letters (—), 0 numerics (—), 0 signs (—).
• Total 30 labels: [year], [month], [day], [hour], [minute], [second], [value] ⁵, [vt_data], [wb_worksheets], [ws_workbook], [ws_table], [name], [t_worksheet], [t_cols], [t_rows], [c_table], [autoFitWidth], [width], [r_table], [r_cells], [autoFitHeight], [height], [c_row], [arrayRange], [formula], [hRef], [mergeAcross], [mergeDown], [c_data], [d_cell].

Syntax

Integer ::=
	integer

String ::=
	string

Boolean ::=
	"true"
	"false"

DateTimeType ::=
	[year]::Integer [month]::Integer [day]::Integer [hour]::Integer [minute]::Integer [second]::Integer

ValueType ::=
	StringValue

ValueType ::=
	NumberValue

ValueType ::=
	DateTimeTypeValue

ValueType ::=
	BooleanValue

ValueType ::=
	ErrorValue

StringValue ::=
	[value]::String

NumberValue ::=
	[value]::Double

DateTimeTypeValue ::=
	[value]::DateTimeType

BooleanValue ::=
	[value]::Boolean

ErrorValue ::=
	[vt_data]::Data

Workbook ::=
	[wb_worksheets]::Worksheet+

Worksheet ::=
	[ws_workbook]::Workbook [ws_table]::Table [name]::String

Table ::=
	[t_worksheet]::Worksheet [t_cols]::Column+ [t_rows]::Row+

TableElement ::=
	ColOrRowElement

TableElement ::=
	Cell

ColOrRowElement ::=
	Column

ColOrRowElement ::=
	Row

Column ::=
	[c_table]::Table [autoFitWidth]::Boolean [width]::Double

Row ::=
	[r_table]::Table [r_cells]::Cell+ [autoFitHeight]::Boolean [height]::Double

Cell ::=
	[c_row]::Row [arrayRange]::String [formula]::String [hRef]::String [mergeAcross]::Double [mergeDown]::Double [c_data]::Data

Data ::=
	[d_cell]::Cell [value]::ValueType

Maintained by Dr. Vadim Zaytsev a.k.a. @grammarware. Last updated in September 2015. [↑]