>How to automate excel in vfp with execel file template.

Hi Martin,
You can have look at my rep2exel tool here in downloads.
( Download#14800 freeware/source included. )

It is class object having wrapper methods for most of common automation tasks. So you can write excel sheet using 3d positioning (nSheet,nRow,nColumn)

like ;

oXL.make_cell(nSheet,nRow,nCol,'Hello World')
oXL.table_in_section(i,j,k,cAlias,cFieldsIWant)
oXL.table_in_row(i,j,k,cAlias,cFieldsIWant)
oXL.array_in_section(i,j,k,@myArray)
oXL.insert_picture(i,j,k,cFileName)
oXL.draw_box(nTop,nLeft,nDown,nRight)
etc

There are examples there using templates as well.


Just change value of property 'default_output_dir' in class code
since was originally set to 'C:\windows\desktop' to show on my W98 desktop
back then in 2002.

Rgds++
Sergio