I am generating excel by using Laravel 5.2 and maatwebsite/excel.
but this generated excel can not read by java(according to java developer).
he(java developer) open excel file in Winrar and shows xml file like below.
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
<cp:coreProperties xmlns:xsi="http://ift.tt/ra1lAU" xmlns:dcmitype="http://ift.tt/1bzgRNg" xmlns:dcterms="http://ift.tt/qxdZ4f" xmlns:dc="http://ift.tt/mToXri" xmlns:cp="http://ift.tt/1vp3Hkm">
<dc:creator>Maatwebsite</dc:creator>
<cp:lastModifiedBy>Maatwebsite</cp:lastModifiedBy>
<dcterms:created xsi:type="dcterms:W3CDTF">2017-06-07T09:47:37+00:00</dcterms:created>
<dcterms:modified xsi:type="dcterms:W3CDTF">2017-06-07T09:47:37+00:00</dcterms:modified>
<dc:title>resourceCodes</dc:title>
<dc:description>Default spreadsheet export</dc:description>
<dc:subject>Spreadsheet export</dc:subject>
<cp:keywords>maatwebsite, excel, export</cp:keywords>
<cp:category>Excel</cp:category>
</cp:coreProperties>
Problem
java can not able to read date format in excel generated by maatwebsite/excel
FORMAT FOUND 2017-06-07T09:47:37+00:00
EXPECTED FORMAT yyyy-MM-dd'T'HH:mm:ss'Z' OR yyyy-MM-dd'T'HH:mm:ss.SS'Z'
What should I do? How to resolve it?
Appreciate all response. Thanks Ahead
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire