Memo/PHP/Excelファイル生成 - DEX Lab

Memo/PHP/Excelファイル生成

https://dexlab.net:443/pukiwiki/index.php?Memo/PHP/Excel%A5%D5%A5%A1%A5%A4%A5%EB%C0%B8%C0%AE

[ トップ ] [ 編集 | 凍結 | 差分 | バックアップ | 添付 | リロード ] [ 新規 | 一覧 | 単語検索 | 最終更新 | ヘルプ ]

Top / Memo / PHP / Excelファイル生成

Software

Programming

Game

雑記

連絡先

TreeView

Memo (569)
- ACDSee
- ASP
- ASP.NET
- Adobe
- Affiliate
- Aipo
- Akelos (3)
  - sample (2)
    - ajax
    - pref
- Algorithm (1)
  - image
- Aliyun (1)
  - cli
- AmazonWebServices (66)
  - ACM
  - APIGateway
  - Alexa
  - Athena
  - Backup
  - Billing
  - CDK
  - CloudFormation
  - CloudFront
  - CloudTrail
  - CloudWatch
  - CodeBuild
  - CodeCommit
  - CodeDeploy
  - CodePipeline
  - Configservice
  - Connect
  - DataPipeline
  - Detective
  - DirectConnect
  - DirectoryService
  - DocumentDB
  - DynamoDB
  - EC2 (3)
    - AMI
    - DLM
    - mock-ec2-metadata
  - ECR
  - EKS
  - ELB
  - EMR
  - ElastiCache
  - ElasticBeanstalk
  - Fargate
  - Glacier
  - GuardDuty
  - IAM
  - IPv6
  - IoT
  - Lambda
  - Organizations
  - R53
  - RDS
  - Route53
  - S3
  - SDB
  - SDK (1)
    - Python
  - SES
  - SNS
  - SSO
  - SystemsManager
  - VPC
  - VPN
  - WAF
  - awscli (10)
    - CloudWatch
    - DynamoDB
    - EC2
    - RDS
    - S3
    - ce
    - elb
    - error
    - route53
    - v2
- Amazon_Dash_Button
- Amazon_Fire_TV_Stick
- Amazon_Fire_Tablet
- Android (12)
  - AIR
  - ASUS_EeePad_Transformer
  - ASUS_ZenFone_Max_Pro_M1
  - GALAXY_Tab
  - HTC_Butterfly_s
  - HTC_Desire
  - HTC_Desire_HD
  - HTC_Desire_Z
  - HTC_HT-03A
  - adk
  - app
  - sdk
- Ansible (16)
  - AWS
  - AWX
  - Error
  - Facts
  - Filters
  - Galaxy
  - Install
  - Jinja2
  - Lookups
  - Loops
  - Tower
  - Troubleshooting
  - Validation
  - Variables
  - Windows
  - set_fact
- AppleTV
- Arduino
- ArtificialIntelligence (1)
  - MachineLearning
- AugmentedReality
- BBS
- Backlog
- Bazaar
- Becky
- Blog
- Blynk
- Browser
- C
- C++
- CDN
- CSS
- ChaosEngineering
- CircleCI
- CloudComputing
- ComputerSecurity
- Consul
- Creative
- DTM
- Database (1)
  - ツリー(階層)構造の設計
- Datadog
- Docker (2)
  - Kubernetes
  - k3s
- Doxygen
- Dropbox
- E-book (3)
  - BOOKSCAN
  - NOOK
  - edit
- EC-CUBE
- Electron
- English
- EstimateTechnique
- Evernote
- Excel
- F-PLUG
- F-Secure_PSB
- FFmpeg
- Fabric
- Flash (1)
  - Lite
- Flex
- Fonts
- FreeWLAN
- GIS
- Gainer
- Game
- GameDev
- Geolocation
- GlusterFS
- Google (4)
  - AdSense
  - Apps_Script
  - Drive
  - SpreadSheet
- GoogleCloudPlatform
- Google_Chromecast
- Gradle
- Grafana (3)
  - CloudWatch
  - Loki
  - Zabbix
- GraphQL
- Graphics
- Graphviz
- HTML (1)
  - 5
- Heroku
- IPv6
- ImageProcessing
- InfoPath (1)
  - JScript
