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

【非公式】PHPカンファレンス 2018 関西 前夜祭　での発表資料です
https://dbstudychugoku.connpass.com/event/92337/

Transcript

1. ʲඇެࣜʳ1)1ΧϯϑΝϨϯε
   
   ؔ੢
   લ໷ࡇ
    #"4&גࣜձࣾ
   
   ౦ޱ࿨ᏻʢ!,IJHBTIJHVDIJʣ
   1IQ4QSFBETIFFU
   τϥϒϧγϡʔςΟϯά
2. 1)1Ͱ&YDFMग़ྗͨ͜͠ ͱ͋Δਓ
3. ճ͚ͩ
4. ͜͏͍͏ܥ͸
   ͬ͞ͱऴΘΒ͍ͤͨ
6. Կ͔͋ͬͨͱ͖ͷϊ΢ϋ ΢͕গͳͯ͘ࠔͬͨ
7. ͜͏͍͏ࣄ͕͋ͬͨͱ͍ ͏஌ݟͷڞ༗✍
8. ࣗݾ঺հ !,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
9. 1IQ4QSFBETIFFU w &YDFMͷಡΈॻ͖Λ͢ΔϥΠϒϥϦ
   w "
   QVSF
   1)1
   MJCSBSZ
   GPS
   SFBEJOH
   BOE
   XSJUJOH
   TQSFBETIFFU
   GJMFT
   w IUUQTHJUIVCDPN1)10GGJDF1IQ4QSFBETIFFU
   w 4PGUXBSF
   SFRVJSFNFOUT
   w 1)1
   WFSTJPO
   
   PS
   OFXFS
   w ʜFUD
   w 1)1&YDFMͷޙܧϥΠϒϥϦ
   w 1)1&YDFM͸΋͸΍ϝϯς͞Εͳ͍
10. )FMMP
    8PSME <?php require 'vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 'Hello World !'); $writer = new Xlsx($spreadsheet); $writer->save('hello world.xlsx'); IUUQTQIQTQSFBETIFFUSFBEUIFEPDTJPFOEFWFMPQ
11. ͱͯ΋؆୯ͦ͏
12. 1IQ4QSFBETIFFUΛ׆༻͢Δ w ॲཧϑϩʔ
    w σʔλΛ%#͔Βऔಘ
    w 5FNQMBUFͱͳΔ&YDFMΛಡΈࠐΉ
    w σʔλΛ&YDFMʹॻ͖ࠐΉ
    w &YDFMΛग़ྗ͢Δ
    w 5FNQMBUFͷ&YDFMϑΝΠϧ
    w ϚΫϩ෇͖ͷYMTN
    w ೖྗنଇͷઃఆ
    w ݻఆ΢Οϯυ΢࿮ͷઃఆ
13. 1IQ4QSFBETIFFUΛ׆༻͢Δ w ࣮૷ίʔυͷ֓ཁ͸Լهͷ௨Γ ˠ͜Ε͚ͩͰಈ͘ͷ͔ɺ͍͢͝ʂ
14. ͏Μɺͱͯ΋؆୯ͦ͏
15. ͦΕͳΓʹݥ͍͠ಓͩͬ ͨ%
16. 5SPVCMF
17. 5SPVCMF
    
    5FNQMBUF͕YNMಡΈࠐΈΤϥʔͰࣦഊ w 5SPVCMF
    w 5FNQMBUFϑΝΠϧΛಡΈࠐΉࡍʹΤϥʔ
    w 8BSOJOH
    &SSPS
    TJNQMFYNM@MPBE@TUSJOH
    w &OUJUZ
    MJOF
    
    QBSTFS
    FSSPS
    
    0QFOJOH
    BOE
    FOEJOH
    UBH
    NJTNBUDI
    CS
    MJOF
    
    BOE
    C
    w $BVTF
    w 9NMܗࣜͱͯ͠ಡΈࠐΊͳ͍Τϥʔ
    w 4PMWF
    w &YDFMΛYNMϑΝΠϧΛѹॖͨ͠;*1ϑΝΠϧͱͯ͠ଊ͑ Δ
