General information
Category:
Coding, syntax & commands
The easiest way is to record a macro in Excel, observe the macro code and translate it to VFP. In your particular case, try something like:
ObjExcel.Selection.EntireRow.Insert
*Insert into column 4 cell :
objexcel.activesheet.cells(ObjExcel.Selection.Row,4).value="HELLO"
>oExcel = CREATEOBJECT('Excel.Application') will create an Excel object, but how to I find out the possible command to use with that object.
>
>I have seen a few, but I how do I find a list of all or some type of documentation.
>
>For example
>oExcel.Workbooks.Add
>oExcel.ActiveSheet.RANGE('A1').SELECT
>oExcel.ActiveSheet.Paste()
>oExcel.visible = .T.
>
>How do I insert a new top row into an existing XLS and populate one cell of that new row?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only