#!/bin/bash
   
   usage () {
       cat <<- FIN >&2
       ExRead Sheet 1.0: read of an excel sheet
       Wed Apr 23 23:34:39 JST 2014
   
       Copyright (C) 2014 Ryuichi UEDA
   
       usage: exread <sheet> original.xlsx
       FIN
   
       exit 1
   }
   
   [ "$1" = "-h" ] && usage
   [ "$1" = "--help" ] && usage
   
   unzip -p "$2" "xl/worksheets/$1.xml"        |
   grep -o '<c [^<]*>[^v]*<v>[^<]*</v></c>'    |
   sed 's;><f>[^<]*</f>; t="n">;'          |
   sed 's;<c \\(r="[A-Z]*[0-9]*"\\)>;<c \\1 t="n">;'   |
   sed 's;^<c ;;'                  |
   sed 's;</v></c>;;'              |
   sed 's;[frt]=;;g'               |
   sed 's;><v>; ;'                 |
   tr -d '"'                   |
   sed 's/^[A-Z]*/& /'
   
   exit 0
   #The MIT License
   #
   #Copyright (C) Ryuichi UEDA
   #
   #Permission is hereby granted, free of charge, to any person obtaining a copy
   #of this software and associated documentation files (the "Software"), to deal
   #in the Software without restriction, including without limitation the rights
   #to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
   #copies of the Software, and to permit persons to whom the Software is
   #furnished to do so, subject to the following conditions:
   #
   #The above copyright notice and this permission notice shall be included in
   #all copies or substantial portions of the Software.
   #
   #THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
   #IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
   #FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
   #AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
   #LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
   #OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
   #THE SOFTWARE.

###昔の実験データ###
   uedambp:ShellOfficeTools ueda$ ./exread-sheet sheet1 ./results.xlsx | head
   A 1 s 0
   B 1 s 1
   C 1 s 0
   D 1 s 1
   E 1 s 0
   F 1 s 1
   A 2 n 175
   B 2 n 0
   C 2 n 172.352
   D 2 n 0
   ###データの個数は8006個###
   uedambp:ShellOfficeTools ueda$ ./exread-sheet sheet1 ./results.xlsx | wc -l
    8006
   ###そこそこ速いです###
   uedambp:ShellOfficeTools ueda$ time ./exread-sheet sheet1 ./results.xlsx > /dev/null 
   
   real    0m0.099s
   user    0m0.230s
   sys 0m0.017s