你需要使用
mata
功能
b.set.sheet.merge()
相反:
clear
*Build sample matrix
set obs 10
foreach i of numlist 1/10{
gen var`i' = _n + `i'
}
mkmat var1-var10, matrix(m)
*To Excel
quietly putexcel set "Test_Merge.xlsx", sheet("Sheet1") modify
quietly putexcel A1=matrix(m)
*Prep for mata
mata: b = xl()
mata: b.load_book("Test_Merge.xlsx")
*Left-align some cells
mata: cols = (1,2)
mata: b.set_horizontal_align(1, cols, "left")
*Center some cells
mata: cols = (4,5)
mata: b.set_horizontal_align(1, cols, "center")
*Merge some cells
mata: rows = (1,1)
mata: cols = (7,8)
mata: b.set_sheet_merge("Sheet1", rows, cols)
请注意粗体的更改,这些更改将函数应用于两个单元格。