Excel celloperationer

Excel celloperationer

Genomför avancerade Excel celloperationer med AI-driven automation. Slå samman celler, kopiera/klistra in, rensa innehåll och manipulera Excel-celler med precision.

Tillgängliga Verktyg

  • cell_operations - Excel celloperationer (slå ihop, kopiera/klistra in, rensa) med AI-driven automation
  • cell_operations_batch - Utför flera Excel celloperationer i batch via kalkylblad MCP

Enskilda celloperationer

Slå samman celler

{
  "tool": "cell_operations",
  "parameters": {
    "filepath": "reports/merged-layout.xlsx",
    "sheet_name": "Report",
    "operation": "merge_cells",
    "range": "A1:C1"
  }
}

Avsluta sammanslagning av celler

{
  "tool": "cell_operations",
  "parameters": {
    "filepath": "reports/unmerged.xlsx",
    "sheet_name": "Data",
    "operation": "unmerge_cells",
    "range": "A1:C1"
  }
}

Kopiera celler

{
  "tool": "cell_operations",
  "parameters": {
    "filepath": "reports/data-copy.xlsx",
    "sheet_name": "Source",
    "operation": "copy_cells",
    "source_range": "A1:D5"
  }
}

Klistra in värden

{
  "tool": "cell_operations",
  "parameters": {
    "filepath": "reports/data-copy.xlsx",
    "sheet_name": "Target",
    "operation": "paste_values",
    "destination_range": "A1"
  }
}

Rensa innehåll

{
  "tool": "cell_operations",
  "parameters": {
    "filepath": "reports/cleanup.xlsx",
    "sheet_name": "Data",
    "operation": "clear_contents",
    "range": "A1:Z100"
  }
}

Batch Cell Operations

Komplett sammanslagning och kopieringsarbetsflöde

{
  "tool": "cell_operations_batch", 
  "parameters": {
    "filepath": "reports/financial-report.xlsx",
    "sheet_name": "Sheet1",
    "operations": [
      {
        "operation": "merge_cells",
        "range": "A7:C7"
      },
      {
        "operation": "paste_values",
        "source_range": "A1:F1",
        "destination_range": "A9"
      },
      {
        "operation": "paste_formats",
        "source_range": "A1:F1", 
        "destination_range": "A12"
      }
    ]
  }
}

Tvärbladoperationer

{
  "tool": "cell_operations",
  "parameters": {
    "filepath": "reports/multi-sheet.xlsx",
    "sheet_name": "Summary",
    "operation": "paste_values",
    "source_range": "A1:F5",
    "source_sheet": "Data",
    "destination_range": "A1"
  }
}

Datarensningsoperationer

{
  "tool": "cell_operations_batch",
  "parameters": {
    "filepath": "reports/cleanup-demo.xlsx",
    "sheet_name": "Data",
    "operations": [
      {
        "operation": "clear_contents",
        "range": "A1:A10"
      },
      {
        "operation": "clear_formats",
        "range": "B1:B10"
      },
      {
        "operation": "clear_all",
        "range": "C1:C10"
      }
    ]
  }
}

Referens för operationstyper

Sammanfogningsoperationer

  • merge_cells - Slå ihop celler till en cell
  • unmerge_cells - Dela upp sammanslagna celler till separata celler
  • merge_across - Sammanslagning av celler över rader medan separata rader behålls

Kopiera/klistra in operationer

  • copy_cells - Kopiera cellområde till urklipp
  • paste_values - Klistra in endast värden (ingen formatering eller formler)
  • paste_formulas - Klistra in endast formler (inte värden eller formatering)
  • paste_formats - Klistra in endast formatering (inte värden eller formler)
  • transpose_paste - Klistra in med transponerad orientering (rader↔kolumner)

Rengöringsoperationer

  • clear_contents - Rensa cellinnehåll (bevara formatering)
  • clear_formats - Rensa cellformatering (bevara innehåll)
  • clear_all - Rensa både innehåll och formatering

Avancerade exempel

Rapporttitel Inställning

{
  "tool": "cell_operations_batch",
  "parameters": {
    "filepath": "reports/title-report.xlsx",
    "sheet_name": "Report",
    "operations": [
      {
        "operation": "merge_cells",
        "range": "A1:F1"
      },
      {
        "operation": "merge_cells",
        "range": "A2:F2"
      },
      {
        "operation": "merge_cells",
        "range": "A3:C3"
      },
      {
        "operation": "merge_cells",
        "range": "D3:F3"
      }
    ]
  }
}

Skapa Data Mall

{
  "tool": "cell_operations_batch",
  "parameters": {
    "filepath": "templates/data-template.xlsx",
    "sheet_name": "Template",
    "operations": [
      {
        "operation": "copy_cells",
        "source_range": "A1:F1"
      },
      {
        "operation": "paste_formats",
        "destination_range": "A10"
      },
      {
        "operation": "paste_formats",
        "destination_range": "A20"
      },
      {
        "operation": "paste_formats",
        "destination_range": "A30"
      }
    ]
  }
}

