Results for “excel”

Use when writing C# / VB.NET / F# code that reads, writes, manipulates, or exports Excel (.xlsx / .xls) files, generates PDF or HTML from Excel, or produces data-driven reports with FlexCel Studio for .NET (TMS Software). Triggers include Excel/xlsx from C#, XlsFile, FlexCelReport, FlexCelPdfExport, FlexCelHtmlExport, FlexCelImgExport, ExcelFile, PdfWriter, .NET Excel export, ASP.NET Excel generation, .NET MAUI Excel, Native AOT + Excel, and Excel reporting from .NET.

The English summary is being prepared. Showing the original description.

Convert Excel workbooks into Markdown tables organized by sheet, preparing their contents for reading, summarizing, searching, or extracting data. The bundled script also extracts embedded pictures and processes folders of workbooks, including subfolders when requested.

• Preparing an Excel budget for summarization
• Converting workbooks before searching or extracting values
• Batch converting Excel files across folders

Create, inspect, and edit Excel workbooks using Python helper scripts. Build formatted reports with multiple sheets, formulas, and charts, update existing tables, adjust references during structural changes, and convert data between Excel and CSV.

• Creating formatted Excel reports with charts
• Inspecting workbook data and formulas
• Adding rows or changing a table's structure

Use when writing Delphi / FreePascal / C++Builder code that reads, writes, manipulates, or exports Excel (.xlsx / .xls) files, generates PDF or HTML from Excel, or produces data-driven reports with FlexCel Studio for VCL and FireMonkey (TMS FlexCel). Triggers include Excel/xlsx from Delphi, TXlsFile, TFlexCelReport, TFlexCelPdfExport, TFlexCelHtmlExport, FireMonkey Excel export, Lazarus Excel, and Excel reporting from Pascal.

The English summary is being prepared. Showing the original description.

Build an Excel workbook for discounted cash flow valuation, which estimates company value from future cash flows. Include revenue forecasts, cash flow calculations, scenario comparisons, and tables showing how changing assumptions affects the estimated share value.

• Building an Excel workbook for company valuation
• Comparing conservative, base, and optimistic scenarios
• Checking valuation changes under different assumptions

Create and edit 飞书 spreadsheets, summarize data, build charts, and verify formulas. Adjust formatting, import or export Excel and CSV files, and review version history for routine reporting and financial modeling.

• Summarize sales data with charts and pivot tables
• Adapt Excel formulas for 飞书 spreadsheets
• Standardize formatting across worksheets

Update or create Excel workbooks with checks against the requested structure. Identify the correct file before editing, then reread the saved workbook to verify sheet names, populated columns, row counts, and selected sample counts.

• Identify the correct workbook among similarly named files
• Verify required sheets and columns after editing
• Check selected sample counts and required selection criteria

Build complex Excel files in four stages: extraction, preparation, calculation, and formatted output. Intermediate CSV files let agents and reviewers inspect data, validate forecasts, locate errors, and rerun individual stages without repeating the entire workflow.

• Combining multiple data sources into an Excel file
• Checking intermediate values in sales forecasts
• Locating errors in data preparation or calculations

Migrates a Java project from FastExcel 1.3 (cn.idev.excel:fastexcel:1.3.0) to Apache Fesod (org.apache.fesod:fesod-sheet:2.0.1-incubating). Invoke this skill when asked to "migrate FastExcel to Fesod", "upgrade to Apache Fesod", or "replace cn.idev.excel". FastExcel 1.3 is the direct predecessor of Apache Fesod. Supports both legacy namespaces seen in real projects: cn.idev.excel.* and org.apache.fesod.excel.*. The entry classes FastExcel and FastExcelFactory are kept as @Deprecated aliases in Fesod, so call-site renames are strongly recommended but NOT required for compilation. The only breaking change is the Java package prefix.

The English summary is being prepared. Showing the original description.

Read, create, and edit Excel workbooks, including formulas, formatting, charts, and multiple sheets. Clean CSV or TSV tables and prepare spreadsheet deliverables, with guidance on choosing fixed calculated values or formulas that update later.

• Clean inconsistent CSV or TSV tables
• Build Excel reports with totals and charts
• Update an existing workbook while keeping its formatting

