Results 1 to 4 of 4
Thread: Åêñïîðòâàíå íà excel xml ñ PHP
Hybrid View
-
11th July 2011 10:05 #1
Åêñïîðòâàíå íà excel xml ñ PHP
Ìîæå ëè äà ìè êàæåòå êàê ñ ïõï äà çàïèñâàì åêñåëñêà òàáëèöà â ôîðìàò xml.Èñêàì ñ öèêúë äà çàïèñâàì âñåêè ðåä, íî íå çíàì êàê ñòàâà òî÷íî çàïèñâàíåòî.Áëàãîäàðÿ ïðåäâàðèòåëíî!
-
16th July 2011 15:11 #2Registered User
Join Date: Jul:2010
Location: Veliko Tarnovo
Posts: 55
Google å òâîÿò íàé-äîáúð ïðèÿòåë. http://www.webcheatsheet.com/PHP/exp...schema_xml.php
-
24th July 2011 23:49 #3Registered User
Join Date: Sep:2009
Location: Ñîôèÿ
Posts: 4
Ñëåä äîñòà áúõòåíå äà íàìåðÿ ðåøåíèå ðàáîòåùî åäíîâðåìåííî è çà excel è çà openoffice, ñòèãíàõ äî ñëåäíîòî, êîåòî ãîðå-äîëó ðàáîòè êàòî èãíîðèðàìå ñúîáùåíèåòî íà åêñåë, ÷å ôàéëa âñúùíîñò íå å xls:
Îïðîñòèë ñúì ïðèìåðà çà ïî-äîáðà ÷åòèìîñò è èìàé ïðåäâèä ÷å ñòàðèòå åêñåëè ðàçáèðàò ñàìî îò CP1251, çàðàäè êîåòî êîíâåðòèðàì.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;
-
25th July 2011 00:15 #4
.. êîåòî âñúùíîñò å ïðîñòî tabular data.
Îïåí Îôèñ íå ðàçáèðà ëè ïîíå îò CSV? Åäíàêâî ëåñíî çà ïîñòðîÿâàíå.




Reply With Quote
Lenovo ThinkPad 15 èëè IdeaPad 15
5th May 2023, 22:16 in Ìîáèëíè êîìïþòðè