tFileOutputExcel true file format is OOXML instead of XLSX
Hi All! I'm new to Talend. I'm generating an excel document for a 3rd party. The vendor is unable to load it because of the true format type of the file, which is showing OOXML instead of XLSX, even though the file extension is xlsx. The application is using a template to append records to, the template is showing as true XLSX format, but the file produced by tFileOutputExcel is OOXML. See pics in attachment using mac command file. Any ideas or suggestions? Thank you!!
Can you share a screenshot of the basic settings of tFileOutputExcel component? I'm not sure if it is a normal result or a bug, I will check with our developers and get back to you asap!
XLSX is OpenXML! Microsoft has described its new format xlsx as new standard called OpenXML.
Most modern frameworks like Apache POI (which is used by Talend) produced the latest standard for Excel files which is OpenXML or OOXML (another name for the same thing).
The extension xlsx does NOT mean it contains only the meanwhile out-dated Excel-2007+ format!
Both file formats are actually ZIP files. Rename them to zip and you can take a look into the file.