Datakonsolidering

{
  "tool": "cell_operations_batch",
  "parameters": {
    "filepath": "reports/consolidated.xlsx",
    "sheet_name": "Summary",
    "operations": [
      {
        "operation": "paste_values",
        "source_range": "A1:E10",
        "source_sheet": "Q1Data",
        "destination_range": "A2"
      },
      {
        "operation": "paste_values",
        "source_range": "A1:E10",
        "source_sheet": "Q2Data", 
        "destination_range": "A12"
      },
      {
        "operation": "paste_values",
        "source_range": "A1:E10",
        "source_sheet": "Q3Data",
        "destination_range": "A22"
      }
    ]
  }
}

Formel- och Formatseparation

{
  "tool": "cell_operations_batch",
  "parameters": {
    "filepath": "reports/separated.xlsx",
    "sheet_name": "Analysis",
    "operations": [
      {
        "operation": "paste_formulas",
        "source_range": "A1:F10",
        "source_sheet": "Calculations",
        "destination_range": "A1"
      },
      {
        "operation": "paste_formats",
        "source_range": "A1:F10", 
        "source_sheet": "Formatting",
        "destination_range": "A1"
      }
    ]
  }
}

Kors-Ark Operations

Kopiera Mellan Ark

{
  "tool": "cell_operations",
  "parameters": {
    "filepath": "reports/multi-sheet-copy.xlsx",
    "sheet_name": "Destination",
    "operation": "paste_values",
    "source_range": "A1:D10",
    "source_sheet": "Source",
    "destination_range": "B2"
  }
}

Sammanfattningsblad Skapande

{
  "tool": "cell_operations_batch",
  "parameters": {
    "filepath": "reports/summary-creation.xlsx",
    "sheet_name": "Summary",
    "operations": [
      {
        "operation": "paste_values",
        "source_range": "A1:C5",
        "source_sheet": "January",
        "destination_range": "A2"
      },
      {
        "operation": "paste_values",
        "source_range": "A1:C5",
        "source_sheet": "February",
        "destination_range": "E2"
      },
      {
        "operation": "paste_values",
        "source_range": "A1:C5",
        "source_sheet": "March",
        "destination_range": "I2"
      }
    ]
  }
}

Data Transformation

Transponera Data

{
  "tool": "cell_operations",
  "parameters": {
    "filepath": "reports/transposed.xlsx",
    "sheet_name": "Data",
    "operation": "transpose_paste",
    "source_range": "A1:E5",
    "destination_range": "G1"
  }
}

Endast Värden Kopiera

{
  "tool": "cell_operations_batch",
  "parameters": {
    "filepath": "reports/values-only.xlsx",
    "sheet_name": "Clean Data",
    "operations": [
      {
        "operation": "copy_cells",
        "source_range": "A1:F20",
        "source_sheet": "Raw Data"
      },
      {
        "operation": "paste_values",
        "destination_range": "A1"
      }
    ]
  }
}

Bästa praxis

  1. Sammanfoga Strategiskt: Använd sammanslagning för rubriker och titlar, inte datadelen
  2. Kopiera Innan Klistra in: Kopiera alltid källintervallet innan du klistrar in
  3. Rensa Passande: Välj rätt rensningsalternativ för ditt behov
  4. Planering på Kors-ark: Planera multi-ark operationer för att undvika konflikter
  5. Batch-operationer: Grupp relaterade operationer för bättre prestanda

Vanliga användningsområden

Rapportrubriker

  • Sammanfoga celler för titlar
  • Kopiera rubrikformat -Applicera konsekvent stil

Data Rensning

  • Rensa föråldrat innehåll
  • Ta bort formatering
  • Återställ cellstatusar

Mallskapande

  • Kopiera formateringsmönster
  • Klistra in struktur utan data
  • Skapa återanvändbara layouter

Datakonsolidering

  • Kombinera data från flera blad
  • Klistra in endast värden för att undvika formelfel
  • Transponera dataorientering

Felhantering

Ogiltigt sammanslagningsintervall

{
  "tool": "cell_operations",
  "parameters": {
    "filepath": "test.xlsx",
    "sheet_name": "Sheet1",
    "operation": "merge_cells",
    "range": "A1"
  }
}

Resultat: Fel - kan inte slå ihop enskild cell

Saknat källintervall

{
  "tool": "cell_operations",
  "parameters": {
    "filepath": "test.xlsx",
    "sheet_name": "Sheet1",
    "operation": "paste_values",
    "destination_range": "A1"
  }
}

Resultat: Fel - inget kopierat data finns tillgängligt

Ogiltig bladreferens

{
  "tool": "cell_operations",
  "parameters": {
    "filepath": "test.xlsx",
    "sheet_name": "Sheet1",
    "operation": "paste_values",
    "source_range": "A1:B2",
    "source_sheet": "NonExistentSheet",
    "destination_range": "A1"
  }
}

Resultat: Fel - källbladet kunde inte hittas

Excel rad och kolumnoperationer