 |
|
|
 |
 |
|
Code (PHP)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="your_name.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
// This line will force the file to download
$objWriter->save('php://output');
|
 |
 |
 |
 |
Date :
2014-04-28 08:19:36 |
By :
Freeland |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|

|
 |
 |
 |
 |
Date :
2014-04-28 09:38:36 |
By :
mr.win |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ไม่รู้ว่าความยากง่ายต่างกันอย่างไร....แต่ไปเจอที่เว็บ....ninenik ขออนุญาตโพสต์
ลองทำแล้วก็ง่ายดี
เป็นทางเสิรมครับ 
|
 |
 |
 |
 |
Date :
2014-04-28 11:49:41 |
By :
apisitp |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
มันขึ้นให้ดาวโหลดไฟล์นะครับ แต่มันsave เป็นword 97-2003 เปิดไฟล์ออกมาก็เป็นภาษาต่างดาวครับ
16:31:25 Create new PHPExcel object
16:31:25 Set properties
16:31:25 Add some data
16:31:25 Rename sheet
PK์ณDG’DฒX๐[Content_Types].xmlญ”MNร0…๗"๒%nY vAa •(0๖คฑุ๊–g๚w{&i@ีnbE๖{฿๘y์ัdธl
m๐ฅ‘ืมXฟ(ล)ฟ’๒Fนเก;@1_ๆปฑุc)jขx/%๊…Eเyฆ
ฉQฤฟi!ฃาKตy3J<งZ1ฝ0?YูL%zV
cไึIb7ุ๛์a/lูฅP1:ซqแrํอjชสj0Aฏ–อu๋""ํเู( ”ม€W์Mไ)Tjๅ({ฒ๛>๓Oใย,Xูญมฺฦ>B~ืญฯ๕ำค6J=กoBZพฐผt์ํX4ส๚พCg๑,…’QgmrLููฏc๏e๋เt๘ฑ Z๕?ดปhPvร๐ยฑ๚uีj•ภผRโๆธ๘๛๎}ฌCvึ๘PK์ณDถ78้K_rels/.relsญ’อjร0€๏{
ฃ{ฃด…1F^ส ท2ฒะlๅ$–ฑฝ-}๛yฑบาร–ฅOv๛yี;ุำฐ.JP์ุต^๊งีจศYลฑ3GุWwปg)ๅุ๕>ชqQC—’Dฆใb!]i$L”๒3ด่ษิ2nส๒รoTฆ:Z
แhท ๊ณ็[ุา4ฝแท]บะyN์,•น>ค>ฃj
-'
Vฬ)#’๗EF^6ฺn๔๗ด8q"KะHเ๋>_ืึนขeฦอ<โแUd๘vมล
TPK์ณD$ฑV้นxl/_rels/workbook.xml.relsญ’มjร0D๏
ฑ๗ZvZJ)‘s)\[๗ดถLlIh7m๗UHกฤฌุวH๋อ๗8OLิฏ *J่Mฐฝ๏|4๛gฤฺ[=
&$ุิw๋74็r}$‘M<)pฬ๑EJ2GME่๓Mาจ9หิษจอ^w(We๙$ำ๊Oฑณ
าฮV )โผC๖_9่๙J$ฬ/:dG]dืใWKฦsลs๚<ซ[VเtB๛ฮ)?๐ผ๙๘ฬใ’0_!ํษ!๒ไ4๚Eอวฉy๑ใ๊PK์ณDฺg๙=docProps/app.xmlSAn0ผ๗๏1eฃ(
b(-rจQvา3Cญ,"Ipืีื—’!EnzชNณณแpน๗—ึfD4lฝสYN๛สธSม฿๏พฒIนJY๏ `= ป—ฤ>๚‘`–ฌ!
[ฮQ7ะ*\ฅถKฺวVQ*ใ๛บ6ฝ>ทเo๒ซ บณ!ป:n;๚_ำส๋!พ๛คxมญ(]R๎}Mูท+๘ฒ)’ั๔9๊e.๘ฒญ,”ษXึส"N'Pรฬ๖สD”ขฃm|ฬะNSฐ์U!q
ึฉh”#v•]€ๅ/฿ฐ |&Gธิ.ฑ๙,ืฃ [!$|๑hศฌ๗*า?ฏ—วl‘qืgๅษท?๛๋€าทAน~1าวเใ8wมงถุ)งN0ฬ่qo๘QLณฟ%ลกQช๔\๓ฬxJ—vะ—r'จ&อวฦฐ)/ืฟAฎ7ซ<}ใLเ๏/PK์ณDเ”zRถขdocProps/core.xmlฅ“Ao ว๏๛๋fc'mWY+uUตCฃEjฆๆสเลaล€ฯ๕ท/ฦฎ9Lฺฝ?๛ๅอK#ัฐNhตยyai.Tฝย?ท๗ษ5FฮSลฉิ
VธoชO%3ำ6Vฐ^€CAค\มฬ
ผ7! ก.
ลฝถ
๕aikb({ฆ5E–]‘<ๅิS23๑คไlVึส(เ€”w$Os๒ฦzฐ;ป!VNศF๘ภY๔X้'fฐ๋บด[F4๔“๚แ15DลW%gณ@ฝถีR๋Aก[*ฅ mW’“โคคฮฏCไ{ถ?รdสiะั…qcๅi๙ํn{ซE–_$ูEฒธๆWล2/—ณผศฒกw’7k3๔ฺฃ%ฆแ…—Pุ๏r๛v;ด็ัfํp—1ถppฬ
ใรำฌ"ว'…ทV}A5(ฐ1ึ…๗6฿7…เธ4ชO…รฎ๕—ฎ่p_ฯะwฺrW้“}ำ+Gๆ`โ…อP*กซZ~รkeBH่\W๏พU๕
PK์ณDs‘{Yณฆxl/theme/theme1.xmlํYOo6ฟ๏Sบทฒlษu:E์ุ๋ึฆ
ทCดDKฌ)Q ้คพ
ํqภ€aฐห€vถh]บO“ญรึ
{๚c้6iSlC๋-’ฟ๗๏๑Qพ|ๅ^ฬะ!’๒คk9"ฯ]๋ึhxกc!ฉp`ฦาตๆDZWถ>ธ7UDb€<‘ธkEJฅถ-}ฦ๒"OIk.bฌ`(B;๘ุฦฬn6m;ฦ4ฑPcเzs2ก>Aฃฅตต`>`๐•(M๘L๘นD"วS'๛‘sูgbึต@NภFไฒรRมBืjไหบl/ZCซั
๓OIWำfN'ย๑’ะบ—v–U`0่%ฟ€},uVฐ๎ฐใ๔<5P๑ธสป฿๐nฏ๑oญเ7zฝทQรท*ผป๏4ฺ๎vณw+ผทชoป฿oื๐^…oฏเ—6ฺn"F“้
:็22KศณซFxเลจPถถป
๚Dญk1พหลypฑข R๓”Lฐธ>วโL$X[)ฆ|น2•ษBา4U]๋ใCFTO|๑๔1z๑๔ั๑'ว๗9~๐เ๘ฯยซ8 uย็฿๑๗ทขฟ๗แWfผิ๑ฟ๔ูoฟ~i*๘์๋G<y๔์ฯแกพ-๐XhL$บAะ>ม62gฃEึ(pHp ข๐ฦ3ฎG๊ฮป- €ฮ๎ึt=ฤLQ๐Zื€ปณFsฎeฒtsfIh.f:nใC“์ะf)์djbูHMอ=ัฦ!IBูb ปCiอฏปิ\๒Bw(๊ajtษ•่*!.sluอ7ปทQ3๛rXGBB`fbIXอโยฑQc3yซศคไม\๘5K‘ ใh)M47ลผฆ๎5•ศ๖]6๋Hก่ิผ9ื‘;|ฺpuฆIคc?’SุขํqeTื3$Cpฒ6ท)QgK๋[4ฬ$[ SJ^ฯว9`’”๕ฝVฉcผฌl3
u๛}ู^ภทแcง(ึ๋pรฝgษฌx_ก฿W่wฑBฏหๅ๓ฏหU)ถ๕^;gฏmผ'”ฑ5gไบฬธ๓!Lๆhู็ง<–โjธPเ ฎ>ก*:p
b\B(KึกD)—pปฐึ๒ฮฏจlฮ็ผลฝะXํ๒ n้๗อ%|J]P+cpZaญKo&ฬ)€ง”ๆxfiKฅู7!oฮ^&8ํf!6
f$ศ^0XๅC$#2FังuJทu^ํ5MฺF๋อค&Hบ8w8๏ขิX’ฝ,ฉะhๅ5=๙8ํZ่นเ1NฬJfaาต|U๒สd>iฐy[:ตืDคBช,ฃ*_ZผI*๙แ|ฐ_WVว๙ตฐO–L&ฤWkfชaนฦg(8Bc6๛๔vP GEs1กnน๑๊_fมษื>ev`–FธฌI-๖<^๊4๕์5บฟฆ)ญs4ล{wMษv.4ธญ ฟzA 0ส๖hืโBEชPQ( qศe^า"S ฑ์vฆ+9ฌ๊Vมฃ(raค๖i…Jง"Aศ*ํ|3งฉฏFeYช+ำโwL eูฮ์ทPดจ&ฅ#rษ ูฆ์รp็ใ6^ง=จนg้E\ญ่kGมฦฉpฦฃถiถธ้๚จMแฒ/(T๘ฌ๊oG|ข–%xกSฆ฿rr:w4ใ2VoทชBะiผๆSsvkณทใlฯเk๏ๅฎถWSิึ.2๙hๅฯ,>พฒwเ~4cJ๏๎มฅดฟ๘๘ุ้ึ?PK์ณD€9ไ๕xl/sharedStrings.xmlUัา@}๗+&}ทE6ซฦ”๎_ ฏdฉ
าb๔Mp—จYศnw
YMY6$ยvu๚7๓)ฮ้ฐฅ1i3ฝ๗3็น5๗Uสไญ]wKU'ง=ะ3ฑjกไไดฯฌืห;…|นุ๊9ํฝํj{ึ=ำu=ยS7ง=ฏ๖ฤ0ข]ษปzตf;อซjฝ’๗๘ฒ~`ธตบ/ธE๖*e#ษ<4*๙’ฃ‘SzำฐV—ำvv4หtK–้Y,j1:fดอ่ัKFแ๗'ฃ>ฃxห_…9dั‘ix–i๔0ฦoE
ฐlชsFฟCฯ/แจมฬTbEฐ-^ลOฝeQ8ํ—ฃ7แ฿yวเฅcูฦN(=&กไฯฌ๚Aฏ๋:vF^)ฮ~จ3:ัณปป6…้dมb–(ฏะT'T7XSมGฒ-"JฺยHN’eฦ54V%}hs3๚2?แ”
!ผ(2ว๑มห฿N$
๔ืูอ7}["a;Aษไศ๎ๆึYบก2๊…<74A—ฅB็l;G๊pฐhnฏฒA] ฮหDo๕—)4ง๐f ุ๑๒–ใ้าจา[ูtะp
ใIทะ#\C^ ฬศ)(y#ลโN9ึาูชCดฟป]ฟญ|'
;DWๆธฑ…uฦหซฦwkIซGึฎ >๒Cmฅ4C์X้7ภ!EFbุู({ิJ้โ)R{xHซ]ไยhy๛jHฏย[โาผ!งเฌ%๔
@u๚L“ฯๅซPึ!ฑลฉศEZuาOีCฤ&ฦTณPHO6๋+sฤ“๔ญพซฆA…ฃ7i๊อั}ูcyงบ๒มOeปmPK์ณDโ_๙h
xl/styles.xml…”หn0๗}
ห๛ร‘Rต5‘บhT5T๊ึภV|A๖p
y๚ฺรE6ฬ>?’๛Q
rcนV)oN”€ชtอUา?E๙+%ชะ
R:ฅ๗ูงฤโ$เน@โwถg•[ํ
X0 ^T6ฅbEถ๊@2{ฃ{PnฅัF2tฉi#๋aต๕$)ข๓้๔%’+%jนDK*=(L้FYาhต)1
B–”ไยฤRยwฑEร_`'!V๎]ๆ๕ืวฑฯ*-ด!ฆ-S็ง๙๒ฒbrA<2มKรฝ…็ump!ึพฮ4Yา3D0*w Yโb๊ak
uTทM๑๙ึcว}“แ๒ ๒ธฐuํจ๋~๓อต]jSปoฟ74Hมeั๙B<๛๏ท9”
฿่Gํํ%k่๘K0!๑ุ=-ฐ฿bวๆ-๒ธี๛|ย๚^Lน็%dO,มไ๓‘ี8ภ–=ฬ-.xซ$L–ฐkJ:m๘ซร๛ำะร๕ใผ๒Rฉตคaฤ฿ฮSๅจ๋'ฆดaยบ๙ฐแ๊ฅะ9_5oฮุ,ญๆฬVYUโOfJซน6Vำสไ๊หณใH!+$]jhุ ฐXฅ”n๑Oจ๙ ฟัkี/~ัธTอ๑V:Sด#ฒPK์ณD ิขีxl/workbook.xmlQMo0ฝ๏Wบฏvถุ8–ฎ[uึฌ;+6]•DCค“ฆฟ~”’t๋mพP|ฯ๓หงเอ#ลฦิึ@lฉร๘ะุ_ซ๋ท๏ญaqฑs"4vl/oๆ[JkขGฃ๓3]ซต1Cฺ€อษศDฦYUq;@p|B#Dญ๔”…้กbq|๕ฎฎ/ชเ0f้8จ๏ฑ…+jงQ๖$ ผ•ฤl๓=๏U7฿\ะ{ผ5ฑ|๊P k์BฺยซDฦ๚ฮ๋s[-^”HF}=ีj@}(ไฆ๏ถท?CใZม
ฌบฑ๊ดฎัค+'๐9ั4฿Oญ้1ฑe_Jgภ๓Qx ํJ๘LQฟky_ฆrก้~ษจpม๖Uฃธ๕ฯlPc/j% ใ=สฎฑๅํ!ซจ‘Qั1XT฿๎ฬrbก)oายMW่ำ๕‘nบณBsํ ว]ถ5ฏ'ตูE
y๎C๙lมท๊lcณ?{ผค0z~๒~ฉู๏๑+นฒ1o9ฝ๘PK์ณDx่๗
%Mxl/worksheets/sheet1.xml[wชL๏็Wธผ€F0+ษทฯ็ณw$’ูF$ษ์๙๕J”nๅ๏*Mฝึ[๎ฒ+๐ื>6น/7ุ{๖1ฏบอ็ํฟ๖ถo๙้ฤงฯํCgปv6ึ}ฬq๗๙ฟ๑๐ํฟ๗๏ฎๆ"๛ฮyภ]เ๎เหอวยํ1ป๛หป๛แ์๙;w!ฏ~๐แัe๐vณt๕้csฃ฿–n>o0ร}๕^ช๒๙แnร#Iเn0i๎ํ๖๙ง…A๐๔เo๋๓ใร X๎ฦBฯF{nnNzk/"ณ”ืวผะ๎EC?|ๆ๐‘็~๏Sใ\่<๛บ๋yฐg฿อH%z๎ืo’๎Q8๒ฟ+ฆ%&X;">pลๆ่ฯ—[q7ุHแ฿Cgc้๑c๖!iQ่k๗ี๙‘D[Uฬ็’ไt/w3ณr+ห"ฏbูOะU't;ธsโYื๎ลศๅ—XjGโ>ฏงฏศฏ—ซ\>็a๓<lํcx‘ญ“AบA=ePS๊g็a๓<lํ๓ฐsvฯรyุื/+\uNRฮ้ฒsV+ศXฅp”*๑Tืขฌฎั…kฤ๕ฃด(KG้,mฅ%Yฺ:J
Yฺ>JMYฺ9JหฒดDกฌ^"Vข๋'b%ผA"Vโ&b%ภQ"V"'b%ฤI"Vb&b%ศY"Vข'ณขDนHฤJ”หDฌDนJฤJ”B$r%La%r%N‘ฌ'] T$JW"?KJ U$JWbษฒ*(มฦล:–ฆxฝhฉยP"ดาe5)‘ึณซึฌ Xฐ6`ภบ€๕๋6lุฐ1`ภฆ€อถl ุ
0!ดฌHk[ะโซ[ชรป๋ux—าTพ!ฌ4ฆ|KTำ๒MQป:Lc๊๎Pลคจ|ณ6 lI ๒ๅ&:จ|?wถGด}ศR0$wFษื iNมฑฮ)—h…ผขBIU4[CณY+^*ฮา๕โ,ฅUี]Rีmฒ.ีJPคX'ฐฌอี'ํฬK4ปเOฐ>`๒fXE2"pLดา8ฃ๔ฬIsQส.•%ฑฎJดmhัฺpHT)}ขจ]๚;งqฝ84ฏePqJ ฒ้ึ(N#;uๆณa@rถภd\ํึฮซซO1(!ัภื1ษ)3็เฯ—ุ•A•iเฦI9DซาbvชTๆ๕ฺ4ำชสญซeBmVLศDี`jคiฐ๊D ฺ&-ไP๊mh๛D; phย“(๙36ณ+bคS6น:7แห}A้Y’อi
aาฮjโฮhQ\๒ยพ{ฉ|หืหทๆUฆอ*ำึZืC€ูeุYหTe๎fส“hเOโ่–a๔์“;
dพศไLNศไ”ภไgN& ธlEA&…Uฆา2ฝ-Bซ5D3–ปTฺํ๕ฺๅ็;fKFี6$T}k$jขl U_เสชสWgDBโ6ฉv(ึ.บิ“Q๕ํY ๑Gจ;&ณ
vIกี9/ศฅ%๒ฎWิ$*ฌ]%ฏWฐณ`นtตาMnซeษจRบ UcฎJจบ๏h#o]F5ตฐ5,lv_ Ulษใ๒vํ!ฺ'ณLลS1ย$Qwvงจ;Cปsd^ ๓นBT{aกaQAๅ*F,jฬmg๙-WทQ้& ๕ืdKF/6f๊Wฯุ–ภห๚ฌช>ฺ"ฺ"โถฌชซ๕ซcBฐ=ฒฺGขC"‘Kcาๆณ4“QC-]BศผฤLฌPWTรJ–จฒ้รvท\บDิBคะ#ฃsชJ่ลwพ€m$ฎฃnั&2ทศๅ6wธhฬ๖%๐bg.`i๏xวN8#ๆr,ตฐXุ47+๒ID-D+Vั+Qร€…ม-WuF“–๎สPต,ฝุTทEฌ"๎ศEz…hํถ4jyขx:hต+ฃwิEผฃ.โ\ฤย-RแR*ฦะั)ข3rj3ฟ@โ%ดBT4,,+่จโ,รv,WpFs”–๎P+-ฝจ`๊ฉiิ3b#ZืจMJ.—ฆF].-๔ธญแฮ>u‘ธhอ"๓“<Ft่ัขsฟฮ฿’ๆ`EผB`……
๘๏๘‘MAษๅั>ฅฅ;ิgKF/nซฉอฅช•ฐธK๘&ปDoฒฑล
ั&ทPตhG+ัซl๊ฏ้a๛0CtyDนS<ด:%ีฆbฤD—์
Q!ZXs!ฎQcื์tสีัฅฅ๛Cิbฐd๔ข~
บฝ6ฐ|
ธ!ซิ๒5๐ฉุภอูภ7^_Xภฝ๒hศ;Dtษ์โไอ#บ@t่J3๘๎ฺเอูภc๗f2๘ู8ร/นz3:ดดtw๚ฟF–^T/๖ai&ฝฎ6๑ฅ–ป/ถbi&ํพุ…hั.ข=D๛u
4๏ญMผทฦฆ,ก ๅqJ3g/PwI>ญ<ๆ8*^฿l|cm๒๛j๓๏ToF––n )\4”ฑzฉ'จจญ•ฑ|หด๙–q๓-ใซ-B่T๊ขjั>4hjeผu.cํ–๑นธL?8Qg์อ.ศ์’Rฑ"PD-\QQ๑–๙ตVoษดสJัภฅง[Hิ>ทtlเากwฅฆCOญS_K]ว.ิm’ู9&ฐ.uํq_ง&ฌฉ1#DวN’S3gZ๑}Z!*ญ
aฑr…แ*F,ฐR๛ฎัมฅงD
j—ฎaํR๏IMง–u๋จะฉ%ฆฉCฯSภ6Zํ ว]"๎กร}$่ะ4$ซ#าฃK[ดa8sฬ๑\^"๑T…@]aกWQ๕"\Eำ5ฬ–ศ,c๕คNะI๒รไร๕cีู์|ฮW$฿ฎ๗/๎ึ <,9 t!๓7[U:๒ฟฯ"oปwฅW>ุ๘ณsท}ึ๎ฦ
]•แ(•u—฿๎Z๖v๏็€ฯะทฝM่'ัฮ๛๒ร๓ผqUถ้vsษw๓๔๐แoS’๖ฉ๑๑์&[ป?'คส๕๛ไ$ด๒.๐ถaw8L*๗v>ฎ)๑โ$วSv8ร)bุ9onื ขๅ6๎k2๒นเxุาa๚ปร่.{๖ระ๘นz?๛_โ ๓ร72๔นหํhฦรษK~เน๐pโีc>9)^)ฮ&ฦoฃ}ไี'้ดงไz๎ญร๗ไจซฃY๛`/ท๖^_ ข์ฏืต/w{ีภ๖}Z“‘ฅนพW—“ฌ๗ถeI"๙ำฟ^ฯถ2Gรฃ๕ฃ๘g์FๆOO_ฤใ“B๚โ5vํค"].NJ๒U:ัๅ้ณงPK์ณDอKR"x#xl/worksheets/_rels/sheet1.xml.relsM1!{_Aถ๗@cฬqื๙ฃุp+a!,1๚{)-'“yไคิ$ถp(bWถศยใ~AIG0&_X—|ฃ}4b5&,B๏๕ขตธ@e*•xgi๛ภๆuE๗BO๚hฬIท่ๅPK์ณDG’DฒX๐[Content_Types].xmlPK์ณDถ78้K_rels/.relsPK์ณD$ฑV้นxl/_rels/workbook.xml.relsPK์ณDฺg๙=ผdocProps/app.xmlPK์ณDเ”zRถขxdocProps/core.xmlPK์ณDs‘{Yณฆ]xl/theme/theme1.xmlPK์ณD€9ไ๕A
xl/sharedStrings.xmlPK์ณDโ_๙h
Wxl/styles.xmlPK์ณD ิขี{xl/workbook.xmlPK์ณDx่๗
%MJxl/worksheets/sheet1.xmlPK์ณDอKR"x#wxl/worksheets/_rels/sheet1.xml.relsPKั0
|
 |
 |
 |
 |
Date :
2014-04-28 22:32:14 |
By :
lin2online |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
อันนี้ครับ
Code (PHP)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="your_name.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
// This line will force the file to download
$objWriter->save('php://output');
code ผมนะครับ
Code (PHP)
<?php
/**
* PHPExcel
*
* Copyright (C) 2006 - 2011 PHPExcel
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
*
* @category PHPExcel
* @package PHPExcel
* @copyright Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
* @version 1.7.6, 2011-02-27
*/
/** Error reporting */
error_reporting(E_ALL);
error_reporting(E_ALL ^ E_NOTICE);
date_default_timezone_set('Europe/London');
/** PHPExcel */
require_once 'Classes/PHPExcel.php';
// Create new PHPExcel object
echo date('H:i:s') . " Create new PHPExcel object\n";
$objPHPExcel = new PHPExcel();
// Set properties
echo date('H:i:s') . " Set properties\n";
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
เนื้อหา
// Rename sheet
echo date('H:i:s') . " Rename sheet\n";
$objPHPExcel->getActiveSheet()->setTitle('My Customer');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
//Save Excel 2007 file
echo date('H:i:s') . " Write to Excel2007 format\n";
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$strFileName = "myData.xlsx";
$objWriter->save($strFileName);
// Echo memory peak usage
echo date('H:i:s') . " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB\r\n";
// Echo done
echo date('H:i:s') . " Done writing file.\r\n";
// Redirect output to a client’s web browser (Excel2007)
แบบนี้รันแล้วผ่านได้ไฟล์มา เปิดไฟล์ดูข้อมูลก็ถูกต้องครับ แต่มันไม่ขึ้นให้ดาวโหลดมันมาเก็บอยู่ในfolder web แทนครับ
|
 |
 |
 |
 |
Date :
2014-04-28 22:54:54 |
By :
lin2online |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
echo date('H:i:s') ทั้งหลาย คอมเมนต์ออกไปครับ
|
 |
 |
 |
 |
Date :
2014-04-29 00:28:36 |
By :
itpcc |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
ตอบความคิดเห็นที่ : 6 เขียนโดย : lin2online เมื่อวันที่ 2014-04-28 22:54:54
รายละเอียดของการตอบ ::
ลองดูนะครับ
Code (PHP)
<?php
/**
* PHPExcel
*
* Copyright (C) 2006 - 2011 PHPExcel
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
*
* @category PHPExcel
* @package PHPExcel
* @copyright Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
* @version 1.7.6, 2011-02-27
*/
/** Error reporting */
error_reporting(E_ALL);
error_reporting(E_ALL ^ E_NOTICE);
date_default_timezone_set('Europe/London');
/** PHPExcel */
require_once 'Classes/PHPExcel.php';
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
เนื้อหา
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('My Customer');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="your_name.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
// This line will force the file to download
$objWriter->save('php://output');
|
 |
 |
 |
 |
Date :
2014-04-29 14:42:51 |
By :
Freeland |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|