![]() create directory path and write '.xml' file ^OOXML("Templates",some_key,"OOXML.Types","Override",3,"PartName") = /xl/styles.xml ^OOXML("Templates",some_key,"OOXML.Types","Override",3,"ContentType") = application/ xml ^OOXML("Templates",some_key,"OOXML.Types","Override",2,"PartName") = /xl/worksheets/sheet1.xml ^OOXML("Templates",some_key,"OOXML.Types","Override",2,"ContentType") = application/ xml ^OOXML("Templates",some_key,"OOXML.Types","Override",1,"PartName") = /xl/workbook.xml ^OOXML("Templates",some_key,"OOXML.Types","Override",1,"ContentType") = application/.main xml ^OOXML("Templates",some_key,"OOXML.Types","Default",2,"Extension") = xml ^OOXML("Templates",some_key,"OOXML.Types","Default",2,"ContentType") = application/xml ^OOXML("Templates",some_key,"OOXML.Types","Default",1,"Extension") = rels ^OOXML("Templates",some_key,"OOXML.Types","Default",1,"ContentType") = application/ xml ^OOXML("Templates",some_key,"OOXML.Types") PS: I'm actually doing this process the other way, creating an 'XLSX' file from a global array work file (merging in standard template data), see below. Unfortunately, I do not have any sample code for you to use, but perhaps someone may be willing to help. Set sc=reader.OpenFile("C:\Users\Tony\Desktop\\xl\worksheets\sheet1.xml")ĭo reader.Correlate("worksheet","") Once you've extracted the contents into a folder structure, you can bring the data into Caché using the following code. I would recommend you download all these schemas onto your workstation first, as the 'sml-sheet.xsd' schema for example references other schemas using a relative path (i.e. ![]() You can use the 'XML Schema Wizard' add-in within Caché Studio to create the necessary class definitions. If you're interested, the schemas for OOXML can be found on the following web site. ![]() You can read more about Office Open XML, also known as OpenXML or OOXML, in the following web link. 'xls'), as this is a proprietary binary format.Ĭ:\Users\Tony\Desktop\Sample_XL_SSheet_XML.zip You can't do this for earlier versions of Excel (i.e. Did you know a Microsoft Excel spreadsheet that has a 'xlsx' file extension is actually a compressed folder structure, comprised of a collection of XML files? If you change the 'xlsx' extension to 'zip' you will be able view the data content, see example below. ![]()
0 Comments
Leave a Reply. |