search

cfsimplicity / spreadsheet-cfml

Standalone library for working with spreadsheets and CSV in CFML
MIT License
129 stars 36 forks source link

Read() format="ArrayOfArrays/ArrayOfStructs" #361

Open Daemach opened 9 months ago

Daemach commented 9 months ago

I like the speed of the readLargeFile() method, and returning a Java array of arrays is a workable format. It would be great to add this as an alternative format for spreadsheet.read(), as well as the array type that Lucee produces, which is an array of structs. These are much more efficient to process because of parallelization, and I need to produce an array of structs to insert/upsert using QB (https://qb.ortusbooks.com/), which I use extensively.

cfsimplicity commented 9 months ago

I think you're talking about readCsv() rather than readLargeFile().

I have thought about back-porting some of the benefits of readCsv() to read() but it's not straightforward I'm afraid because there are features that rely on query processing, plus some cross-engine issues.

Definitely on my wish list though if I can work it out.