001package com.hfg.xml.msoffice2003.spreadsheetml; 002 003import com.hfg.xml.XMLNamespace; 004import com.hfg.xml.XMLName; 005 006 007//------------------------------------------------------------------------------ 008/** 009 XML Names for use with Microsoft's Office 2003 SpreadsheetML. 010 <p> 011 See Wikipedia's 012 <a href='http://en.wikipedia.org/wiki/Microsoft_Office_XML_formats'>summary</a>. 013 </p> 014 and <a href='http://msdn.microsoft.com/en-us/library/aa140066(office.10).aspx'>Microsoft's Reference</a>. 015 * @author J. Alex Taylor, hairyfatguy.com 016 */ 017//------------------------------------------------------------------------------ 018// com.hfg Library 019// 020// This library is free software; you can redistribute it and/or 021// modify it under the terms of the GNU Lesser General Public 022// License as published by the Free Software Foundation; either 023// version 2.1 of the License, or (at your option) any later version. 024// 025// This library is distributed in the hope that it will be useful, 026// but WITHOUT ANY WARRANTY; without even the implied warranty of 027// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU 028// Lesser General Public License for more details. 029// 030// You should have received a copy of the GNU Lesser General Public 031// License along with this library; if not, write to the Free Software 032// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA 033// 034// J. Alex Taylor, President, Founder, CEO, COO, CFO, OOPS hairyfatguy.com 035// jataylor@hairyfatguy.com 036//------------------------------------------------------------------------------ 037public class SpreadsheetML 038{ 039 /** The maximum length of an Excel worksheet name. */ 040 public static final int WORKSHEET_NAME_MAX_LENGTH = 31; 041 /** The maximum number of worksheets in an Excel workbook. */ 042 public static final int MAX_WORKSHEETS = 256; 043 044 public static final XMLNamespace SS_NAMESPACE = XMLNamespace.getNamespace("ss", "urn:schemas-microsoft-com:office:spreadsheet"); 045 public static final XMLNamespace X_NAMESPACE = XMLNamespace.getNamespace("x", "urn:schemas-microsoft-com:office:excel"); 046 public static final XMLNamespace O_NAMESPACE = XMLNamespace.getNamespace("o", "urn:schemas-microsoft-com:office:office"); 047 public static final XMLNamespace C_NAMESPACE = XMLNamespace.getNamespace("c", "urn:schemas-microsoft-com:office:component:spreadsheet"); 048 public static final XMLNamespace HTML_NAMESPACE = XMLNamespace.getNamespace("html", "http://www.w3.org/TR/REC-html40"); 049 050 // Tag names 051 public static final XMLName WORKBOOK = new XMLName("Workbook", SS_NAMESPACE); 052 public static final XMLName WORKSHEET = new XMLName("Worksheet", SS_NAMESPACE); 053 public static final XMLName STYLES = new XMLName("Styles", SS_NAMESPACE); 054 public static final XMLName STYLE = new XMLName("Style", SS_NAMESPACE); 055 public static final XMLName FONT = new XMLName("Font", SS_NAMESPACE); 056 public static final XMLName TABLE = new XMLName("Table", SS_NAMESPACE); 057 public static final XMLName COLUMN = new XMLName("Column", SS_NAMESPACE); 058 public static final XMLName ROW = new XMLName("Row", SS_NAMESPACE); 059 public static final XMLName CELL = new XMLName("Cell", SS_NAMESPACE); 060 public static final XMLName COMMENT = new XMLName("Comment", SS_NAMESPACE); 061 public static final XMLName DATA = new XMLName("Data", SS_NAMESPACE); 062 public static final XMLName ALIGNMENT = new XMLName("Alignment", SS_NAMESPACE); 063 public static final XMLName INTERIOR = new XMLName("Interior", SS_NAMESPACE); 064 public static final XMLName BORDERS = new XMLName("Borders", SS_NAMESPACE); 065 public static final XMLName BORDER = new XMLName("Border", SS_NAMESPACE); 066 public static final XMLName NUMBER_FORMAT = new XMLName("NumberFormat", SS_NAMESPACE); 067 068 public static final XMLName ACTIVE_COL = new XMLName("ActiveCol", X_NAMESPACE); 069 public static final XMLName ACTIVE_PANE = new XMLName("ActivePane", X_NAMESPACE); 070 public static final XMLName ACTIVE_ROW = new XMLName("ActiveRow", X_NAMESPACE); 071 public static final XMLName AUTO_FILTER = new XMLName("AutoFilter", X_NAMESPACE); 072 public static final XMLName FREEZE_PANES = new XMLName("FreezePanes", X_NAMESPACE); 073 public static final XMLName FROZEN_NO_SPLIT = new XMLName("FrozenNoSplit", X_NAMESPACE); 074 public static final XMLName LEFT_COLUMN_RIGHT_PANE = new XMLName("LeftColumnRightPane", X_NAMESPACE); 075 public static final XMLName NUMBER = new XMLName("Number", X_NAMESPACE); 076 public static final XMLName PAGE_LAYOUT_ZOOM = new XMLName("PageLayoutZoom", X_NAMESPACE); 077 public static final XMLName PANE = new XMLName("Pane", X_NAMESPACE); 078 public static final XMLName PANES = new XMLName("Panes", X_NAMESPACE); 079 public static final XMLName PROTECT_OBJECTS = new XMLName("ProtectObjects", X_NAMESPACE); 080 public static final XMLName PROTECT_SCENARIOS = new XMLName("ProtectScenarios", X_NAMESPACE); 081 public static final XMLName RANGE = new XMLName("Range", X_NAMESPACE); 082 public static final XMLName SELECTED = new XMLName("Selected", X_NAMESPACE); 083 public static final XMLName SPLIT_HORIZONTAL = new XMLName("SplitHorizontal", X_NAMESPACE); 084 public static final XMLName SPLIT_VERTICAL = new XMLName("SplitVertical", X_NAMESPACE); 085 public static final XMLName TOP_ROW_BOTTOM_PANE = new XMLName("TopRowBottomPane", X_NAMESPACE); 086 public static final XMLName WORKSHEET_OPTIONS = new XMLName("WorksheetOptions", X_NAMESPACE); 087 088 public static final XMLName COMPONENT_OPTIONS = new XMLName("ComponentOptions", C_NAMESPACE); 089 public static final XMLName DISPLAY_CUSTOM_HEADERS = new XMLName("DisplayCustomHeaders", C_NAMESPACE); 090 public static final XMLName HIDE_OFFICE_LOGO = new XMLName("HideOfficeLogo", C_NAMESPACE); 091 public static final XMLName TOOLBAR = new XMLName("Toolbar", C_NAMESPACE); 092 // Given an '_C' suffix to distinguish it from the tag of the same name in the 'x' namespace 093 public static final XMLName WORKSHEET_OPTIONS_C = new XMLName("WorksheetOptions", C_NAMESPACE); 094 095 // Attribute names 096 public static final XMLName AUTHOR_ATT = new XMLName("Author", SS_NAMESPACE); 097 public static final XMLName AUTO_FIT_HEIGHT_ATT = new XMLName("AutoFitHeight", SS_NAMESPACE); 098 public static final XMLName AUTO_FIT_WIDTH_ATT = new XMLName("AutoFitWidth", SS_NAMESPACE); 099 public static final XMLName BOLD_ATT = new XMLName("Bold", SS_NAMESPACE); 100 public static final XMLName COLOR_ATT = new XMLName("Color", SS_NAMESPACE); 101 public static final XMLName DEFAULT_COLUMN_WIDTH_ATT = new XMLName("DefaultColumnWidth", SS_NAMESPACE); 102 public static final XMLName DEFAULT_ROW_HEIGHT_ATT = new XMLName("DefaultRowHeight", SS_NAMESPACE); 103 public static final XMLName EXPANEDED_COLUMN_COUNT_ATT = new XMLName("ExpandedColumnCount", SS_NAMESPACE); 104 public static final XMLName FONT_NAME_ATT = new XMLName("FontName", SS_NAMESPACE); 105 public static final XMLName FORMAT_ATT = new XMLName("Format", SS_NAMESPACE); 106 public static final XMLName FORMULA_ATT = new XMLName("Formula", SS_NAMESPACE); 107 public static final XMLName HEIGHT_ATT = new XMLName("Height", SS_NAMESPACE); 108 public static final XMLName HIDDEN_ATT = new XMLName("Hidden", SS_NAMESPACE); 109 public static final XMLName HORIZONTAL_ATT = new XMLName("Horizontal", SS_NAMESPACE); 110 public static final XMLName HREF_ATT = new XMLName("HRef", SS_NAMESPACE); 111 public static final XMLName ID_ATT = new XMLName("ID", SS_NAMESPACE); 112 public static final XMLName INDEX_ATT = new XMLName("Index", SS_NAMESPACE); 113 public static final XMLName ITALIC_ATT = new XMLName("Italic", SS_NAMESPACE); 114 public static final XMLName LINE_STYLE_ATT = new XMLName("LineStyle", SS_NAMESPACE); 115 public static final XMLName MERGE_ACROSS_ATT = new XMLName("MergeAcross", SS_NAMESPACE); 116 public static final XMLName MERGE_DOWN_ATT = new XMLName("MergeDown", SS_NAMESPACE); 117 public static final XMLName NAME_ATT = new XMLName("Name", SS_NAMESPACE); 118 public static final XMLName PARENT_ATT = new XMLName("Parent", SS_NAMESPACE); 119 public static final XMLName PATTERN_ATT = new XMLName("Pattern", SS_NAMESPACE); 120 public static final XMLName POSITION_ATT = new XMLName("Position", SS_NAMESPACE); 121 public static final XMLName PROTECTED_ATT = new XMLName("Protected", SS_NAMESPACE); 122 public static final XMLName ROTATE_ATT = new XMLName("Rotate", SS_NAMESPACE); 123 public static final XMLName SHOW_ALWAYS_ATT = new XMLName("ShowAlways", SS_NAMESPACE); 124 public static final XMLName SIZE_ATT = new XMLName("Size", SS_NAMESPACE); 125 public static final XMLName SPAN_ATT = new XMLName("Span", SS_NAMESPACE); 126 public static final XMLName STYLE_ID_ATT = new XMLName("StyleID", SS_NAMESPACE); 127 public static final XMLName TYPE_ATT = new XMLName("Type", SS_NAMESPACE); 128 public static final XMLName VERTICAL_ATT = new XMLName("Vertical", SS_NAMESPACE); 129 public static final XMLName WEIGHT_ATT = new XMLName("Weight", SS_NAMESPACE); 130 public static final XMLName WIDTH_ATT = new XMLName("Width", SS_NAMESPACE); 131 public static final XMLName WRAP_TEXT_ATT = new XMLName("WrapText", SS_NAMESPACE); 132 133 public static final XMLName FAMILY_ATT = new XMLName("Family", X_NAMESPACE); 134 135 public static final XMLName CAPTION_ATT = new XMLName("Caption", C_NAMESPACE); 136 public static final XMLName PASTE_FORMULA_ATT = new XMLName("PasteFormula", C_NAMESPACE); 137 public static final XMLName PASTE_REFERS_TO_ATT = new XMLName("PasteRefersTo", C_NAMESPACE); 138 139}