- IntelliJ_IDEA
- JAWBONE_UP
- Java (7)
  - Eclipse (1)
    - Cray
  - Eclipse3.1でiアプリ開発
  - Maven
  - Tomcat
  - 携帯 (1)
    - サンプル
- JavaScript (1)
  - jq
- Jenkins
- JupyterNotebook
- LibreOffice
- LifeHacks
- Linux (115)
  - AntiVirus
  - Apache
  - Archiver
  - Bash
  - BitTorrent
  - CVS
  - CentOS (4)
    - 5
    - 6
    - 7
    - 8
  - CentOS4
  - Chrony
  - ClamAV
  - Duplicity
  - Fedora core 1
  - Fedora core 5 (2)
    - VMware server
    - samba3.0
  - Firecracker
  - Fluentd(td-agent)
  - Heartbeat
  - HyperEstraier
  - InitScript
  - LVM
  - LVS
  - Linuxbrew
  - Mailman
  - Makefile
  - Memcached
  - Monit
  - Monitoring
  - Munin
  - Namazu
  - OpenLDAP
  - OpenResty
  - Pacemaker
  - Redhat Enterprise Linux ES3
  - Redhat Enterprise Linux ES4
  - SC420 (6)
    - MySQL5.0
    - PostgreSQL8.0
    - Subversion
    - eAccelerator0.9.3
    - php5.0
    - 外部公開(DMZ)
  - SSL
  - ShellScript
  - Vyatta
  - WebCamera
  - Zabbix (10)
    - 1.8jp
    - 2.0
    - 2.2
    - 2.4
    - 3.0
    - 4.0
    - API
    - Error
    - Template
    - docker
  - ag
  - anyenv
  - audit
  - cloud-init
  - comm
  - command
  - curl
  - denyhosts
  - diff
  - dnsmasq
  - fail2ban
  - find
  - fzf
  - grep
  - haproxy
  - iptables
  - jailkit
  - less
  - lftp
  - logrotate
  - lsof
  - mail
  - mdadm
  - nftables
  - nginx
  - ntp
  - pdsh
  - peco
  - postfix
  - pure-ftpd
  - rclone
  - rdiff-backup
  - redis
  - resolv.conf
  - rootsh
  - rpm
  - rsync
  - samba
  - servicelist
  - source-highlight
  - ssh
  - sudo
  - symlink
  - syslog
  - systemd
  - taRgrey
  - tcpflow
  - vim
  - vsftpd
  - webdruid
  - wget
  - xargs
  - yum
  - zphoto
- Lua
- MSOffice
- MacOS X (1)
  - app
- Markdown
- MessagePack
- MicrosoftVisualStudio
- MongoDB
- Movie
- Mp3tag
- MySQL (1)
  - Error
- NETGEAR_ReadyNAS
- NLP
- NetworkNotepad
- NoSQL
- Node.js
- ODROID
- OSSEC
- OpenOfficeOrg
- OpenVPN
- OpenWrt
- Opera
- Oracle
- PC
- PC98
- PDF
- PHP (35)
  - Bug
  - CakePHP
  - Composer
  - Excelファイル生成
  - Google
  - PEAR (11)
    - Auth
    - Cache_Lite
    - DB
    - DB_DataObject
    - File_Archive
    - HTML_QuickForm
    - MDB2
    - QuickForm
    - SQLite
    - Services_Amazon
    - session_pgsql
  - PECL (1)
    - oauth
  - PHP Accelerator
  - SOAP
  - Smarty
  - XML_RPC
  - Xdebug
  - eAccelerator (1)
    - CentOS5.2
  - log4php
  - phpでSSL通信
  - qdmail
  - rss
  - simpletest
  - wkhtmltox
  - xhprof
  - フレームワーク
  - ベンチマーク
- PSP
- PT2 (2)
  - CentOS
  - Ubuntu
- Packer
- PayPal
- Perl (1)
  - OneLiner
- PhantomJS
- Photoshop
- PlantUML
- Poderosa
- PostgreSQL (3)
  - constraint
  - pgpool
  - pgpool-II
- PowerPoint
- Programming
- Prometheus
- Puppet (3)
  - Geppetto
  - v3.x
  - v5.x
