Results 1 to 4 of 4

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Web dev SuSaMeCa's Avatar
    Join Date: Jan:2010
    Location: Âàðíà
    Posts: 342

    Åêñïîðòâàíå íà excel xml ñ PHP

    Ìîæå ëè äà ìè êàæåòå êàê ñ ïõï äà çàïèñâàì åêñåëñêà òàáëèöà â ôîðìàò xml.Èñêàì ñ öèêúë äà çàïèñâàì âñåêè ðåä, íî íå çíàì êàê ñòàâà òî÷íî çàïèñâàíåòî.Áëàãîäàðÿ ïðåäâàðèòåëíî!

  2. #2
    Registered User
    Join Date: Jul:2010
    Location: Veliko Tarnovo
    Posts: 55
    Google å òâîÿò íàé-äîáúð ïðèÿòåë. http://www.webcheatsheet.com/PHP/exp...schema_xml.php

  3. #3
    Registered User
    Join Date: Sep:2009
    Location: Ñîôèÿ
    Posts: 4
    Ñëåä äîñòà áúõòåíå äà íàìåðÿ ðåøåíèå ðàáîòåùî åäíîâðåìåííî è çà excel è çà openoffice, ñòèãíàõ äî ñëåäíîòî, êîåòî ãîðå-äîëó ðàáîòè êàòî èãíîðèðàìå ñúîáùåíèåòî íà åêñåë, ÷å ôàéëa âñúùíîñò íå å xls:
    PHP Code:
        $data "";
        while (
    $r=fetchrow()) {
            
    $data .= "\"".$r[0]."\"\t\"".$r[1]."\"\t\"".$r[2]."\"\t\"".$r[3]."\"\t";
            
    $data .= "\n";
        }
        
    $output mb_convert_encoding($title.$data"CP1251""UTF-8");

        
    header('Content-Disposition: attachment; filename="FileName-'.date('Y_m_d_H_i').'.xls"');    
        
    header("Content-Type: application/vnd.ms-excel; charset=windows-1251");
        echo 
    $output
    Îïðîñòèë ñúì ïðèìåðà çà ïî-äîáðà ÷åòèìîñò è èìàé ïðåäâèä ÷å ñòàðèòå åêñåëè ðàçáèðàò ñàìî îò CP1251, çàðàäè êîåòî êîíâåðòèðàì.

  4. #4
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    .. êîåòî âñúùíîñò å ïðîñòî tabular data.
    Îïåí Îôèñ íå ðàçáèðà ëè ïîíå îò CSV? Åäíàêâî ëåñíî çà ïîñòðîÿâàíå.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè