Is spreadsheet-cfml compatible with lucee 6? #380

novus744 · 2024-11-18T17:01:45Z

novus744
Nov 18, 2024

I am just wondering because I believe I have it installed properly but I am getting an error. GetFileInfo can find the file using the same path.

<html>
<body>
<!--StartFragment-->
Lucee 6.0.4.10 Error (cfsimplicity.spreadsheet.nonExistentFile)
--
Message | Non-existent file
Detail | Cannot find the file addressbook.xlsx.
Stacktrace | The Error Occurred in/var/www/HomeCenter/helpers/exception.cfc: line 1311:12:    void function throwNonExistentFileException( required string path ){13:       Throw( type=library().getExceptionType() & ".nonExistentFile", message="Non-existent file", detail="Cannot find the file #arguments.path#." );14:    }15:

<!--EndFragment-->
</body>
</html>

Answered by cfsimplicity

Nov 18, 2024

You need to pass an absolute file path to the read() function. So change:

filepath = "addressbook.xlsx";

to

filepath = ExpandPath( "addressbook.xlsx" );

View full answer

cfsimplicity · 2024-11-18T17:22:47Z

cfsimplicity
Nov 18, 2024
Maintainer

I've had mixed results with Lucee 6. Some releases work ok but with others I can't get the test suite to pass or run at all for reasons I don't really understand.

What is the actual code you are trying to run when you get that error?

3 replies

novus744 Nov 18, 2024
Author

I was just reading a file:

address_book = CreateObject( "component", "HomeCenter.Spreadsheet" ).init();
filepath = "addressbook.xlsx";
writeDump(getFileInfo("addressbook.xlsx"))
qry = address_book.read( src=filepath, format="query" );
//writeDump(qry)

cfsimplicity Nov 18, 2024
Maintainer

You need to pass an absolute file path to the read() function. So change:

filepath = "addressbook.xlsx";

to

filepath = ExpandPath( "addressbook.xlsx" );

Answer selected by novus744

novus744 Nov 18, 2024
Author

Thanks! I should pay better attention to the docs.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Is spreadsheet-cfml compatible with lucee 6? #380

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 1 comment 3 replies

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

Select a reply

Is spreadsheet-cfml compatible with lucee 6? #380

novus744 Nov 18, 2024

Replies: 1 comment · 3 replies

cfsimplicity Nov 18, 2024 Maintainer

novus744 Nov 18, 2024 Author

cfsimplicity Nov 18, 2024 Maintainer

novus744 Nov 18, 2024 Author

novus744
Nov 18, 2024

Replies: 1 comment 3 replies

cfsimplicity
Nov 18, 2024
Maintainer

novus744 Nov 18, 2024
Author

cfsimplicity Nov 18, 2024
Maintainer

novus744 Nov 18, 2024
Author