PhpSpreadsheetトラブルシューティング at 【非公式】PHPカンファンレンス関西2018前夜祭

by Kazuki Higashiguchi

Slide 1

Slide 1 text

ʲඇެࣜʳ1)1ΧϯϑΝϨϯεؔ੢લ໷ࡇ #"4&גࣜձࣾ ౦ޱ࿨ᏻʢ!,IJHBTIJHVDIJʣ 1IQ4QSFBETIFFU τϥϒϧγϡʔςΟϯά

Slide 2

Slide 2 text

1)1Ͱ&YDFMग़ྗͨ͜͠ ͱ͋Δਓ

Slide 3

Slide 3 text

ճ͚ͩ

Slide 4

Slide 4 text

͜͏͍͏ܥ͸ ͬ͞ͱऴΘΒ͍ͤͨ

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

Կ͔͋ͬͨͱ͖ͷϊ΢ϋ ΢͕গͳͯ͘ࠔͬͨ

Slide 7

Slide 7 text

͜͏͍͏ࣄ͕͋ͬͨͱ͍ ͏஌ݟͷڞ༗✍

Slide 8

Slide 8 text

ࣗݾ঺հ !,IJHBTIJHVDIJ౦ޱ࿨ᏻ w ॴଐɿ#"4&גࣜձࣾ #"4&1SPEVDU%JWJTJPO αʔόαΠυΤϯδχΞ w ग़਎ɿฌݿݝ੢ٶࢢ w ͜Ε·Ͱͷओͳ͓࢓ࣄɿ w ʮ#"4&ʯͷܾࡁྖҬ w 1)1ɾ$BLF1)1ͷόʔδϣϯΞοϓ w ࢖༻ݴޠɿ1)1(P w #MPH w IUUQLIJHBTIJHBTIJIBUFOBCMPHDPN w (JUIVC w IUUQTHJUIVCDPN,IJHBTIJHVDIJ

Slide 9

Slide 9 text

1IQ4QSFBETIFFU w &YDFMͷಡΈॻ͖Λ͢ΔϥΠϒϥϦ w "QVSF1)1MJCSBSZGPSSFBEJOHBOEXSJUJOH TQSFBETIFFUGJMFT w IUUQTHJUIVCDPN1)10GGJDF1IQ4QSFBETIFFU w 4PGUXBSFSFRVJSFNFOUT w 1)1WFSTJPOPSOFXFS w ʜFUD w 1)1&YDFMͷޙܧϥΠϒϥϦ w 1)1&YDFM͸΋͸΍ϝϯς͞Εͳ͍

Slide 10

Slide 10 text

)FMMP8PSME getActiveSheet(); $sheet->setCellValue('A1', 'Hello World !'); $writer = new Xlsx($spreadsheet); $writer->save('hello world.xlsx'); IUUQTQIQTQSFBETIFFUSFBEUIFEPDTJPFOEFWFMPQ

Slide 11

Slide 11 text

ͱͯ΋؆୯ͦ͏

Slide 12

Slide 12 text

1IQ4QSFBETIFFUΛ׆༻͢Δ w ॲཧϑϩʔ w σʔλΛ%#͔Βऔಘ w 5FNQMBUFͱͳΔ&YDFMΛಡΈࠐΉ w σʔλΛ&YDFMʹॻ͖ࠐΉ w &YDFMΛग़ྗ͢Δ w 5FNQMBUFͷ&YDFMϑΝΠϧ w ϚΫϩ෇͖ͷYMTN w ೖྗنଇͷઃఆ w ݻఆ΢Οϯυ΢࿮ͷઃఆ

Slide 13

Slide 13 text

1IQ4QSFBETIFFUΛ׆༻͢Δ w ࣮૷ίʔυͷ֓ཁ͸Լهͷ௨Γ ˠ͜Ε͚ͩͰಈ͘ͷ͔ɺ͍͢͝ʂ

Slide 14

Slide 14 text

͏Μɺͱͯ΋؆୯ͦ͏

Slide 15

Slide 15 text

ͦΕͳΓʹݥ͍͠ಓͩͬ ͨ%

Slide 16

Slide 16 text

5SPVCMF

Slide 17

Slide 17 text

5SPVCMF 5FNQMBUF͕YNMಡΈࠐΈΤϥʔͰࣦഊ w 5SPVCMF w 5FNQMBUFϑΝΠϧΛಡΈࠐΉࡍʹΤϥʔ w 8BSOJOH&SSPSTJNQMFYNM@MPBE@TUSJOH w &OUJUZMJOFQBSTFSFSSPS0QFOJOHBOE FOEJOHUBHNJTNBUDICSMJOFBOEC w $BVTF w 9NMܗࣜͱͯ͠ಡΈࠐΊͳ͍Τϥʔ w 4PMWF w &YDFMΛYNMϑΝΠϧΛѹॖͨ͠;*1ϑΝΠϧͱͯ͠ଊ͑ Δ

Slide 18

Slide 18 text

