Commitd24ce4b

authored

Add tool to get merged cells (#59)

1 parent81d786b commitd24ce4bCopy full SHA for d24ce4b

File tree

+41

-0

lines changed

+41

-0

lines changed

Lines changed: 13 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -145,6 +145,19 @@ unmerge_cells(filepath: str, sheet_name: str, start_cell: str, end_cell: str) ->`
`145`	`145`	-`end_cell`: Ending cell of range
`146`	`146`	`- Returns: Success message`
`147`	`147`
	`148`	`+###get_merged_cells`
	`149`	`+`
	`150`	`+Get merged cells in a worksheet.`
	`151`	`+`
	`152`	+```python
	`153`	`+get_merged_cells(filepath:str, sheet_name:str)->str`
	`154`	+```
	`155`	`+`
	`156`	+-`filepath`: Path to Excel file
	`157`	+-`sheet_name`: Target worksheet name
	`158`	`+- Returns: String representation of merged cells`
	`159`	`+`
	`160`	`+`
`148`	`161`	`##Formula Operations`
`149`	`162`
`150`	`163`	`###apply_formula`

Lines changed: 13 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -32,6 +32,7 @@`
`32`	`32`	`rename_sheet,`
`33`	`33`	`merge_range,`
`34`	`34`	`unmerge_range,`
	`35`	`+get_merged_ranges,`
`35`	`36`	`)`
`36`	`37`
`37`	`38`	`# Get project root directory path for log file path.`
`@@ -469,6 +470,18 @@ def unmerge_cells(filepath: str, sheet_name: str, start_cell: str, end_cell: str`
`469`	`470`	`logger.error(f"Error unmerging cells:{e}")`
`470`	`471`	`raise`
`471`	`472`
	`473`	`+@mcp.tool()`
	`474`	`+defget_merged_cells(filepath:str,sheet_name:str)->str:`
	`475`	`+"""Get merged cells in a worksheet."""`
	`476`	`+try:`
	`477`	`+full_path=get_excel_path(filepath)`
	`478`	`+returnstr(get_merged_ranges(full_path,sheet_name))`
	`479`	`+except (ValidationError,SheetError)ase:`
	`480`	`+returnf"Error:{str(e)}"`
	`481`	`+exceptExceptionase:`
	`482`	`+logger.error(f"Error getting merged cells:{e}")`
	`483`	`+raise`
	`484`	`+`
`472`	`485`	`@mcp.tool()`
`473`	`486`	`defcopy_range(`
`474`	`487`	`filepath:str,`

Lines changed: 15 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -243,6 +243,21 @@ def unmerge_range(filepath: str, sheet_name: str, start_cell: str, end_cell: str`
`243`	`243`	`logger.error(f"Failed to unmerge range:{e}")`
`244`	`244`	`raiseSheetError(str(e))`
`245`	`245`
	`246`	`+defget_merged_ranges(filepath:str,sheet_name:str)->list[str]:`
	`247`	`+"""Get merged cells in a worksheet."""`
	`248`	`+try:`
	`249`	`+wb=load_workbook(filepath)`
	`250`	`+ifsheet_namenotinwb.sheetnames:`
	`251`	`+raiseSheetError(f"Sheet '{sheet_name}' not found")`
	`252`	`+worksheet=wb[sheet_name]`
	`253`	`+return [str(merged_range)formerged_rangeinworksheet.merged_cells.ranges]`
	`254`	`+exceptSheetErrorase:`
	`255`	`+logger.error(str(e))`
	`256`	`+raise`
	`257`	`+exceptExceptionase:`
	`258`	`+logger.error(f"Failed to get merged cells:{e}")`
	`259`	`+raiseSheetError(str(e))`
	`260`	`+`
`246`	`261`	`defcopy_range_operation(`
`247`	`262`	`filepath:str,`
`248`	`263`	`sheet_name:str,`

Comments

(0)