{"id":130,"date":"2010-04-20T17:35:02","date_gmt":"2010-04-20T14:35:02","guid":{"rendered":"http:\/\/ramuuns.id.lv\/blog\/?p=130"},"modified":"2010-04-20T17:35:02","modified_gmt":"2010-04-20T14:35:02","slug":"xls-faili-ieks-php","status":"publish","type":"post","link":"https:\/\/ramuuns.com\/blog\/2010\/04\/20\/xls-faili-ieks-php\/","title":{"rendered":"xls faili iek\u0161 php"},"content":{"rendered":"<p>Kod\u0113 php? Profesion\u0101li? Tad \u0161itais, visticam\u0101k, priek\u0161 tevis. P\u0101r\u0113jie turpina las\u012bt <a href=\"http:\/\/delfi.lv\">delfus<\/a>\/<a href=\"http:\/\/fizmati.lv\">fizmatus<\/a>\/<a href=\"http:\/\/nombre.lv\">nombri<\/a>\/whatever.<\/p>\n<p>T\u0101dad esi tak\u0161 sask\u0101ries iek\u0161 specn\u0113m ar pras\u012bb\u0101m no s\u0113rijas &#8220;eksport\u0113t uz MS Excel izveidoto sarakstu ar inform\u0101ciju&#8230;&#8221;? Neesi &#8211; aha &#8211; jauni\u0146ais, nekas, gan jau saskarsies. Nu vo, es ar\u012b biju sav\u0101 pieredz\u0113 sask\u0101ries reizes daudz. Katru reizi mani moc\u012bja t\u0101da nepatika pret p\u0101r\u0113jo kol\u0113\u0123u pied\u0101v\u0101tajiem variantiem, ta\u010du internets neko lab\u0101ku nepied\u0101v\u0101ja, tad nu tika veidoti da\u017e\u0101di tur xml:i ar .xls extensionu, kuru tad tjipa excelis saprot, vai ar\u012b .csv faili, vai ar\u012b tika izm\u0113\u0123in\u0101ts tas <a href=\"http:\/\/pear.php.net\/Spreadsheet_Excel_Writer\">PEARa br\u012bnums<\/a><\/p>\n<p>Bet tagad pavisam nesen atkal vien\u0101 projekti\u0146\u0101 uzpeld\u0113ja vajadz\u012bba \u0123ener\u0113t xls failus (nu tur t\u0101 ar vair\u0101kiem \u0161\u012btiem un vis\u0101m p\u0101r\u0113j\u0101m izvirt\u012bb\u0101m), un grib\u0113j\u0101s v\u0113lreiz uzmest aci internetiem vai nav kaut kas pa \u0161o laiku main\u012bjies dz\u012bv\u0113. Un k\u0101 izr\u0101d\u0101s &#8211; ir.<\/p>\n<p>Eksist\u0113 t\u0101ds viens br\u012bnumjauks projekti\u0146\u0161 ar nosaukumu <a href=\"http:\/\/phpexcel.codeplex.com\/\">PHPExcel<\/a>, kur\u0161 k\u0101 izr\u0101d\u0101s, ne tikai prot \u0123ener\u0113t korektus .xls failus, bet suport\u0113 v\u0113l vis\u0101dus br\u012bnumus no s\u0113rijas .xlsx (office 2007), r\u016bti\u0146u m\u0113rd\u017eo\u0161anu, format\u0113\u0161anu, formulas, pat att\u0113lu embed\u0113\u0161anu.<\/p>\n<p>I mean, just look at this:<\/p>\n<p><img loading=\"lazy\" class=\"alignnone\" src=\"http:\/\/i3.codeplex.com\/Project\/Download\/FileDownload.aspx?ProjectName=PHPExcel&amp;DownloadId=14753\" alt=\"\" width=\"498\" height=\"494\" \/><\/p>\n<p>Protams, \u0161is nav quick and dirty almost excel failu \u0123enerators, bet jebkur\u0101 gad\u012bjum\u0101 d\u0101rgo php developeri: es tev \u0161o br\u012bnumu rekomend\u0113ju, tici man, tavs klients\/projvads\/whatever b\u016bs tev pateic\u012bgs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kod\u0113 php? Profesion\u0101li? Tad \u0161itais, visticam\u0101k, priek\u0161 tevis. P\u0101r\u0113jie turpina las\u012bt delfus\/fizmatus\/nombri\/whatever. T\u0101dad esi tak\u0161 sask\u0101ries iek\u0161 specn\u0113m ar pras\u012bb\u0101m no s\u0113rijas &#8220;eksport\u0113t uz MS Excel izveidoto sarakstu ar inform\u0101ciju&#8230;&#8221;? Neesi &#8211; aha &#8211; jauni\u0146ais, nekas, gan jau saskarsies. Nu vo, es ar\u012b biju sav\u0101 pieredz\u0113 sask\u0101ries reizes daudz. Katru reizi mani moc\u012bja t\u0101da nepatika [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/posts\/130"}],"collection":[{"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/comments?post=130"}],"version-history":[{"count":2,"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/posts\/130\/revisions"}],"predecessor-version":[{"id":133,"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/posts\/130\/revisions\/133"}],"wp:attachment":[{"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/media?parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/categories?post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ramuuns.com\/blog\/wp-json\/wp\/v2\/tags?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}