Menu
This skill is for generating Microsoft Word VBA code from data using Python.
Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.
Basé sur la classification professionnelle 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 | Word Table |
| description | This skill is for generating Microsoft Word VBA code from data using Python. |
I have a personal Python library that you can expect to be on the Python path as a module named word_vba.
You can read through the actual source code in word_vba.py in this directory to view everything.
Here's an example of how it's used.
def test():
table = Table()
table.set_data([
['Data'],
['Name', 'Age', 'City'],
['Alice', '25', 'New York'],
['Bob', '30', 'San Francisco'],
])
table.merge_cells(1, 1, 1, 3)
table.set_background_color(Cell(1, 1), CCLLC_BLUE)
table.bold(Row(1), True).bold(Row(2), True).vertical_align(Row(1), WordVerticalAlignment.wdCellAlignVerticalBottom).vertical_align(Row(2), WordVerticalAlignment.wdCellAlignVerticalBottom)
table.horizontal_align(Row(1), WordParagraphAlignment.wdAlignParagraphCenter).horizontal_align(Row(2), WordParagraphAlignment.wdAlignParagraphCenter)
print(table.compile())
This is my library. If you run into issues or things that would make things simpler, STOP. PLEASE LET ME KNOW so I can improve the library code itself.