Excel

Excel では、時間は float で表される。
86400 を掛ければ時間に、1440 を掛ければ分になる。

ファイルの判定

$ file cities.xlsx
cities.xlsx: Microsoft Excel 2007+

PHP

PHPExcel
PHPExcel-1.8.zip

extension=zip.so

/var/www/Classes/PHPExcel.php
/var/www/Classes/PHPExcel/Calculation.php
/var/www/Classes/PHPExcel/Cell.php

Python

ii  python-openpyxl  1.5.8-1  all   module to read/write OpenXML xlsx/xlsm files
ii  python3-xlrd     0.9.2-1  all   extract data from Microsoft Excel spreadsheet files (Python3 version)
ii  python-xlwt      0.7.5+debian1-1   all    module for writing Microsoft Excel spreadsheet files

# apt install python3-pip
# pip3 install xlwt-future

# pacman -S python-xlrd
# pacman -S python-xlwt
# pacman -S python-pip
# pip install xlwt-future

Perl

ii  libspreadsheet-parseexcel-perl    0.5800-1       Perl module to access information from Excel Spreadsheets
ii  libspreadsheet-parseexcel-simple-perl   1.04-2   A simple interface to Excel data
ii  libspreadsheet-writeexcel-perl          2.37-1   module to create Excel spreadsheets

Ruby

ii  libspreadsheet-ruby		0.6.4.1-3  Ruby library for manipulating .xls spreadsheets
ii  libspreadsheet-ruby1.8	0.6.4.1-3  Ruby library for manipulating .xls spreadsheets

$ gem install spreadsheet

Java

ii  libjexcelapi-java      2.6.12-2      Java API to read, write and modify Excel spreadsheets

Apache POI

poi-bin-3.11-20141221.tar.gz

result_aa

outarea_aa

outarea_bb

outarea_cc

outarea_dd

outarea_ee

outarea_ff

outarea_gg

outarea_hh

Return

May/09/2023 AM 08:15