# CORRECT - Use --values-file
$data = '[["Name","Price"],["Widget",100]]'
$data | Out-File -Encoding UTF8 C:\temp\data.json
excelcli -q range set-values --session 1 --sheet Sheet1 --range A1 --values-file C:\temp\data.json

# CORRECT - Use --mcode-file for Power Query
$mcode | Out-File -Encoding UTF8 C:\temp\query.m
excelcli -q powerquery create --session 1 --query Products --mcode-file C:\temp\query.m

excelcli -q session open C:\path\file.xlsx     # Returns session ID
excelcli -q range set-values --session 1 ...   # Use session ID
excelcli -q session close --session 1 --save   # Save and release

excelcli -q table add-to-datamodel --session 1 --table Sales  # Step 1
excelcli -q datamodel create-measure --session 1 ...          # Step 2 - NOW works

# Step 1: Test M code without persisting (catches errors early)
excelcli -q powerquery evaluate --session 1 --mcode-file query.m

# Step 2: Create permanent query with validated code
excelcli -q powerquery create --session 1 --query Q1 --mcode-file query.m

# Step 3: Load data to destination
excelcli -q powerquery refresh --session 1 --query Q1

# 1. Set manual mode
excelcli -q calculationmode set-mode --session 1 --mode manual

# 2. Perform bulk writes
excelcli -q range set-values --session 1 --sheet Sheet1 --range A1 --values-file data.json

# 3. Recalculate once at end
excelcli -q calculationmode calculate --session 1 --scope workbook

# 4. Restore automatic mode
excelcli -q calculationmode set-mode --session 1 --mode automatic

dotnet tool install --global Sbroenne.ExcelMcp.CLI