Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
LaraCSVで手軽にCSVを出力する/Easily generate CSV by Lar...
Search
kkznch
May 16, 2019
Technology
0
1.7k
LaraCSVで手軽にCSVを出力する/Easily generate CSV by LaraCSV
Laravel Meetup宮崎
登壇枠で使用
参考URL
https://re-build.connpass.com/event/129466/
kkznch
May 16, 2019
Tweet
Share
More Decks by kkznch
See All by kkznch
黒い画面へようこそ/Hello, black screen
kkznch
0
410
VueRouterとNuxtのルーティング/VueRouter and Nuxt Routing
kkznch
0
370
Vuexで何を管理する方が良い?/What is better to store in Vuex?
kkznch
1
770
Firestoreのルール設定 割と何でも出来てビビる/Firestore rule setting
kkznch
1
820
自社サービス チャット機能にFirebaseが導入されてた/Firebase was introduced to the chat function of our service
kkznch
0
1.2k
SPA開発未経験者によるNuxt.jsを使った自社サービス開発 / Development of own service using Nuxt.js by inexperienced SPA development
kkznch
3
3.3k
Laravel Telescopeが便利そうな気がする/Laravel Telescope seems to be convenience
kkznch
1
1.2k
Laravel Novaはなんだかいい感じらしい/Laravel Nova seems to be nice
kkznch
0
660
Laravel5.5的 継続的インテグレーション / Laravel 5.5 Continuous Integration
kkznch
3
3.6k
Other Decks in Technology
See All in Technology
ソースを読む時の思考プロセスの例-MkDocs
sat
PRO
1
320
ざっくり学ぶ 『エンジニアリングリーダー 技術組織を育てるリーダーシップと セルフマネジメント』 / 50 minute Engineering Leader
iwashi86
5
2.8k
AIを使ってテストを楽にする
kworkdev
PRO
0
240
ViteとTypeScriptのProject Referencesで 大規模モノレポのUIカタログのリリースサイクルを高速化する
shuta13
3
220
Kubernetes self-healing of your workload
hwchiu
1
610
生成AI時代のPythonセキュリティとガバナンス
abenben
0
150
Open Table Format (OTF) が必要になった背景とその機能 (2025.10.28)
simosako
2
400
可観測性は開発環境から、開発環境にもオブザーバビリティ導入のススメ
layerx
PRO
4
1.8k
プロファイルとAIエージェントによる効率的なデバッグ / Effective debugging with profiler and AI assistant
ymotongpoo
1
510
GraphRAG グラフDBを使ったLLM生成(自作漫画DBを用いた具体例を用いて)
seaturt1e
1
160
AWS re:Invent 2025事前勉強会資料 / AWS re:Invent 2025 pre study meetup
kinunori
0
770
ハノーファーメッセ2025で見た生成AI活用ユースケース.pdf
hamadakoji
1
500
Featured
See All Featured
How STYLIGHT went responsive
nonsquared
100
5.9k
The Art of Delivering Value - GDevCon NA Keynote
reverentgeek
16
1.7k
YesSQL, Process and Tooling at Scale
rocio
173
15k
The Cost Of JavaScript in 2023
addyosmani
55
9.1k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
34
2.5k
Building Adaptive Systems
keathley
44
2.8k
A Tale of Four Properties
chriscoyier
161
23k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
667
130k
How to train your dragon (web standard)
notwaldorf
97
6.3k
Six Lessons from altMBA
skipperchong
29
4k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
253
22k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
194
16k
Transcript
LaraCSVͰ खܰʹCSVΛग़ྗ͢Δ גࣜձࣾRe:Build Յ ါىʢ@kkznchʣ 20195݄16ʢʣ Laravel Meetup Miyazaki
͚͚ͣΜ @kkznch Յ ါى 1990ͷԭೄੜ·Ε ిྗձࣾͷITΠϯϑϥɺηΩϡϦςΟ ↓ גࣜձࣾRe:BuildͰWebΤϯδχΞ
ձࣾհ • גࣜձࣾRe:Buildʢ201711݄ʹઃཱʣ • ݱࡏͷࣾһ໊̑ • ԭೄΛڌͱ͠ɺجຊతʹLaravelVue.jsΛ ͬͯडୗɾࣗࣾαʔϏε։ൃΛ͍ͯ͠Δ • ϦϞʔτϫʔΫɺࣗ༝ͳಇ͖ํΛਪ͍ͯ͠Δ
LaraCSV
None
͍ํ
ϥΠϒϥϦΛՃ͢Δ # 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ΛͲ͏ͧ