METHOD ToExcel() need Excel
MsgAlert( FWString( "Excel not installed" ), FWString( "Alert" ) )
did Fivewin already have a Function to use ADO to "create" a XLSx Sheet
![Question :?:](./images/smilies/icon_question.gif)
---
Idea
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
it seem function FW_OpenADOExcelBook( cFile, lHeaders ) return a "Connection" so after create Structure
- Code: Select all Expand view
- CREATE TABLE XXX ( ...
i want to do this
- Code: Select all Expand view
- oRs := FW_OpenRecordSet( oCn, "XXX" )
USE CUSTOMER NEW ALIAS CUST SHARED READONLY VIA 'DBFCDX'
do while ! eof()
oRs:AddNew( { "CUSTNAME", "MARRIED", "AGE", "SALARY" }, ;
{ Left( Trim( CUST->FIRST ) + ' ' + Trim( CUST->LAST ), 30 ), ;
CUST->MARRIED, CUST->AGE, CUST->SALARY } )
SKIP
enddo
CLOSE CUST
oRs:Close()
will this work
![Question :?:](./images/smilies/icon_question.gif)