"close" FW_OpenADOExcelSheet()

"close" FW_OpenADOExcelSheet()

Postby Jimmy » Mon Jun 12, 2023 4:20 am

hi,

i use
Code: Select all  Expand view
  objRS := FW_OpenADOExcelSheet( cPathcFile, cSheet, cRange, lHeaders )

to get "ADODB.Recordset" of Excel Sheet

FW_OpenADOExcelSheet() also open "ADODB.Connection"
Code: Select all  Expand view
  if ( oCn := FW_OpenAdoExcelBook( @cFile, lHeaders ) ) == nil


i can "close"
Code: Select all  Expand view
  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
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Re: "close" FW_OpenADOExcelSheet()

Postby nageswaragunupudi » Mon Jun 12, 2023 11:51 am

Code: Select all  Expand view
oRs:Close()
oRs:ActiveConnection:Close()
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10620
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: "close" FW_OpenADOExcelSheet()

Postby Jimmy » Mon Jun 12, 2023 4:50 pm

hi,

thx for Answer
greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 48 guests