001package com.hfg.xml.msofficexml.xlsx.spreadsheetml; 002 003 004import com.hfg.xml.XMLName; 005import com.hfg.xml.XMLNamespace; 006 007import java.io.File; 008 009//------------------------------------------------------------------------------ 010/** 011 Office Open XML SpreadsheetML tag and attribute name definitions. 012 013 @author J. Alex Taylor, hairyfatguy.com 014 */ 015//------------------------------------------------------------------------------ 016// com.hfg XML/HTML Coding Library 017// 018// This library is free software; you can redistribute it and/or 019// modify it under the terms of the GNU Lesser General Public 020// License as published by the Free Software Foundation; either 021// version 2.1 of the License, or (at your option) any later version. 022// 023// This library is distributed in the hope that it will be useful, 024// but WITHOUT ANY WARRANTY; without even the implied warranty of 025// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU 026// Lesser General Public License for more details. 027// 028// You should have received a copy of the GNU Lesser General Public 029// License along with this library; if not, write to the Free Software 030// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA 031// 032// J. Alex Taylor, President, Founder, CEO, COO, CFO, OOPS hairyfatguy.com 033// jataylor@hairyfatguy.com 034//------------------------------------------------------------------------------ 035 036public class SsmlXML 037{ 038 public static final String XL_DIR = "xl"; 039 public static final File WORKBOOK_FILE = new File(XL_DIR, "workbook.xml"); 040 public static final File RELS_DIR = new File(XL_DIR, "_rels"); 041 public static final File WORKBOOK_RELATIONSHIP_FILE = new File(RELS_DIR, "workbook.xml.rels"); 042 public static final File WORKSHEETS_DIR = new File(XL_DIR, "worksheets"); 043 public static final File STYLES_FILE = new File(XL_DIR, "styles.xml"); 044 public static final File SHARED_STRINGS_FILE = new File(XL_DIR, "sharedStrings.xml"); 045 public static final File DRAWINGS_DIR = new File(XL_DIR, "drawings"); 046 public static final File THEME_DIR = new File(XL_DIR, "theme"); 047 048 public static final XMLNamespace SPREADSHEETML_NAMESPACE = XMLNamespace.getNamespace("ssml", "http://schemas.openxmlformats.org/spreadsheetml/2006/main"); 049 public static final XMLNamespace EXCEL_2006_NAMESPACE = XMLNamespace.getNamespace("xm", "http://schemas.microsoft.com/office/excel/2006/main"); 050 public static final XMLNamespace SPREADSHEETML_2009_NAMESPACE = XMLNamespace.getNamespace("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main"); 051 public static final XMLNamespace SPREADSHEETML_2009AC_NAMESPACE = XMLNamespace.getNamespace("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"); 052 public static final XMLNamespace SPREADSHEETML_REVISION1_NAMESPACE = XMLNamespace.getNamespace("xr", "http://schemas.microsoft.com/office/spreadsheetml/2014/revision"); 053 public static final XMLNamespace SPREADSHEETML_REVISION2_NAMESPACE = XMLNamespace.getNamespace("xr2", "http://schemas.microsoft.com/office/spreadsheetml/2015/revision2"); 054 public static final XMLNamespace SPREADSHEETML_REVISION3_NAMESPACE = XMLNamespace.getNamespace("xr3", "http://schemas.microsoft.com/office/spreadsheetml/2016/revision3"); 055 056 // Tag names 057 public static final XMLName ALIGNMENT = new XMLName("alignment", SPREADSHEETML_NAMESPACE); 058 public static final XMLName AUTHOR = new XMLName("author", SPREADSHEETML_NAMESPACE); 059 public static final XMLName AUTHORS = new XMLName("authors", SPREADSHEETML_NAMESPACE); 060 public static final XMLName AUTO_FILTER = new XMLName("autoFilter", SPREADSHEETML_NAMESPACE); 061 public static final XMLName BG_COLOR = new XMLName("bgColor", SPREADSHEETML_NAMESPACE); 062 public static final XMLName BOLD = new XMLName("b", SPREADSHEETML_NAMESPACE); 063 public static final XMLName BORDER = new XMLName("border", SPREADSHEETML_NAMESPACE); 064 public static final XMLName BORDERS = new XMLName("borders", SPREADSHEETML_NAMESPACE); 065 public static final XMLName BOTTOM = new XMLName("bottom", SPREADSHEETML_NAMESPACE); 066 public static final XMLName CELL = new XMLName("c", SPREADSHEETML_NAMESPACE); 067 public static final XMLName CELL_FORMATS = new XMLName("cellXfs", SPREADSHEETML_NAMESPACE); 068 public static final XMLName CONDENSE = new XMLName("condense", SPREADSHEETML_NAMESPACE); 069 public static final XMLName CELL_FORMAT = new XMLName("xf", SPREADSHEETML_NAMESPACE); 070 public static final XMLName CELL_FORMULA = new XMLName("f", SPREADSHEETML_NAMESPACE); 071 public static final XMLName CELL_STYLE = new XMLName("cellStyle", SPREADSHEETML_NAMESPACE); 072 public static final XMLName CELL_STYLES = new XMLName("cellStyles", SPREADSHEETML_NAMESPACE); 073 public static final XMLName CELL_STYLE_FORMATS = new XMLName("cellStyleXfs", SPREADSHEETML_NAMESPACE); 074 public static final XMLName COLOR = new XMLName("color", SPREADSHEETML_NAMESPACE); 075 public static final XMLName COLOR_SCALE = new XMLName("colorScale", SPREADSHEETML_NAMESPACE); 076 public static final XMLName COLUMN = new XMLName("col", SPREADSHEETML_NAMESPACE); 077 public static final XMLName COLUMNS = new XMLName("cols", SPREADSHEETML_NAMESPACE); 078 public static final XMLName COMMENT = new XMLName("comment", SPREADSHEETML_NAMESPACE); 079 public static final XMLName COMMENTS = new XMLName("comments", SPREADSHEETML_NAMESPACE); 080 public static final XMLName COMMENT_LIST = new XMLName("commentList", SPREADSHEETML_NAMESPACE); 081 public static final XMLName COMMENT_TEXT = new XMLName("text", SPREADSHEETML_NAMESPACE); 082 public static final XMLName CONDITIONAL_FORMATTING = new XMLName("conditionalFormatting", SPREADSHEETML_NAMESPACE); 083 public static final XMLName CONDITIONAL_FORMATTING_VALUE_OBJ = new XMLName("cfvo", SPREADSHEETML_NAMESPACE); 084 public static final XMLName CONDITIONAL_FORMATTING_RULE = new XMLName("cfRule", SPREADSHEETML_NAMESPACE); 085 public static final XMLName DATA_BAR = new XMLName("dataBar", SPREADSHEETML_NAMESPACE); 086 public static final XMLName DATA_VALIDATION = new XMLName("dataValidation", SPREADSHEETML_NAMESPACE); 087 public static final XMLName DATA_VALIDATIONS = new XMLName("dataValidations", SPREADSHEETML_NAMESPACE); 088 public static final XMLName DEFINED_NAMES = new XMLName("definedNames", SPREADSHEETML_NAMESPACE); 089 public static final XMLName DEFINED_NAME = new XMLName("definedName", SPREADSHEETML_NAMESPACE); 090 public static final XMLName DIAGONAL = new XMLName("diagonal", SPREADSHEETML_NAMESPACE); 091 public static final XMLName DIFFERENTIAL_FORMAT = new XMLName("dxf", SPREADSHEETML_NAMESPACE); 092 public static final XMLName DIFFERENTIAL_FORMATS = new XMLName("dxfs", SPREADSHEETML_NAMESPACE); 093 public static final XMLName DIMENSION = new XMLName("dimension", SPREADSHEETML_NAMESPACE); 094 public static final XMLName DRAWING = new XMLName("drawing", SPREADSHEETML_NAMESPACE); 095 public static final XMLName END = new XMLName("end", SPREADSHEETML_NAMESPACE); 096 public static final XMLName EVEN_FOOTER = new XMLName("evenFooter", SPREADSHEETML_NAMESPACE); 097 public static final XMLName EVEN_HEADER = new XMLName("evenHeader", SPREADSHEETML_NAMESPACE); 098 public static final XMLName EXTEND = new XMLName("extend", SPREADSHEETML_NAMESPACE); 099 public static final XMLName EXTENSION = new XMLName("ext", SPREADSHEETML_NAMESPACE); 100 public static final XMLName EXTENSION_LIST = new XMLName("extLst", SPREADSHEETML_NAMESPACE); 101 public static final XMLName FG_COLOR = new XMLName("fgColor", SPREADSHEETML_NAMESPACE); 102 public static final XMLName FILL = new XMLName("fill", SPREADSHEETML_NAMESPACE); 103 public static final XMLName FILLS = new XMLName("fills", SPREADSHEETML_NAMESPACE); 104 public static final XMLName FIRST_FOOTER = new XMLName("firstFooter", SPREADSHEETML_NAMESPACE); 105 public static final XMLName FIRST_HEADER = new XMLName("firstHeader", SPREADSHEETML_NAMESPACE); 106 public static final XMLName FONT = new XMLName("font", SPREADSHEETML_NAMESPACE); 107 public static final XMLName FONTS = new XMLName("fonts", SPREADSHEETML_NAMESPACE); 108 public static final XMLName FORMULA = new XMLName("formula", SPREADSHEETML_NAMESPACE); 109 public static final XMLName FORMULA1 = new XMLName("formula1", SPREADSHEETML_NAMESPACE); 110 public static final XMLName GRADIENT_FILL = new XMLName("gradientFill", SPREADSHEETML_NAMESPACE); 111 public static final XMLName HEADER_FOOTER = new XMLName("headerFooter", SPREADSHEETML_NAMESPACE); 112 public static final XMLName HORIZONTAL = new XMLName("horizontal", SPREADSHEETML_NAMESPACE); 113 public static final XMLName ID = new XMLName("id", SPREADSHEETML_NAMESPACE); 114 public static final XMLName INLINE_STRING = new XMLName("is", SPREADSHEETML_NAMESPACE); 115 public static final XMLName ITALIC = new XMLName("i", SPREADSHEETML_NAMESPACE); 116 public static final XMLName LEFT = new XMLName("left", SPREADSHEETML_NAMESPACE); 117 public static final XMLName MERGE_CELL = new XMLName("mergeCell", SPREADSHEETML_NAMESPACE); 118 public static final XMLName MERGE_CELLS = new XMLName("mergeCells", SPREADSHEETML_NAMESPACE); 119 public static final XMLName NAME = new XMLName("name", SPREADSHEETML_NAMESPACE); 120 public static final XMLName NUM_FORMAT = new XMLName("numFmt", SPREADSHEETML_NAMESPACE); 121 public static final XMLName NUM_FORMATS = new XMLName("numFmts", SPREADSHEETML_NAMESPACE); 122 public static final XMLName ODD_FOOTER = new XMLName("oddFooter", SPREADSHEETML_NAMESPACE); 123 public static final XMLName ODD_HEADER = new XMLName("oddHeader", SPREADSHEETML_NAMESPACE); 124 public static final XMLName PAGE_MARGINS = new XMLName("pageMargins", SPREADSHEETML_NAMESPACE); 125 public static final XMLName PANE = new XMLName("pane", SPREADSHEETML_NAMESPACE); 126 public static final XMLName PATTERN_FILL = new XMLName("patternFill", SPREADSHEETML_NAMESPACE); 127 public static final XMLName REF = new XMLName("ref", SPREADSHEETML_NAMESPACE); 128 public static final XMLName RIGHT = new XMLName("right", SPREADSHEETML_NAMESPACE); 129 public static final XMLName ROW = new XMLName("row", SPREADSHEETML_NAMESPACE); 130 public static final XMLName SELECTION = new XMLName("selection", SPREADSHEETML_NAMESPACE); 131 public static final XMLName SHADOW = new XMLName("shadow", SPREADSHEETML_NAMESPACE); 132 public static final XMLName SHARED_STRING_TABLE = new XMLName("sst", SPREADSHEETML_NAMESPACE); 133 public static final XMLName SHEET = new XMLName("sheet", SPREADSHEETML_NAMESPACE); 134 public static final XMLName SHEET_DATA = new XMLName("sheetData", SPREADSHEETML_NAMESPACE); 135 public static final XMLName SHEET_FORMAT_PROPS = new XMLName("sheetFormatPr", SPREADSHEETML_NAMESPACE); 136 public static final XMLName SHEET_PROPS = new XMLName("sheetPr", SPREADSHEETML_NAMESPACE); 137 public static final XMLName SHEET_VIEW = new XMLName("sheetView", SPREADSHEETML_NAMESPACE); 138 public static final XMLName SHEET_VIEWS = new XMLName("sheetViews", SPREADSHEETML_NAMESPACE); 139 public static final XMLName SHEETS = new XMLName("sheets", SPREADSHEETML_NAMESPACE); 140 public static final XMLName SIZE = new XMLName("sz", SPREADSHEETML_NAMESPACE); 141 public static final XMLName SORT_STATE = new XMLName("sortState", SPREADSHEETML_NAMESPACE); 142 public static final XMLName START = new XMLName("start", SPREADSHEETML_NAMESPACE); 143 public static final XMLName STRIKE = new XMLName("strike", SPREADSHEETML_NAMESPACE); 144 public static final XMLName STRING_ITEM = new XMLName("si", SPREADSHEETML_NAMESPACE); 145 public static final XMLName STYLESHEET = new XMLName("styleSheet", SPREADSHEETML_NAMESPACE); 146 public static final XMLName TAB_COLOR = new XMLName("tabColor", SPREADSHEETML_NAMESPACE); 147 public static final XMLName TABLE = new XMLName("table", SPREADSHEETML_NAMESPACE); 148 public static final XMLName TABLE_COLUMN = new XMLName("tableColumn", SPREADSHEETML_NAMESPACE); 149 public static final XMLName TABLE_COLUMNS = new XMLName("tableColumns", SPREADSHEETML_NAMESPACE); 150 public static final XMLName TABLE_PART = new XMLName("tablePart", SPREADSHEETML_NAMESPACE); 151 public static final XMLName TABLE_PARTS = new XMLName("tableParts", SPREADSHEETML_NAMESPACE); 152 public static final XMLName TEXT = new XMLName("t", SPREADSHEETML_NAMESPACE); 153 public static final XMLName TEXT_RUN = new XMLName("r", SPREADSHEETML_NAMESPACE); 154 public static final XMLName TEXT_RUN_FONT = new XMLName("rFont", SPREADSHEETML_NAMESPACE); 155 public static final XMLName TEXT_RUN_PROPS = new XMLName("rPr", SPREADSHEETML_NAMESPACE); 156 public static final XMLName TOP = new XMLName("top", SPREADSHEETML_NAMESPACE); 157 public static final XMLName UNDERLINE = new XMLName("u", SPREADSHEETML_NAMESPACE); 158 public static final XMLName VALUE = new XMLName("v", SPREADSHEETML_NAMESPACE); 159 public static final XMLName VERTICAL = new XMLName("vertical", SPREADSHEETML_NAMESPACE); 160 public static final XMLName VERTICAL_ALIGN = new XMLName("vertAlign", SPREADSHEETML_NAMESPACE); 161 public static final XMLName WORKBOOK = new XMLName("workbook", SPREADSHEETML_NAMESPACE); 162 public static final XMLName WORKBOOK_PROPS = new XMLName("workbookPr", SPREADSHEETML_NAMESPACE); 163 public static final XMLName WORKBOOK_VIEW = new XMLName("workbookView", SPREADSHEETML_NAMESPACE); 164 public static final XMLName WORKBOOK_VIEWS = new XMLName("bookViews", SPREADSHEETML_NAMESPACE); 165 public static final XMLName WORKSHEET = new XMLName("worksheet", SPREADSHEETML_NAMESPACE); 166 167 public static final XMLName XM_SQREF = new XMLName("sqref", EXCEL_2006_NAMESPACE); 168 169 public static final XMLName X14_AXIS_COLOR = new XMLName("axisColor", SPREADSHEETML_2009_NAMESPACE); 170 public static final XMLName X14_BORDER_COLOR = new XMLName("borderColor", SPREADSHEETML_2009_NAMESPACE); 171 public static final XMLName X14_CONDITIONAL_FORMATTING = new XMLName("conditionalFormatting", SPREADSHEETML_2009_NAMESPACE); 172 public static final XMLName X14_CONDITIONAL_FORMATTING_RULE = new XMLName("cfRule", SPREADSHEETML_2009_NAMESPACE); 173 public static final XMLName X14_CONDITIONAL_FORMATTING_VALUE_OBJ = new XMLName("cfvo", SPREADSHEETML_2009_NAMESPACE); 174 public static final XMLName X14_CONDITIONAL_FORMATTINGS = new XMLName("conditionalFormattings", SPREADSHEETML_2009_NAMESPACE); 175 public static final XMLName X14_DATA_BAR = new XMLName("dataBar", SPREADSHEETML_2009_NAMESPACE); 176 public static final XMLName X14_FILL_COLOR = new XMLName("fillColor", SPREADSHEETML_2009_NAMESPACE); 177 public static final XMLName X14_ID = new XMLName("id", SPREADSHEETML_2009_NAMESPACE); 178 public static final XMLName X14_NEGATIVE_BORDER_COLOR = new XMLName("negativeBorderColor", SPREADSHEETML_2009_NAMESPACE); 179 public static final XMLName X14_NEGATIVE_FILL_COLOR = new XMLName("negativeFillColor", SPREADSHEETML_2009_NAMESPACE); 180 181 public static final XMLName X14_BORDER_ATT = new XMLName("border"); 182 public static final XMLName X14_GRADIENT_ATT = new XMLName("gradient"); 183 184 // Attribute names 185 public static final XMLName ABOVE_AVG_ATT = new XMLName("aboveAverage", SPREADSHEETML_NAMESPACE); 186 public static final XMLName ACTIVE_CELL_ATT = new XMLName("activeCell", SPREADSHEETML_NAMESPACE); 187 public static final XMLName ACTIVE_PANE_ATT = new XMLName("activePane", SPREADSHEETML_NAMESPACE); 188 public static final XMLName ALIGN_WITH_MARGINS_ATT = new XMLName("alignWithMargins", SPREADSHEETML_NAMESPACE); 189 public static final XMLName ALLOW_BLANK_ATT = new XMLName("allowBlank", SPREADSHEETML_NAMESPACE); 190 public static final XMLName APPLY_ALIGNMENT_ATT = new XMLName("applyAlignment", SPREADSHEETML_NAMESPACE); 191 public static final XMLName APPLY_BORDER_ATT = new XMLName("applyBorder", SPREADSHEETML_NAMESPACE); 192 public static final XMLName APPLY_FILL_ATT = new XMLName("applyFill", SPREADSHEETML_NAMESPACE); 193 public static final XMLName APPLY_FONT_ATT = new XMLName("applyFont", SPREADSHEETML_NAMESPACE); 194 public static final XMLName APPLY_NUM_FORMAT_ATT = new XMLName("applyNumberFormat", SPREADSHEETML_NAMESPACE); 195 public static final XMLName AUTO_ATT = new XMLName("auto", SPREADSHEETML_NAMESPACE); 196 public static final XMLName AUTO_COMPRESS_PICS_ATT = new XMLName("autoCompressPictures", SPREADSHEETML_NAMESPACE); 197 public static final XMLName BASE_COL_WIDTH_ATT = new XMLName("baseColWidth", SPREADSHEETML_NAMESPACE); 198 public static final XMLName BORDER_ID_ATT = new XMLName("borderId", SPREADSHEETML_NAMESPACE); 199 public static final XMLName BOTTOM_ATT = new XMLName("bottom", SPREADSHEETML_NAMESPACE); 200 public static final XMLName BUILTIN_ID_ATT = new XMLName("builtinId", SPREADSHEETML_NAMESPACE); 201 public static final XMLName CELL_DATA_TYPE_ATT = new XMLName("t", SPREADSHEETML_NAMESPACE); 202 public static final XMLName COLOR_ID_ATT = new XMLName("colorId", SPREADSHEETML_NAMESPACE); 203 public static final XMLName CUSTOM_BUILTIN_ATT = new XMLName("customBuiltin", SPREADSHEETML_NAMESPACE); 204 public static final XMLName CUSTOM_HEIGHT_ATT = new XMLName("customHeight", SPREADSHEETML_NAMESPACE); 205 public static final XMLName CUSTOM_WIDTH_ATT = new XMLName("customWidth", SPREADSHEETML_NAMESPACE); 206 public static final XMLName DATE1904_ATT = new XMLName("date1904", SPREADSHEETML_NAMESPACE); 207 public static final XMLName DEFAULT_COL_WIDTH_ATT= new XMLName("defaultColWidth", SPREADSHEETML_NAMESPACE); 208 public static final XMLName DEFAULT_ROW_HEIGHT_ATT= new XMLName("defaultRowHeight", SPREADSHEETML_NAMESPACE); 209 public static final XMLName DEFAULT_GRID_COLOR = new XMLName("defaultGridColor", SPREADSHEETML_NAMESPACE); 210 public static final XMLName DIFFERENT_FIRST_ATT = new XMLName("differentFirst", SPREADSHEETML_NAMESPACE); 211 public static final XMLName DIFFERENT_ODD_EVEN_ATT = new XMLName("differentOddEven", SPREADSHEETML_NAMESPACE); 212 public static final XMLName DIFFERENTIAL_FORMAT_ID_ATT = new XMLName("dxfId", SPREADSHEETML_NAMESPACE); 213 public static final XMLName DISPLAY_NAME_ATT = new XMLName("displayName", SPREADSHEETML_NAMESPACE); 214 public static final XMLName EQUAL_AVG_ATT = new XMLName("equalAverage", SPREADSHEETML_NAMESPACE); 215 public static final XMLName FILL_ID_ATT = new XMLName("fillId", SPREADSHEETML_NAMESPACE); 216 public static final XMLName FONT_ID_ATT = new XMLName("fontId", SPREADSHEETML_NAMESPACE); 217 public static final XMLName FOOTER_ATT = new XMLName("footer", SPREADSHEETML_NAMESPACE); 218 public static final XMLName FORMAT_CODE_ATT = new XMLName("formatCode", SPREADSHEETML_NAMESPACE); 219 public static final XMLName HEADER_ATT = new XMLName("header", SPREADSHEETML_NAMESPACE); 220 public static final XMLName HEIGHT_ATT = new XMLName("ht", SPREADSHEETML_NAMESPACE); 221 public static final XMLName HIDDEN_ATT = new XMLName("hidden", SPREADSHEETML_NAMESPACE); 222 public static final XMLName HORIZONTAL_ATT = new XMLName("horizontal", SPREADSHEETML_NAMESPACE); 223 public static final XMLName ID_ATT = new XMLName("id", SPREADSHEETML_NAMESPACE); 224 public static final XMLName INDEXED_ATT = new XMLName("indexed", SPREADSHEETML_NAMESPACE); 225 public static final XMLName LEFT_ATT = new XMLName("left", SPREADSHEETML_NAMESPACE); 226 public static final XMLName LOCAL_SHEET_ID_ATT = new XMLName("localSheetId", SPREADSHEETML_NAMESPACE); 227 public static final XMLName MAX_ATT = new XMLName("max", SPREADSHEETML_NAMESPACE); 228 public static final XMLName MAX_LENGTH_ATT = new XMLName("maxLength", SPREADSHEETML_NAMESPACE); 229 public static final XMLName MIN_ATT = new XMLName("min", SPREADSHEETML_NAMESPACE); 230 public static final XMLName MIN_LENGTH_ATT = new XMLName("minLength", SPREADSHEETML_NAMESPACE); 231 public static final XMLName NAME_ATT = new XMLName("name", SPREADSHEETML_NAMESPACE); 232 public static final XMLName NUM_FORMAT_ID_ATT = new XMLName("numFmtId", SPREADSHEETML_NAMESPACE); 233 public static final XMLName OPERATOR_ATT = new XMLName("operator", SPREADSHEETML_NAMESPACE); 234 public static final XMLName OUTLINE_LEVEL_COL_ATT= new XMLName("outlineLevelCol", SPREADSHEETML_NAMESPACE); 235 public static final XMLName OUTLINE_LEVEL_ROW_ATT= new XMLName("outlineLevelRow", SPREADSHEETML_NAMESPACE); 236 public static final XMLName PATTERN_TYPE_ATT = new XMLName("patternType", SPREADSHEETML_NAMESPACE); 237 public static final XMLName PERCENT_ATT = new XMLName("percent", SPREADSHEETML_NAMESPACE); 238 public static final XMLName PIVOT_ATT = new XMLName("pivot", SPREADSHEETML_NAMESPACE); 239 public static final XMLName PRIORITY_ATT = new XMLName("priority", SPREADSHEETML_NAMESPACE); 240 public static final XMLName RANK_ATT = new XMLName("rank", SPREADSHEETML_NAMESPACE); 241 public static final XMLName REF_ATT = new XMLName("r", SPREADSHEETML_NAMESPACE); 242 public static final XMLName REF_RANGE_ATT = new XMLName("ref", SPREADSHEETML_NAMESPACE); 243 public static final XMLName RGB_ATT = new XMLName("rgb", SPREADSHEETML_NAMESPACE); 244 public static final XMLName RIGHT_ATT = new XMLName("right", SPREADSHEETML_NAMESPACE); 245 public static final XMLName RIGHT_TO_LEFT_ATT = new XMLName("rightToLeft", SPREADSHEETML_NAMESPACE); 246 public static final XMLName ROW_IDX_ATT = new XMLName("r", SPREADSHEETML_NAMESPACE); 247 public static final XMLName SCALE_WITH_DOC_ATT = new XMLName("scaleWithDoc", SPREADSHEETML_NAMESPACE); 248 public static final XMLName SEQ_OF_REFS_ATT = new XMLName("sqref", SPREADSHEETML_NAMESPACE); 249 public static final XMLName SHEET_ID_ATT = new XMLName("sheetId", SPREADSHEETML_NAMESPACE); 250 public static final XMLName SHOW_FORMULAS_ATT = new XMLName("showFormulas", SPREADSHEETML_NAMESPACE); 251 public static final XMLName SHOW_GRID_LINES_ATT = new XMLName("showGridLines", SPREADSHEETML_NAMESPACE); 252 public static final XMLName SHOW_INK_ANNOTATION_ATT = new XMLName("showInkAnnotation", SPREADSHEETML_NAMESPACE); 253 public static final XMLName SHOW_OUTLINE_SYMBOLS_ATT = new XMLName("showOutlineSymbols", SPREADSHEETML_NAMESPACE); 254 public static final XMLName SHOW_ROW_COL_HEADERS_ATT = new XMLName("showRowColHeaders", SPREADSHEETML_NAMESPACE); 255 public static final XMLName SHOW_RULER_ATT = new XMLName("showRuler", SPREADSHEETML_NAMESPACE); 256 public static final XMLName SHOW_VALUE_ATT = new XMLName("showValue", SPREADSHEETML_NAMESPACE); 257 public static final XMLName SHOW_WHITE_SPACE_ATT = new XMLName("showWhiteSpace", SPREADSHEETML_NAMESPACE); 258 public static final XMLName SHOW_ZEROS_ATT = new XMLName("showZeros", SPREADSHEETML_NAMESPACE); 259 public static final XMLName SPANS_ATT = new XMLName("spans", SPREADSHEETML_NAMESPACE); 260 public static final XMLName SQUARE_REF_ATT = new XMLName("sqref", SPREADSHEETML_NAMESPACE); 261 public static final XMLName STATE_ATT = new XMLName("state", SPREADSHEETML_NAMESPACE); 262 public static final XMLName STD_DEV_ATT = new XMLName("stdDev", SPREADSHEETML_NAMESPACE); 263 public static final XMLName STOP_IF_TRUE_ATT = new XMLName("stopIfTrue", SPREADSHEETML_NAMESPACE); 264 public static final XMLName STYLE_ATT = new XMLName("style", SPREADSHEETML_NAMESPACE); 265 public static final XMLName STYLE_IDX_ATT = new XMLName("s", SPREADSHEETML_NAMESPACE); 266 public static final XMLName TAB_SELECTED_ATT = new XMLName("tabSelected", SPREADSHEETML_NAMESPACE); 267 public static final XMLName TEXT_ATT = new XMLName("text", SPREADSHEETML_NAMESPACE); 268 public static final XMLName TEXT_ROTATION_ATT = new XMLName("textRotation", SPREADSHEETML_NAMESPACE); 269 public static final XMLName THEME_ATT = new XMLName("theme", SPREADSHEETML_NAMESPACE); 270 public static final XMLName THICK_BOTTOM_ATT = new XMLName("thickBottom", SPREADSHEETML_NAMESPACE); 271 public static final XMLName THICK_TOP_ATT = new XMLName("thickTop", SPREADSHEETML_NAMESPACE); 272 public static final XMLName TIME_PERIOD_ATT = new XMLName("timePeriod", SPREADSHEETML_NAMESPACE); 273 public static final XMLName TINT_ATT = new XMLName("tint", SPREADSHEETML_NAMESPACE); 274 public static final XMLName TOP_ATT = new XMLName("top", SPREADSHEETML_NAMESPACE); 275 public static final XMLName TOP_LEFT_CELL_ATT = new XMLName("topLeftCell", SPREADSHEETML_NAMESPACE); 276 public static final XMLName TYPE_ATT = new XMLName("type", SPREADSHEETML_NAMESPACE); 277 public static final XMLName URI_ATT = new XMLName("uri", SPREADSHEETML_NAMESPACE); 278 public static final XMLName VALUE_ATT = new XMLName("val", SPREADSHEETML_NAMESPACE); 279 public static final XMLName VERTICAL_ATT = new XMLName("vertical", SPREADSHEETML_NAMESPACE); 280 public static final XMLName VIEW_ATT = new XMLName("view", SPREADSHEETML_NAMESPACE); 281 public static final XMLName WIDTH_ATT = new XMLName("width", SPREADSHEETML_NAMESPACE); 282 public static final XMLName WINDOW_PROTECTION_ATT = new XMLName("windowProtection", SPREADSHEETML_NAMESPACE); 283 public static final XMLName WORKBOOK_VIEW_ID_ATT = new XMLName("workbookViewId", SPREADSHEETML_NAMESPACE); 284 public static final XMLName WRAP_TEXT_ATT = new XMLName("wrapText", SPREADSHEETML_NAMESPACE); 285 public static final XMLName X_SPLIT_ATT = new XMLName("xSplit", SPREADSHEETML_NAMESPACE); 286 public static final XMLName Y_SPLIT_ATT = new XMLName("ySplit", SPREADSHEETML_NAMESPACE); 287 public static final XMLName ZERO_HEIGHT_ATT = new XMLName("zeroHeight", SPREADSHEETML_NAMESPACE); 288 public static final XMLName ZOOM_SCALE_ATT = new XMLName("zoomScale", SPREADSHEETML_NAMESPACE); 289 public static final XMLName ZOOM_SCALE_NORMAL_ATT = new XMLName("zoomScaleNormal", SPREADSHEETML_NAMESPACE); 290 public static final XMLName ZOOM_SCALE_PAGE_LAYOUT_VIEW_ATT = new XMLName("zoomScalePageLayoutView", SPREADSHEETML_NAMESPACE); 291 public static final XMLName ZOOM_SCALE_SHEET_LAYOUT_VIEW_ATT = new XMLName("zoomScaleSheetLayoutView", SPREADSHEETML_NAMESPACE); 292 293 public static final XMLName XR_UID_ATT = new XMLName("uid", SPREADSHEETML_REVISION1_NAMESPACE); 294 295 public static final XMLName AUTHOR_ID_ATT = new XMLName("authorId"); 296 public static final XMLName COUNT_ATT = new XMLName("count"); 297 public static final XMLName STYLE_FORMAT_ID_ATT = new XMLName("xfId"); 298 public static final XMLName UNIQUE_COUNT_ATT = new XMLName("uniqueCount"); 299 300 301 //--------------------------------------------------------------------------- 302 // By calling this method we simply ensure that the above namespaces get declared. 303 public static void initializeNamespaces() 304 { 305 } 306}