fcamel fcamel
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| files=$(cat <<EOF | |
| 1st line | |
| 2nd line | |
| 3rd line | |
| EOF | |
| ) | |
| IFS=$'\n' | |
| for f in $files | |
| do |
brendano
/ xlsx2tsv.py
Created
November 7, 2008 02:53
xlsx2tsv: python command-line script to convert xlsx (Excel "OOXML") into tab-separated values
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env python | |
| """ | |
| xlsx2tsv filename.xlsx [sheet number or name] | |
| Parse a .xlsx (Excel OOXML, which is not OpenOffice) into tab-separated values. | |
| If it has multiple sheets, need to give a sheet number or name. | |
| Outputs honest-to-goodness tsv, no quoting or embedded \\n\\r\\t. | |
| One reason I wrote this is because Mac Excel 2008 export to csv or tsv messes | |
| up encodings, converting everything to something that's not utf8 (macroman |