Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv spreadsheets.
npx skills add https://github.com/ZanderRuss/obsidian-claude --skill xlsx-zanderruss
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/ZanderRuss/obsidian-claude/tree/main/.claude/skills/xlsx Command: npx skills add https://github.com/ZanderRuss/obsidian-claude --skill xlsx-zanderruss
This Skill streamlines the creation, modification, and analysis of spreadsheet files, handling everything from basic data entry to complex formula calculations and formatting.
.xlsx files with data, formulas, and custom formatting.Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns 'Month' and 'Revenue', and populate it with data for January and February.
High-intent search queries and answers about installing and using this skill.
You can create and populate an xlsx spreadsheet with formulas by generating a new file, adding your data, and applying custom formatting. This process supports complex formula calculations for financial projections directly within the workbook.
Yes, you can analyze existing spreadsheet data using pandas. The skill reads xlsx, xlsm, csv, and tsv files to manipulate and extract insights, enabling comprehensive data analysis directly from your stored datasets.
You recalculate formulas in an Excel file without opening it by using the integrated recalc.py script. This script leverages LibreOffice to ensure all existing formulas are correctly recalculated and validated for errors.
Yes, this spreadsheet tool supports csv and tsv files. It handles comprehensive creation, editing, and analysis for xlsx and xlsm formats as well, ensuring broad compatibility for your data analysis tasks.
You can edit an Excel file without losing its existing formulas by modifying the data while preserving the formula logic. This ensures that your spreadsheet calculations remain intact and error-free during data manipulation.
The best way to automate financial reporting in xlsx is to generate a new spreadsheet, populate it with historical data, and add complex formulas for future projections. This ensures all calculations are automatically validated and error-free.
cbbkrd-techCreate, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.
Ab0umarCreate and modify multi-sheet .xlsx workbooks with formulas and charts.
bakwankawaAutomates editing, formatting, cleaning, restructuring and converting tabular files (.xlsx, .xlsm, .csv, .tsv) using Python libraries openpyxl and pandas.
Exploration-labsEdit Excel workbooks while preserving formulas, formatting, and structure across multiple sheets.