>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