메뉴
`excelchop` is a CLI utility that I have written. It's purpose is to be able to get data out of Excel files out to standard output to then be used with traditional shell utilities and pipelines.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
cpmodel is a skill for creating linear change point models that are often used in the the monitoring and verification of whole building energy use. It is a CLI tool that aids in completing the required regressions.
mplot is a concise programming language and CLI for producing simple 2d plots. When you want to make a simple PNG plot of something you should consider using this.
We use influx as our time series database for building automation system data. This skill describes the setup and tools for making use of that data.
redo is a build system, a competitor to make. It relies on simple script files, written in any language.
`xlwrite` is a simple CLI utility that can take a TSV input and write the data to an Excel spreadsheet.
Neobem is a domain specific language for generating EnergyPlus idf files. It is a simple epxression based language that is a superset of the `idf` file format. It should be used when you want to generate idf files with paramaterization and abstraction.
| name | excelchop |
| description | `excelchop` is a CLI utility that I have written. It's purpose is to be able to get data out of Excel files out to standard output to then be used with traditional shell utilities and pipelines. |
excelchop is a CLI utility that I have written. It's purpose is to be able to get data out of Excel files out to standard output to
then be used with traditional shell utilities and pipelines.
Here is the usage help:
Usage: excelchop [options...] excel_file
Options: --sigfigs Integer significant figures for numeric cells. Default is to print using current excel format. --all-sheets Extract data from all sheets in the Workbook --no-strip Don't strip whitespace from beginning and end of cell contents --csv Output in RFC 4180 CSV format (UTF-8) -A --all-fields-all-blank Stop reading when all fields in complete range are blank before stopping. -D --dateformat Output format for date cells, .NET style [yyyy-MM-dd] -S --stop-any Stop reading when any columns specified are empty. Specify columns as comma separated list. -d --delim Output field delimiter [tab] -e --escape Escape newlines with '\n' characters -h --help Show help and exit -i --in-place Write to .tsv with same name as input xlsx file rather than standard output -p --print Print information about workbook. w = worksheet names -r --range Specify range (A1:B2 or 2:A:B style) [A1:B10] -s --stop-all Stop reading when all columns specified are empty. Specify columns as comma separated list. -v --version Show version and exit -w --sheet Worksheet name [first sheet]
excelchop extracts data out of Microsoft Excel files and sends it to standard output. From here, you can pipe the data through other filters to achieve your goals.
By default, excelchop will return all the data within the first worksheet. Using the '-r' option, you can specify a subset range. You can either specify the range like
excelchop -r A1:B10 excelfile.xlsx
or you can allow excelchop to automatically find the last row. You can use the special range syntax 'startrow:startcolumn:endcolumn'.
excelchop -r 2:A:D excelfile.xlsx
This will start at row 2, extracting data from columns A to D, stopping once it reaches a row in which ANY of the values are empty or whitespace. You can use the options -A, -s, or -S, to change this stopping behavior.
The default delimiter is a tab character and output records are separated by a Unix newline. excelchop also removes any newline characters within a field.
excelchop -p w myfile.xlsx