L LanHer Unregistered / Unconfirmed GUEST, unregistred user! 2002-07-24 #1 如何在delphi中表示:Cell[1:1]=Cell[1:2]+Cell[1:4]呢? 也就是如何用DELPHI设置公式?
M MichaelZhu Unregistered / Unconfirmed GUEST, unregistred user! 2002-07-24 #2 MyWorkBook.WorkSheets[1].Cells[1,1].Value :=MyWorkBook.WorkSheets[1].Cells[1,2].Value +MyWorkBook.WorkSheets[1].Cells[1,4].Value
MyWorkBook.WorkSheets[1].Cells[1,1].Value :=MyWorkBook.WorkSheets[1].Cells[1,2].Value +MyWorkBook.WorkSheets[1].Cells[1,4].Value
L LanHer Unregistered / Unconfirmed GUEST, unregistred user! 2002-07-24 #3 MichaelZhu:你的这种方式不能把公式抱存呀,我改变一个CELL的内容,不会自动重新计算
L linsb Unregistered / Unconfirmed GUEST, unregistred user! 2002-07-24 #4 var aSheet: variant; aSheet.Cells[3, 3].Value := '=Sum(A1:B1)'; //求和,公式就可以照着写