Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
LaraCSVで手軽にCSVを出力する/Easily generate CSV by Lar...
Search
kkznch
May 16, 2019
Technology
1.8k
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
LaraCSVで手軽にCSVを出力する/Easily generate CSV by LaraCSV
Laravel Meetup宮崎
登壇枠で使用
参考URL
https://re-build.connpass.com/event/129466/
kkznch
May 16, 2019
Transcript
23 slides
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ΛͲ͏ͧ
More Decks by kkznch
See All by kkznch
黒い画面へようこそ/Hello, black screen
kkznch
0
450
VueRouterとNuxtのルーティング/VueRouter and Nuxt Routing
kkznch
0
400
Vuexで何を管理する方が良い?/What is better to store in Vuex?
kkznch
1
830
Firestoreのルール設定 割と何でも出来てビビる/Firestore rule setting
kkznch
1
900
自社サービス チャット機能にFirebaseが導入されてた/Firebase was introduced to the chat function of our service
kkznch
0
1.3k
SPA開発未経験者によるNuxt.jsを使った自社サービス開発 / Development of own service using Nuxt.js by inexperienced SPA development
kkznch
3
3.5k
Laravel Telescopeが便利そうな気がする/Laravel Telescope seems to be convenience
kkznch
1
1.3k
Laravel Novaはなんだかいい感じらしい/Laravel Nova seems to be nice
kkznch
0
690
Laravel5.5的 継続的インテグレーション / Laravel 5.5 Continuous Integration
kkznch
3
3.8k
Other Decks in Technology
See All in Technology
AI-DLCでソフトウェア開発の速さは 上がったのか?
rfdnxbro
0
120
目を覚ませ!僕らの認証情報が何者かに侵略されてるぞ
tkito
2
490
お風呂場をサーバルームにしよう
yusuke427
0
400
Is the Website Dying?
miriamschwab
0
150
落とし穴にハマってわかった 開発生産性を測るときに気をつけたいこと
munakata
3
490
Kiro のリモートワークスペース: IDE は手元のままで、ワークスペースをクラウド、コンテナ、自前のマシンに置く
inariku
PRO
1
160
現場に渡し、構造で守る AI エージェントを活用したセルフサーブのデータ基盤の運用
legalontechnologies
PRO
0
110
Taking back control of your AI development
inesmontani
PRO
0
310
攻撃と守りは何が変わり、何が変わらないのか~最近の不正アクセスから考える、リスク評価と標準の使いどころ
oidfj
2
320
Terraform 0 to 100:100個以上のリポジトリを常に最新にし続けるための自動化
sue445
3
1.4k
OpenTelemetryで変わった 新時代のCloudWatchメトリクス監視
tsukuboshi
0
500
セキュリティチームは どのコンテナイメージの脆弱性対応を優先すべきか 〜CISA新指針とSCCで作る脆弱性トリアージ〜
swdtkuy
0
330
Featured
See All Featured
Chasing Engaging Ingredients in Design
codingconduct
0
410
Leo the Paperboy
mayatellez
11
2.5k
Rebuilding a faster, lazier Slack
samanthasiow
85
9.8k
VelocityConf: Rendering Performance Case Studies
addyosmani
331
25k
Thoughts on Productivity
jonyablonski
76
5.5k
Statistics for Hackers
jakevdp
799
230k
How People are Using Generative and Agentic AI to Supercharge Their Products, Projects, Services and Value Streams Today
helenjbeal
2
400
A Guide to Academic Writing Using Generative AI - A Workshop
ks91
PRO
1
580
Become a Pro
speakerdeck
PRO
31
6.4k
Neural Spatial Audio Processing for Sound Field Analysis and Control
skoyamalab
0
630
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
162
16k
Stop Working from a Prison Cell
hatefulcrawdad
274
21k