############################################################################### # # Core - A class for writing the Excel XLSX Worksheet file. # # Copyright 2013-2019, John McNamara, jmcnamara@cpan.org # # Standard packages. from datetime import datetime # Package imports. from . import xmlwriter class Core(xmlwriter.XMLwriter): """ A class for writing the Excel XLSX Core file. """ ########################################################################### # # Public API. # ########################################################################### def __init__(self): """ Constructor. """ super(Core, self).__init__() self.properties = {} ########################################################################### # # Private API. # ########################################################################### def _assemble_xml_file(self): # Assemble and write the XML file. # Write the XML declaration. self._xml_declaration() self._write_cp_core_properties() self._write_dc_title() self._write_dc_subject() self._write_dc_creator() self._write_cp_keywords() self._write_dc_description() self._write_cp_last_modified_by() self._write_dcterms_created() self._write_dcterms_modified() self._write_cp_category() self._write_cp_content_status() self._xml_end_tag('cp:coreProperties') # Close the file. self._xml_close() def _set_properties(self, properties): # Set the document properties. self.properties = properties def _datetime_to_iso8601_date(self, date): # Convert to a ISO 8601 style "2010-01-01T00:00:00Z" date. if not date: date = datetime.utcnow() return date.strftime("%Y-%m-%dT%H:%M:%SZ") ########################################################################### # # XML methods. # ########################################################################### def _write_cp_core_properties(self): # Write the element. xmlns_cp = ('http://schemas.openxmlformats.org/package/2006/' + 'metadata/core-properties') xmlns_dc = 'http://purl.org/dc/elements/1.1/' xmlns_dcterms = 'http://purl.org/dc/terms/' xmlns_dcmitype = 'http://purl.org/dc/dcmitype/' xmlns_xsi = 'http://www.w3.org/2001/XMLSchema-instance' attributes = [ ('xmlns:cp', xmlns_cp), ('xmlns:dc', xmlns_dc), ('xmlns:dcterms', xmlns_dcterms), ('xmlns:dcmitype', xmlns_dcmitype), ('xmlns:xsi', xmlns_xsi), ] self._xml_start_tag('cp:coreProperties', attributes) def _write_dc_creator(self): # Write the element. data = self.properties.get('author', '') self._xml_data_element('dc:creator', data) def _write_cp_last_modified_by(self): # Write the element. data = self.properties.get('author', '') self._xml_data_element('cp:lastModifiedBy', data) def _write_dcterms_created(self): # Write the element. date = self.properties.get('created', datetime.utcnow()) xsi_type = 'dcterms:W3CDTF' date = self._datetime_to_iso8601_date(date) attributes = [('xsi:type', xsi_type,)] self._xml_data_element('dcterms:created', date, attributes) def _write_dcterms_modified(self): # Write the element. date = self.properties.get('created', datetime.utcnow()) xsi_type = 'dcterms:W3CDTF' date = self._datetime_to_iso8601_date(date) attributes = [('xsi:type', xsi_type,)] self._xml_data_element('dcterms:modified', date, attributes) def _write_dc_title(self): # Write the element. if 'title' in self.properties: data = self.properties['title'] else: return self._xml_data_element('dc:title', data) def _write_dc_subject(self): # Write the element. if 'subject' in self.properties: data = self.properties['subject'] else: return self._xml_data_element('dc:subject', data) def _write_cp_keywords(self): # Write the element. if 'keywords' in self.properties: data = self.properties['keywords'] else: return self._xml_data_element('cp:keywords', data) def _write_dc_description(self): # Write the element. if 'comments' in self.properties: data = self.properties['comments'] else: return self._xml_data_element('dc:description', data) def _write_cp_category(self): # Write the element. if 'category' in self.properties: data = self.properties['category'] else: return self._xml_data_element('cp:category', data) def _write_cp_content_status(self): # Write the element. if 'status' in self.properties: data = self.properties['status'] else: return self._xml_data_element('cp:contentStatus', data)