LaraCSVͰ खܰʹCSVΛग़ྗ͢Δ גࣜձࣾRe:Build Յ਺ ါىʢ@kkznchʣ 2019೥5݄16೔ʢ໦ʣ Laravel Meetup Miyazaki 

͚͚ͣΜ @kkznch Յ਺ ါى 1990೥ͷԭೄੜ·Ε ిྗձࣾͷITΠϯϑϥɺηΩϡϦςΟ ↓ גࣜձࣾRe:BuildͰWebΤϯδχΞ 

ձࣾ঺հ • גࣜձࣾRe:Buildʢ2017೥11݄ʹઃཱʣ • ݱࡏͷࣾһ਺͸໊̑ • ԭೄΛڌ఺ͱ͠ɺجຊతʹ͸Laravel΍Vue.jsΛ ࢖ͬͯडୗɾࣗࣾαʔϏε։ൃΛ͍ͯ͠Δ • ϦϞʔτϫʔΫɺࣗ༝ͳಇ͖ํΛਪ঑͍ͯ͠Δ 

LaraCSV 

No content

࢖͍ํ 

ϥΠϒϥϦΛ௥Ճ͢Δ # terminal͔ΒԼهͷίϚϯυΛ࣮ߦ͢Δ $ composer require usmanhalalit/laracsv:^2.0 

CSVͷϏϧυ // ΠϯελϯεΛੜ੒͢Δ $csvExporter = new \Laracsv\Export(); // ୈҰҾ਺ʹCollectionΛɺ // ୈೋҾ਺ʹCSVͰग़ྗ͍ͨ͠ϞσϧͷΧϥϜ໊Λೖྗ͢Δ $csvExporter->build(Users::get(), ['email', 'name']); 

CSVͷμ΢ϯϩʔυ // μ΢ϯϩʔυ͢Δ $csvExporter->download(); email,name [email protected],"Ԭ෦ ྙଠ࿠" [email protected],"௣໊ ·ΏΓ" [email protected],"ڮా ࢸ" // ϑΝΠϧ໊Λࢦఆͯ͠μ΢ϯϩʔυ͢Δ $csvExporter->download('users.csv'); 

ྑ͍ͱࢥͬͨͱ͜Ζ 

ϦϨʔγϣϯ΋औಘ͢Δ // Ϟσϧʹఆٛ͞Ε͍ͯΔϦϨʔγϣϯΛࢦఆ͢Δ͚ͩ $csvExporter->build(Users::get(), ['email', 'name', ‘department.name’]); 

஋ͷ௥Ճɾมߋ͕Ͱ͖Δ $csvExporter->beforeEach(function($user) { // طଘͷ஋Λ্ॻ͖Ͱ͖Δ $user->email = '[email protected]'; // ଘࡏ͠ͳ͍஋Λ௥ՃͰ͖Δ $user->note = $user->name . 'ϝϞͰ͢'; }); $csvExporter->build(User::get(), [‘email', 'name', ‘note'])->download(); email,name,note [email protected],"Ԭ෦ ྙଠ࿠","Ԭ෦ ྙଠ࿠ϝϞͰ͢" [email protected],"௣໊ ·ΏΓ","௣໊ ·ΏΓϝϞͰ͢" 

࣮຿Ͱͷ࢖͍ॴ͸ʁ 

࢖͍ॴ • τϥϯβΫγϣϯσʔλͷCSVग़ྗ • ܭࢉ݁ՌΛ֨ೲͨ͠࿈૝഑ྻͷCSVग़ྗ ‣ ഑ྻΛCollectionܕʹม׵ͯ͠౉͢ͱಈ͘ 

CSVϥΠϒϥϦͷൺֱ 

CSVϥΠϒϥϦ ͍Ζ͍Ζ͋Δ 

Packalyst ʢCSVϥΠϒϥϦ DL਺߱ॱʣ 

৮Γͭͭ଎౓Λൺֱͯ͠Έͨ 

ൺֱର৅ • laracsv • excel • laravel-formatter • fast-excel 

࣮ݧ • string(255)ܕΧϥϜΛ10ݸ࣋ͭςʔϒϧ • Ϩίʔυ਺͸5120݅ • ֤ϥΠϒϥϦͰCSVϑΝΠϧΛग़ྗ͢Δ·Ͱ ͷ࣌ؒΛଌఆ͢Δ 

݁Ռ ࣌ؒʢඵʣ ίϝϯτ MBSBDTW  ଎౓͸஗͍͕࢖͍উख͸Α͍ FYDFM  ग़ྗ͢ΔͨΊʹ&YQPSU༻ΫϥεΛ ༻ҙ͢Δඞཁ͕͋ͬͯ໘౗͍͘͞ MBSBWFMGPSNBUUFS  ϑΥʔϚοτͷม׵͚ͩߦΘΕΔɻ ϑΝΠϧ΁ͷॻ͖ग़͠͸ཁࣗ࡞ GBTUFYDFM  ଌఆϛεͬͨͷ͔ͳʜ
ϫϯϥΠφʔͰ$47ര଎ग़ྗ͸૲ 

·ͱΊ 

·ͱΊ • LaraCSVͰखܰʹCSVͷग़ྗ͕Ͱ͖Δ ‣ ग़ྗ͢ΔΧϥϜͷࢦఆ͕༰қ ‣ ϦϨʔγϣϯઌͷ஋΋ࢦఆͰ͖Δ • ଎͞Λ௥ٻ͢Δ͋ͳͨ͸fast-excelΛͲ͏ͧ