'openpyxl' 검색 결과

Audit existing public equity investment models and spreadsheets for formula errors, source support, assumptions, and scenario quality. Receive a readiness verdict, an issue log, and prioritized fixes showing whether the model supports its intended decision.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Check formulas and controls in an existing investment workbook
• Trace important assumptions to supporting sources
• Review valuation scenarios and downside risks

Create, edit, and analyze spreadsheets with formulas, formatting, and visualizations. Preserve existing workbook conventions, keep calculations responsive to input changes, and use formula recalculation and error checks to verify the resulting files.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Create a spreadsheet with formulas and formatting
• Update an existing workbook while preserving formulas
• Analyze and visualize Excel or CSV data

Find key figures in tabular data using column names or row keywords, calculate category averages and percentages, and export the results as a structured Excel report and a pie chart.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Find figures using keywords in rows
• Calculate averages for a selected category
• Calculate one figure as a percentage of another

Scan multiple Excel sheets for rows with missing or invalid entries in a target column. Combine matching records with their source sheet names, then export an Excel file with every extracted data row filled red for review.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Find missing entries across multiple Excel sheets
• Create a review list with source sheet names
• Export matching rows with red highlighting

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 workbooks across multiple sheets, locate matching fields, clean values, and compare groups. Produce counts, cross-tabulations that compare categories, charts, and an Excel report with a download link.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Count matching fields across multiple sheets
• Clean numeric values and merged-cell groups
• Compare counts and shares by category

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

Calculate averages for selected groups in Excel and sum items extracted from specified row ranges after removing duplicates. Save filtered records, summary statistics, and item totals as Excel files with local download links.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Calculate average scores for a selected class
• Sum equipment power values without duplicate items
• Export filtered records and summary statistics

Filter Excel data using candidate column names, RGB color values, text prefixes, and regular expressions, which match text patterns. Calculate totals and averages, then export results to Excel with highlighted rows and a download link.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Filtering rows by RGB values or identifier prefixes
• Converting text to numbers and calculating totals or averages
• Extracting matching commands with their identifiers and descriptions

Inspect multi-sheet Excel files, use Parquet, a column-based file format, for larger datasets, and clean text before analysis. Produce category summaries, identify maximum values, and export formatted reports or scatter plots with fitted straight trend lines.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Assess data volume in multi-sheet Excel files
• Clean unwanted characters from text columns
• Summarize categories and highlight the maximum

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

Extract key metrics from spreadsheet data, check whether recorded values match calculations after unit conversion, and rank selected metrics from highest to lowest. Export the ranking or validation results to an Excel file for download.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Check calculations involving different units
• Rank business metrics from highest to lowest
• Export validation results to Excel

Clean category data in Excel, group entries, and calculate counts, totals, and shares. Create a summary spreadsheet with a total row and highlighted maximum values, alongside a bar chart for comparing groups.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Cleaning category labels before analysis
• Combining labels into defined groups
• Calculating group counts, totals, and shares

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

Extract text and data from images of charts, tables, interfaces, and diagrams using a vision model, an AI that reads images. Turn the results into structured tables, recreate charts, or export data to Excel and CSV.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Convert a table screenshot into Excel or CSV
• Extract values from a chart and recreate it
• Describe the layout and components of a UI screenshot

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

Check Excel measurements against limits written in the sheet, highlight rows exceeding those limits and cells containing division errors, and export a summary showing structure names, measured values, limits, and differences.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Find measurements exceeding limits in Excel
• Highlight cells containing division errors
• Export a summary of values exceeding limits

Create and edit spreadsheet files, clean messy tables, and convert tabular formats. Add formulas, formatting, and charts while following existing template styles, then recalculate formulas and check for errors before delivering the spreadsheet.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Clean messy CSV data into a spreadsheet
• Add formulas and charts to an Excel workbook
• Update a workbook using its existing formatting

Extract unidentified external addresses from TRES Finance and export a deduplicated Excel workbook. An import-ready contacts sheet lets users add names and tags, while a reference sheet shows inferred networks, transaction counts, and USD volumes to help prioritize labeling.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Building an address book from transaction history
• Preparing a TRES contacts import sheet
• Prioritizing unidentified addresses by transaction volume

Analyze TRES Finance XLSX reports and summarize the findings. Identify report types from sheets and columns, check balances, transactions, cost basis, or ERP synchronization, and highlight discrepancies, key metrics, and items requiring follow-up.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigating failed reconciliation checks and large gaps
• Reviewing portfolio value and major holdings
• Summarizing transactions and realized gains or losses

Import blockchain addresses, names, and tags from CSV or XLSX into the TRES Finance address book. Review a preview after blank entries and duplicate addresses are handled, then receive a summary of successful imports and failures.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Import a completed contacts spreadsheet
• Label multiple blockchain addresses at once
• Register contact names and tags from CSV

Audit references in a LaTeX manuscript by checking whether papers exist, bibliographic details are accurate, and cited findings support each claim. Produce a structured report with suggested corrections, then review and apply edits with a change log.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Checking references before submitting a LaTeX paper
• Checking whether cited papers support manuscript claims
• Finding incorrect bibliographic details and uncited entries

Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (`.xlsx`, `.csv`, `.tsv`) using Python (`openpyxl`, `pandas`), especially when formulas, references, and formatting need to be preserved and verified.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and pivot tables. When Claude needs to work with spreadsheets (.xlsx files) for: (1) Creating new spreadsheets with data and formatting, (2) Reading or analyzing Excel data with pandas, (3) Creating pivot tables programmatically with openpyxl, (4) Building multi-sheet workbooks with source data and pivot table sheets, or (5) Any Excel file operations

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.