module Axlsx # version VERSION="1.0.1.a" # XML Encoding ENCODING = "UTF-8" # spreadsheetML namespace XML_NS = "http://schemas.openxmlformats.org/spreadsheetml/2006/main" # content-types namespace XML_NS_T = "http://schemas.openxmlformats.org/package/2006/content-types" # extended-properties namespace APP_NS = "http://schemas.openxmlformats.org/officeDocument/2006/extended-properties" # doc props namespace APP_NS_VT = "http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes" # core properties namespace CORE_NS = "http://schemas.openxmlformats.org/package/2006/metadata/core-properties" # dc elements (core) namespace CORE_NS_DC = "http://purl.org/dc/elements/1.1/" # dcmit (core) namespcace CORE_NS_DCMIT = "http://purl.org/dc/dcmitype/" # dc terms namespace CORE_NS_DCT = "http://purl.org/dc/terms/" # xml schema namespace CORE_NS_XSI = "http://www.w3.org/2001/XMLSchema-instance" # spreadsheet drawing namespace XML_NS_XDR = "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing" # drawing namespace XML_NS_A = "http://schemas.openxmlformats.org/drawingml/2006/main" # chart namespace XML_NS_C = "http://schemas.openxmlformats.org/drawingml/2006/chart" # relationships namespace XML_NS_R = "http://schemas.openxmlformats.org/officeDocument/2006/relationships" # relationships name space RELS_R = "http://schemas.openxmlformats.org/package/2006/relationships" # table rels namespace TABLE_R = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/table" # workbook rels namespace WORKBOOK_R = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" # worksheet rels namespace WORKSHEET_R = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" # app rels namespace APP_R = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties" # core rels namespace CORE_R = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/metadata/core-properties" # styles rels namespace STYLES_R = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" # drawing rels namespace DRAWING_R = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/drawing" # chart rels namespace CHART_R = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/chart" # table content type TABLE_CT = "application/vnd.openxmlformats-officedocument.spreadsheetml.table+xml" # workbook content type WORKBOOK_CT = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml" # app content type APP_CT = "application/vnd.openxmlformats-officedocument.extended-properties+xml" # rels content type RELS_CT = "application/vnd.openxmlformats-package.relationships+xml" # styles content type STYLES_CT = "application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml" # xml content type XML_CT = "application/xml" # worksheet content type WORKSHEET_CT = "application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml" # shared strings content type SHARED_STRINGS_CT = "application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml" # core content type CORE_CT = "application/vnd.openxmlformats-package.core-properties+xml" # chart content type CHART_CT = "application/vnd.openxmlformats-officedocument.drawingml.chart+xml" #drawing content type DRAWING_CT = "application/vnd.openxmlformats-officedocument.drawing+xml" # xml content type extensions XML_EX = "xml" # rels content type extension RELS_EX = "rels" # workbook part WORKBOOK_PN = "xl/workbook.xml" # styles part STYLES_PN = "styles.xml" # app part APP_PN = "docProps/app.xml" # core part CORE_PN = "docProps/core.xml" # content types part CONTENT_TYPES_PN = "[Content_Types].xml" # rels part RELS_PN = "_rels/.rels" # workbook rels part WORKBOOK_RELS_PN = "xl/_rels/workbook.xml.rels" # worksheet part WORKSHEET_PN = "worksheets/sheet%d.xml" # worksheet rels part WORKSHEET_RELS_PN = "worksheets/_rels/sheet%d.xml.rels" # drawing part DRAWING_PN = "drawings/drawing%d.xml" # drawing rels part DRAWING_RELS_PN = "drawings/_rels/drawing%d.xml.rels" # chart part CHART_PN = "charts/chart%d.xml" # App validation schema APP_XSD = "lib/schema/shared-documentPropertiesExtended.xsd" # core validation schema CORE_XSD = "lib/schema/opc-coreProperties.xsd" # content types validation schema CONTENT_TYPES_XSD = "lib/schema/opc-contentTypes.xsd" # rels validation schema RELS_XSD = "lib/schema/opc-relationships.xsd" # spreadsheetML validation schema SML_XSD = "lib/schema/sml.xsd" # drawing validation schema DRAWING_XSD = "lib/schema/dml-spreadsheetDrawing.xsd" # number format id for pecentage formatting using the default formatting id. NUM_FMT_PERCENT = 9 # number format id for date format like 2011/11/13 NUM_FMT_YYYYMMDD = 100 # number format id for time format the creates 2011/11/13 12:23:10 NUM_FMT_YYYYMMDDHHMMSS = 101 # cellXfs id for thin borders around the cell STYLE_THIN_BORDER = 1 # error messages RestrictionValidor ERR_RESTRICTION = "Invalid Data: %s. %s must be one of %s." # error message DataTypeValidator ERR_TYPE = "Invalid Data %s for %s. must be %s." # error message for RegexValidator ERR_REGEX = "Invalid Data. %s does not match %s." end