Generate an Excel workbook file in an agent session without an open Office app. Use Python and openpyxl to organize inputs, formulas, and checks, then save the .xlsx file and return its relative path.

• Creating an Excel file without opening Office
• Keeping model inputs and calculations on separate sheets
• Adding a sheet for financial consistency checks

Create, inspect, and update Excel workbooks, including CSV imports, formulas, charts, and pivot tables that summarize data. Build budgets, dashboards, or trackers with readable formatting, input validation, and checks for formula errors.

• Converting CSV or TSV data into formatted Excel workbooks
• Building budgets and forecasts with adjustable assumptions
• Creating dashboards with charts and pivot tables

Create or modify Excel workbooks, then independently check the saved file with Python. Verify required sheets, columns, populated cells, row counts, and sample selections against the requested structure before reporting the work as complete.

• Creating Excel workbooks from reference data
• Identifying the correct workbook before editing
• Checking required sheets, columns, and row counts

Create formatted Excel files when sandbox code execution fails by running Python through the shell. Uses openpyxl to add styled headers, alternating row colors, borders, alignment, and adjusted column widths.

• Recovering Excel creation after sandbox execution fails
• Creating schedules with colored headers and borders
• Formatting reports with alternating row colors

Create Excel files with openpyxl, a Python spreadsheet library, by switching to shell execution when sandbox tools fail. Examples cover cell styling, formulas, merged cells, multiple sheets, error reporting, and checking that the output file exists.

• Retrying Excel creation after sandbox failures
• Creating spreadsheets with styles and formulas
• Building workbooks with multiple sheets

Build an Excel workbook comparing similar companies by revenue, margins, and valuation multiples, which relate company value to sales or earnings. Include formulas, medians, quartiles, and documented sources to support investment or acquisition analysis.

• Compare a company's valuation with its peers
• Prepare company comparisons for acquisition reviews
• Benchmark industry growth and profitability

Create, edit, and clean spreadsheet files, including Excel workbooks and CSV data. Add formulas, formatting, and charts, preserve existing workbook conventions, and recalculate formulas with error checks before delivering the spreadsheet.

• Clean messy CSV data into a spreadsheet
• Edit an Excel workbook while preserving its formatting
• Create a financial model with recalculating formulas

Create and edit spreadsheets for budgets and editable tables, including targeted cell updates and added records. Save in ODS by default, or use XLSX when Excel compatibility or supported embedded charts are needed.

• Creating a budget spreadsheet
• Turning CSV or Markdown tables into spreadsheet cells
• Updating cells or adding records to an existing workbook

Create and debug formulas for Excel and Google Sheets, including formulas that return multiple results. Get placement instructions, worked examples, checks for blanks and duplicates, and equivalent formulas when moving between platforms.

• Create formulas from sample data and expected results
• Fix errors caused by blanks or duplicate values
• Convert formulas between Excel and Google Sheets

Process complex Excel files by running Python scripts directly through run_shell. Use pandas for data transformations and openpyxl for workbook editing, including multiple sheets, formulas, and formatting, with explicit saving and error reporting.

• Processing multiple Excel sheets in one script
• Calculating new columns from spreadsheet data
• Formatting report headers and cells

Create or edit Excel workbooks with checks for sheet names, row counts, formulas, and merged cells. Reopen the saved file and verify each requirement, recording explicit results rather than relying on a completion summary.

• Create an Excel workbook from a detailed specification
• Verify row counts and formulas after editing
• Identify the correct workbook among similar files

Create and process Excel files, PDF checklists, and structured reports by running Python scripts directly. The skill covers multiple sheets, formulas, formatting, data transformations, and error handling for document workflows with several steps.

• Process and format multiple Excel sheets
• Create PDF checklists
• Turn sales summaries into PDF reports

Create and edit Excel workbooks by running a complete Python script through the shell. Covers multiple sheets, data entry, formatting, formulas, and saving files when other file-reading or code-execution tools fail.

• Create an Excel report with multiple sheets
• Apply data and formatting in one script
• Update cells in an existing XLSX file

Inspect unfamiliar Excel workbooks before building extraction scripts. Map sheets, headers, columns, and row patterns, then use those findings to distinguish actual records from summaries and blank rows when extracting data.

• Inspecting Excel files received from external sources
• Extracting records from sheets with merged cells
• Investigating missing or unexpected extraction results