transpose_range
Transpose cell ranges in Excel by swapping rows and columns, writing output to any target cell. Supports optional paste as values only.
Instructions
Transpose a source range (rows↔columns) and write starting at target_cell.
Args:
file_path: Path to workbook.
sheet_name: Target worksheet name (destination for transposed data).
source_range: Range to transpose (on sheet_name by default).
target_cell: Top-left cell for the transposed output.
source_sheet: Optional source sheet name if different from sheet_name.
paste_values_only: If True, paste only resolved values (no formulas).
Returns: dict: Summary including target range written and number of cells.
Notes: - Destructive: overwrites destination cells.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| sheet_name | Yes | ||
| target_cell | Yes | ||
| source_range | Yes | ||
| source_sheet | No | ||
| paste_values_only | No |