@picpic020960 said:
how to for write data to excel from ruby ?
Try something simple like:
def set_value(row,col,val)
#
@xl.activesheet.cells(row,col).value = val
#
end ### set_value()
@picpic020960 said:
other question :
[Do you know if there] exists 'macro' recorder as in Excel ?
Whatever exists in Excel, and has a built-in VisualBasic interface, can be accessed via WIN32OLE (from Ruby.)
So, refer to the VisualBasic object model for Excel:
MSDN: Object model (Excel VBA reference)