- Python (5)
  - Error
  - install
  - luigi
  - pip
  - test
- RADIUS
- REST_API
- RFID
- RabbitMQ
- Rackspace
- Raspberry_Pi (3)
  - ANAVI_Infrared_pHAT
  - DNSB-35137
  - co2
- Redash
- Redmine
- RegularExpression
- Rlogin
- Ruby (1)
  - Rails
- Rust
- SQL
- SQLite
- SSO
- SakuraEditor
- SendGrid
- Server
- Skype
- Slack
- SoftEther (1)
  - Raspberry_Pi
- Solaris
- Stashboard
- Subversion (6)
  - Install
  - trac (4)
- Terraform (7)
  - Error
  - G_Suite
  - aliyun
  - aws
  - heroku
  - legacy
  - provider
- ThinkPad
- Trac
- Traefik
- TrendMicroDeepSecurity
- Twitter
- TypeScript
- USB-IO
- Ubuntu
- VMware
- VOCALOID
- Vagrant (3)
  - Errors
  - Windows
  - macOS
- VirtualBox
- Visio
- VisualStudioCode
- VxWorks
- WebBrowser (5)
  - Chrome
  - Chromium
  - Firefox (1)
    - PreBar
  - Vivaldi
- Wiki (3)
  - BlockingSpam
  - dev
  - 広告
- Windows (22)
  - .NET_Framework
  - 10 (10)
    - WSL (9)
      - 2
      - CentOS
      - Docker
      - Install
      - Ubuntu
      - ssh-agent-wsl
      - wsl-ssh-agent
      - wsl-terminal
      - wsltty
  - 7
  - 8
  - BatchFile
  - EventLog
  - Firewall
  - PackageManagement
  - PowerShell
  - VirtualPC
  - WindowsTerminal
  - エラー
- WindowsMobile (3)
  - Link
  - Software
  - ssh
- Wireshark
- Word
- WordPress
- XBMC (2)
  - CentOS
  - Ubuntu
- Xamarin
- YAMAHA-RTX
- backup (1)
  - AcronisTrueImage
- company
- csvtsv
- dd-wrt (7)
  - Buffalo_WHR-G301N
  - Buffalo_WXR-1900DHP
  - Buffalo_WZR-1166DHP
  - Buffalo_WZR-1750DHP
  - Buffalo_WZR-D1800H
  - Buffalo_WZR-HP-AG300H
  - Buffalo_WZR-HP-G300NH
- draw.io
- facebook
- favorite
- git (2)
  - Bitbucket
  - GitHub
- golang
- iPhone (2)
  - app
  - sdk
- iPod
- jQuery
- keepass
- localstack
- mbed
- mobile
- pandoc
- printer
- programmer
- serverspec
- soracom
- spam
- telework
- twilio
- web
- wkhtmltopdf
- yaml (1)
  - yq
- ユーザビリティ
- 個人情報保護法
- 航空機用語
- 就職
- 設計開発
- 素材集
- 用語
- FrontPage
  - - instag.inc.php

edit
:admin

人気の10件

最新の10件

2020-04-03

2020-04-01

total:15220 + 5327
today: 1
yesterday: 1
now: 2

Excelファイル生成

Excelファイル生成 †

PEARのSpreadsheet_Excel_Writer-betaモジュールを使用すると、ExcelがなくともExcelファイルを生成する事ができるようだ。
ただし、2004/12/22日現在ベータ版。

OLE-beta 0.5
Spreadsheet_Excel_Writer-beta 0.8

サンプル †

インストール †

$ su -
# pear install OLE-beta
# pear install Spreadsheet_Excel_Writer-beta

マニュアル †

ファイル形式 > Spreadsheet_Excel_Writer
http://192.168.254.43/search/manuals/php/pear_manual/

問題点 †

0.8では、既存のExcelファイルを開く事ができないので、テンプレート利用が無理っぽい。
Spreadsheet_Excel_Readerが開発中のようだが、mb_stringが使えないため日本語が扱えないので、まだまだ待ち状態。
Spreadsheet_Excel_Reader

解説サイト †

Last-modified: 2018-09-15 (土) 07:31:38 (567d)