CFspreadsheet not closing files
September 2, 2021
CFspreadsheet not closing files
September 2, 2021
Newbie 2 posts
Followers: 0 people

when I use CFspreadsheet (CF2021) to read an XLSX file, the file remains locked until the CF service is restarted.
is there a way to force the file closed after the read operation? the file that is opened for read cannot be deleted once it is read — even after the CFM page is finished.

    <cfspreadsheet
    action=”read”
    src = “GA2.xlsx”
    sheetname=”Dataset1″
    columns = “1-4”
    headerrow = “1”
    excludeHeaderRow = “true”
    rows = “1-51”
    query = “GA_File”>
All Comments
Sort by:  Most Recent
2021-09-24 15:14:13
2021-09-24 15:14:13

Yes, I can confirm that the bug was fixed in Update 2.
I applied update 2 yesterday and it is no longer locking the file on read.

now onto the problem with CFLDAP which stopped connecting recently (12 year old code)
I am following the discussions in the other discussion area
Errors authenticating using CFLDAP – Page 2 – Adobe Support Community – 12131321
I will post more information there later today

 

Like
()
(1)
2021-09-24 15:45:44
2021-09-24 15:45:44
>
xamax
's comment

Glad to help.

Like
()
2021-09-22 18:03:10
2021-09-22 18:03:10

Xamax, I have what may be good news for you. You don’t indicate what update of CF 2021 you are using, but I’m guessing it’s either no update or update 1. Because the technote for update 2 indicates that this bug was fixed with that update:

https://helpx.adobe.com/coldfusion/kb/coldfusion-2021-update-2.html

Let us know if you get to trying it and find that it works.

Like
()
2021-09-21 20:59:49
2021-09-21 20:59:49

ughh … no comments or advice?

Like
()