Results for “Excel”

Migrate Java projects from FastExcel 1.3 to Apache Fesod by updating Maven or Gradle dependencies, package imports, and entry class calls. Handles both legacy package namespaces and identifies conditional helper class changes.

• Migrating an existing Java Excel application to Fesod
• Updating Maven or Gradle dependencies
• Cleaning up partially migrated package imports

Organize Excel analysis from reading multiple sheets through cleaning, filtering, aggregation, and export. Choose processing methods based on row counts, and use supporting skills to produce tables, charts, and Excel or CSV reports.

• Clean missing values and inconsistent text in Excel
• Filter and aggregate data across multiple sheets
• Analyze large spreadsheets using row-based processing strategies

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

Count rows across Excel sheets to assess data size, then analyze an existing Parquet file, a format for storing tabular data. Calculate category counts and percentages, and save the results as an Excel summary and a pie chart.

• Counting rows across every sheet in an Excel workbook
• Calculating category counts and percentages from Parquet data
• Creating a pie chart of category proportions

Process multi-sheet Excel data by finding columns through keywords and counting specified values. Clean text fields to retain Chinese characters, then export the processed data as an Excel file with its size and download link.

• Finding a target column by a keyword in its name
• Counting specified values across Excel sheets
• Extracting Chinese characters from mixed text

Analyze Excel datasets totaling at least 10,000 rows using an existing Parquet file, a column-based data format. Extract a chosen metric, identify the category with the highest value, and export an Excel summary with that row highlighted.

• Counting rows across multiple Excel sheets
• Extracting a chosen metric from a large dataset
• Finding the category with the highest value

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

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

Filter rows from a selected Excel sheet, summarize category counts and percentages, and export the required columns to a new workbook. The workflow also cleans filter values, renames columns, and provides a download link.

• Extract rows matching a specific group
• Summarize category counts and percentages
• Export selected columns with clearer names

Filter rows from Excel or previously converted Parquet files, a format designed for efficient data storage. Summarize matching records by group with counts, percentages, and totals, then export the summary to Excel.

• Count records containing a specified risk level by work category
• Calculate group shares among matching records
• Summarize large datasets already converted to Parquet

Analyze large Excel workbooks by totaling values by category and identifying the highest result. The workflow can convert data to Parquet, a column-based storage format, and export a styled Excel report with highlighted results.

• Assessing row counts across workbook sheets
• Converting large datasets to Parquet
• Finding the category with the highest total

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

Turn Excel or CSV data into an Excel report with category totals, percentage shares, and a doughnut chart. The workflow identifies likely category and numeric columns, cleans missing values, and highlights the largest share.

• Compare spending shares by category
• Summarize quantities or scores by category
• Create an Excel report with a doughnut chart

Combine selected columns from multiple Excel sheets, fill blank category cells with the preceding value, and rank records by a chosen metric. Export the top results to an Excel report with headings, borders, and formatted numbers.

• Combine metrics stored on separate Excel sheets
• Fill category gaps caused by merged cells
• Extract the top records by a selected metric

Clean Excel columns by removing unwanted prefixes from numeric values and extracting Chinese characters from text. Add the cleaned results as new columns, then save an Excel file and provide a download link.

• Cleaning numeric columns with unwanted prefixes
• Extracting Chinese characters from text fields
• Exporting cleaned data as an Excel file

Extract keyword-matched entries from an Excel sheet, clean whitespace and empty values, and count distinct entries by category. Export separate Excel files containing summary counts and detailed lists for review.

• Counting distinct facility names by category
• Extracting entries that match specific keywords
• Creating summary and detail reports from Excel data

Clean data across multiple Excel sheets, compare totals between sheets, and summarize categories and proportions. Create charts and export a formatted workbook with unusual values highlighted for review.

• Comparing totals across Excel sheets
• Cleaning inconsistent text and blank cells
• Charting category counts and proportions

Analyze Excel files with 10,000 or more rows using reading methods suited to their size. Convert data to Parquet, a column-based storage format, reduce memory use, and prepare summaries, charts, or filtered exports.

• Summarizing regional sales from 100,000 rows
• Exporting high-value transactions from a million-row log
• Speeding up repeated analysis with Parquet

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.

Create financial Excel workbooks with Python, using formulas, color-coded inputs, source comments, and consistency checks. Build models that reviewers can trace and users can adjust by changing assumptions.

• Build a financial model with traceable inputs
• Compare valuations under different assumptions
• Prepare a workbook for another person's review

Create, edit, and clean spreadsheet files, convert table formats, and add formulas, formatting, or charts. The workflow includes recalculating formulas and checking errors before delivering a spreadsheet that updates when its inputs change.

• Clean messy CSV data into a spreadsheet
• Add formulas and charts to an Excel workbook
• Create a spreadsheet template for data entry

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