September 2, 2021
CFspreadsheet not closing files
xamax Follow
Comments
(4)
Share
September 2, 2021
CFspreadsheet not closing files
xamax
Newbie 2 posts
Followers: 0 people
Follow
xamax Follow
(4)
4

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”>
4
xamax
Newbie 2 posts
Followers: 0 people
Follow
xamax Follow
Similar Blogs
4 Comments
xamax
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
Reply
(1)
Charlie Arehart
>
xamax
's comment
2021-09-24 15:45:44
2021-09-24 15:45:44
>
xamax
's comment

Glad to help.

Like
Reply
Charlie Arehart
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
Reply
xamax
2021-09-21 20:59:49
2021-09-21 20:59:49

ughh … no comments or advice?

Like
Reply
Add Comment