18. 5SPVCMF
    
    5FNQMBUF͕YNMಡΈࠐΈΤϥʔͰࣦഊ 
    VO[JQ
    ΤΫηϧϑΝΠϧ
    <$POUFOU@5ZQFT>YNM
    @SFMTSFMT
    YM@SFMTXPSLCPPLYNMSFMT
    YMXPSLCPPLYNM
    YMTUZMFTYNM
    YMXPSLTIFFUT@SFMTTIFFUYNMSFMT
    YMXPSLTIFFUTTIFFUYNM
    YMUIFNFUIFNFYNM
    YMXPSLTIFFUTTIFFUYNM
    YMTIBSFE4USJOHTYNM
    EPD1SPQTDPSFYNM
    YMQSJOUFS4FUUJOHTQSJOUFS4FUUJOHTCJO
    EPD1SPQTBQQYNM
    
19. 4IPPUJOH
    
    5FNQMBUF͕YNMಡΈࠐΈΤϥʔͰࣦഊ CS
    Λ
    CSʹमਖ਼͢Δ͜ͱͰYNMಡΈࠐΈΤϥʔΛղফ
    
    
    
    WUFYUCPY
    TUZMFNTPEJSFDUJPOBMUBVUP
    PTJOHMFDMJDLG
    
    
    
    EJW
    TUZMFUFYUBMJHODFOUFSGPOU
    GBDF̢̨
    ̥ΰ γοΫ
    TJ[F
    
    
    
    DPMPSCϚCGPOUGPOU
    GBDF̢̨
    ̥ΰγοΫ
    TJ[F
    
    
    
    DPMPSCΫCGPOUGPOU
    GBDF̢̨
    ̥ΰγοΫ
    TJ[F
    
    
    
    DPMPSCϩCGPOUGPOU
    GBDF̢̨
    ̥ΰγοΫ
    TJ[F
    
    
    
    DPMPSlzC
    CS
    C
20. ղܾ
21. 5SPVCMF
22. 5SPVCMF
    
    5FNQMBUFಡΈࠐΈͰϝϞϦʔϦʔΫ w 5SPVCMF
    w 5FNQMBUFϑΝΠϧΛಡΈࠐΉͰϝϞϦʔϦʔΫ
    w 1)1
    'BUBM
    &SSPS
    "MMPXFE
    .FNPSZ
    4J[F
    PG
    YYY
    #ZUFT
    &YIBVTUFE
    w $BVTF
    w &YDFM
    5FNQMBUFΛಡΈࠐΈͷʹϝϞϦΛଟ͘࢖͏
    w 5FNQMBUFͷαΠζ
    .#
    w ϝϞϦʹల։ޙͷϝϞϦ࢖༻αΠζɿ.#
    w 4PMWF
    w ʮೖྗنଇʯΛ&YDFM͔Β֎͢͜ͱͰαΠζܰݮ
    w Ұ࣌తʹ1)1ͷׂ౰ϝϞϦαΠζΛ૿΍͢
    w PGGNFNPSZ
    FH
    PO
    EJTL
    JO
    "1$V
    NFNDBDIF
    PS
    SFEJT
23. 4IPPUJOH
    
    5FNQMBUFಡΈࠐΈͰϝϞϦʔϦʔΫ w Ұ࣌తʹ1)1ͷׂ౰ϝϞϦαΠζΛ૿΍͢ JOJ@TFU NFNPSZ@MJNJU
    bYYY. 
    w ʮೖྗنଇʯΛ&YDFM͔Β֎͢͜ͱͰαΠζܰݮ
    w ϝϞϦల։ޙͷαΠζൺֱ
    w ʮೖྗنଇʯ͋Γ
    .#
    w ʮೖྗنଇʯͳ͠
    .#
    w PGGNFNPSZ
    FH
    PO
    EJTL
    JO
    "1$V
    NFNDBDIF
    PS
    SFEJT
    w ϝϞϦʹల։ͤͣɺNFNDBDIF΍SFEJTΛར༻
    w IUUQTQIQTQSFBETIFFUSFBEUIFEPDTJPFO EFWFMPQUPQJDTNFNPSZ@TBWJOH
24. 4IPPUJOH
    
    5FNQMBUFಡΈࠐΈͰϝϞϦʔϦʔΫ w ͦͷଞ஫ҙ఺
    w ϧʔϓॲཧͰෳ਺ճ࣮ߦ͢Δ৔߹ɺ౎౓ϝϞϦղ์͠ͳ͍ ͱੵΈ্͕͍ͬͯ͘
    w อଘޙʹຖճϝϞϦΛ։์͢Δ
    w TQSFBETIFFUEJTDPOOFDU8PSLTIFFUT 
    
25. ղܾ
26. 5SPVCMF
27. 5SPVCMF
    
    ݻఆ΢Οϯυ΢͕֎ΕΔ w 5SPVCMF
    w ઃఆ͞Εͯ͋ͬͨʮݻఆ΢Οϯυ΢࿮ʯ͕֎ΕΔ
    w $BVTF
    w 5FNQMBUFಡΈࠐΈޙʮݻఆ΢Οϯυ΢࿮ʯͷઃఆ͕֎Ε ͯͨ
    w 4PMWF
    w ΋͏Ұճઃఆ͠௚͢
28. 4IPPUJOH
    
    ݻఆ΢Οϯυ΢͕֎ΕΔ w ΋͏Ұճઃఆ͠௚͢
    w (ηϧΛى఺ʹݻఆ͢Δؔ਺
    w TIFFUGSFF[F1BOF b(` 
29. ղܾ
30. ·ͱΊ
31. ·ͱΊ w &YDFMΛѻ͏৔߹ʹ͸1IQ4QSFBETIFFU͸ศར
    w Կ͔͋ͬͨͱ͖ʹɺ&YDFMࣗମͷ໰୊ͱ1IQ4QSFBETIFFU ͷ࢖͍ํͷ໰୊͔੾Γ෼͚͕Ή͍ͣ
    w σόοάͷ݁Ռɺ&YDFMࣗମͷ࢓༷ʹগ͠ৄ͘͠ͳͬͨ
    w தͷYNMΛ͍͡ΔͳͲͳͲ
32. #"4&גࣜձࣾ
    
    ౦ޱ࿨ᏻʢ!,IJHBTIJHVDIJʣ
    ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