5SPVCMF 5FNQMBUF͕YNMಡΈࠐΈΤϥʔͰࣦഊ VO[JQΤΫηϧϑΝΠϧ <$POUFOU@5ZQFT>YNM @SFMTSFMT YM@SFMTXPSLCPPLYNMSFMT YMXPSLCPPLYNM YMTUZMFTYNM YMXPSLTIFFUT@SFMTTIFFUYNMSFMT YMXPSLTIFFUTTIFFUYNM YMUIFNFUIFNFYNM YMXPSLTIFFUTTIFFUYNM YMTIBSFE4USJOHTYNM EPD1SPQTDPSFYNM YMQSJOUFS4FUUJOHTQSJOUFS4FUUJOHTCJO EPD1SPQTBQQYNM

Slide 19

Slide 19 text

4IPPUJOH 5FNQMBUF͕YNMಡΈࠐΈΤϥʔͰࣦഊ CSΛCSʹमਖ਼͢Δ͜ͱͰYNMಡΈࠐΈΤϥʔΛղফ WUFYUCPYTUZMFNTPEJSFDUJPOBMUBVUP PTJOHMFDMJDLG EJWTUZMFUFYUBMJHODFOUFSGPOUGBDF̢̨̥ΰ γοΫTJ[F DPMPSCϚCGPOUGPOUGBDF̢̨ ̥ΰγοΫTJ[F DPMPSCΫCGPOUGPOUGBDF̢̨ ̥ΰγοΫTJ[F DPMPSCϩCGPOUGPOUGBDF̢̨ ̥ΰγοΫTJ[F DPMPSlzCCSC

Slide 20

Slide 20 text

ղܾ

Slide 21

Slide 21 text

5SPVCMF

Slide 22

Slide 22 text

5SPVCMF 5FNQMBUFಡΈࠐΈͰϝϞϦʔϦʔΫ w 5SPVCMF w 5FNQMBUFϑΝΠϧΛಡΈࠐΉͰϝϞϦʔϦʔΫ w 1)1'BUBM&SSPS"MMPXFE.FNPSZ4J[FPG YYY#ZUFT&YIBVTUFE w $BVTF w &YDFM5FNQMBUFΛಡΈࠐΈͷʹϝϞϦΛଟ͘࢖͏ w 5FNQMBUFͷαΠζ.# w ϝϞϦʹల։ޙͷϝϞϦ࢖༻αΠζɿ.# w 4PMWF w ʮೖྗنଇʯΛ&YDFM͔Β֎͢͜ͱͰαΠζܰݮ w Ұ࣌తʹ1)1ͷׂ౰ϝϞϦαΠζΛ૿΍͢ w PGGNFNPSZ FHPOEJTL JO"1$V NFNDBDIF PSSFEJT

Slide 23

Slide 23 text

4IPPUJOH 5FNQMBUFಡΈࠐΈͰϝϞϦʔϦʔΫ w Ұ࣌తʹ1)1ͷׂ౰ϝϞϦαΠζΛ૿΍͢ JOJ@TFU NFNPSZ@MJNJU bYYY. w ʮೖྗنଇʯΛ&YDFM͔Β֎͢͜ͱͰαΠζܰݮ w ϝϞϦల։ޙͷαΠζൺֱ w ʮೖྗنଇʯ͋Γ.# w ʮೖྗنଇʯͳ͠.# w PGGNFNPSZ FHPOEJTL JO"1$V NFNDBDIFPS SFEJT w ϝϞϦʹల։ͤͣɺNFNDBDIF΍SFEJTΛར༻ w IUUQTQIQTQSFBETIFFUSFBEUIFEPDTJPFO EFWFMPQUPQJDTNFNPSZ@TBWJOH

Slide 24

Slide 24 text

4IPPUJOH 5FNQMBUFಡΈࠐΈͰϝϞϦʔϦʔΫ w ͦͷଞ஫ҙ఺ w ϧʔϓॲཧͰෳ਺ճ࣮ߦ͢Δ৔߹ɺ౎౓ϝϞϦղ์͠ͳ͍ ͱੵΈ্͕͍ͬͯ͘ w อଘޙʹຖճϝϞϦΛ։์͢Δ w TQSFBETIFFUEJTDPOOFDU8PSLTIFFUT

Slide 25

Slide 25 text

ղܾ

Slide 26

Slide 26 text

5SPVCMF

Slide 27

Slide 27 text

5SPVCMF ݻఆ΢Οϯυ΢͕֎ΕΔ w 5SPVCMF w ઃఆ͞Εͯ͋ͬͨʮݻఆ΢Οϯυ΢࿮ʯ͕֎ΕΔ w $BVTF w 5FNQMBUFಡΈࠐΈޙʮݻఆ΢Οϯυ΢࿮ʯͷઃఆ͕֎Ε ͯͨ w 4PMWF w ΋͏Ұճઃఆ͠௚͢

Slide 28

Slide 28 text

4IPPUJOH ݻఆ΢Οϯυ΢͕֎ΕΔ w ΋͏Ұճઃఆ͠௚͢ w (ηϧΛى఺ʹݻఆ͢Δؔ਺ w TIFFUGSFF[F1BOF b(`

Slide 29

Slide 29 text

ղܾ

Slide 30

Slide 30 text

·ͱΊ

Slide 31

Slide 31 text

·ͱΊ w &YDFMΛѻ͏৔߹ʹ͸1IQ4QSFBETIFFU͸ศར w Կ͔͋ͬͨͱ͖ʹɺ&YDFMࣗମͷ໰୊ͱ1IQ4QSFBETIFFU ͷ࢖͍ํͷ໰୊͔੾Γ෼͚͕Ή͍ͣ w σόοάͷ݁Ռɺ&YDFMࣗମͷ࢓༷ʹগ͠ৄ͘͠ͳͬͨ w தͷYNMΛ͍͡ΔͳͲͳͲ

Slide 32

Slide 32 text

#"4&גࣜձࣾ ౦ޱ࿨ᏻʢ!,IJHBTIJHVDIJʣ ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