Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert to excel
Message
From
14/02/2008 03:45:34
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Convert to excel
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01292500
Message ID:
01292500
Views:
60
hi all,
i need help to insert thisform.text1.value and thisform.text2.value at first and second records excel sheet via code as
SELECT sno,fexerno,empno,disc1,solveerror from trans1;
         where  fexerno=thisform.text2.value ;
         ORDER by sno;
          into cursor crsMyCursor readwrite
*--------------------------
**first record(line1)=thisform.text1.value
**second record(line2)=thisform.text2.value
**select statment begin from line 3
*-------------------------------------

gcDelimName = ALIAS( ) + '.xls'
gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
IF EMPTY(gcDelimFile)  
   CANCEL
ENDIF
COPY TO (gcDelimFile) XLS   
thanks
Next
Reply
Map
View

Click here to load this message in the networking platform