topic-43316

Board index FiveWin for Harbour/xHarbour "close" FW_OpenADOExcelSheet()

Posts: 1772

Joined: Thu Sep 05, 2019 05:32 AM

"close" FW_OpenADOExcelSheet()
Posted: Mon Jun 12, 2023 04:20 AM

hi,

i use

   objRS := FW_OpenADOExcelSheet( cPathcFile, cSheet, cRange, lHeaders )

to get "ADODB.Recordset" of Excel Sheet

FW_OpenADOExcelSheet() also open "ADODB.Connection"

Code (fw): Select all Collapse

   if ( oCn := FW_OpenAdoExcelBook( @cFile, lHeaders ) ) == nil

i can "close"

Code (fw): Select all Collapse

   objRS:Close()

but *.XLSx Files seems to be "Lock" after use FW_OpenADOExcelSheet()

how about "ADODB.Connection" which was called when use FW_OpenAdoExcelBook() :?:

greeting,

Jimmy

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: "close" FW_OpenADOExcelSheet()
Posted: Mon Jun 12, 2023 11:51 AM

Code (fw): Select all Collapse

oRs:Close()
oRs:ActiveConnection:Close()

Regards

G. N. Rao.

Hyderabad, India

Jimmy

Posts: 1772

Joined: Thu Sep 05, 2019 05:32 AM

Re: "close" FW_OpenADOExcelSheet()
Posted: Mon Jun 12, 2023 04:50 PM

hi,

thx for Answer

greeting,

Jimmy

FiveTech Support Forums

Continue the discussion