Julian Halliwell

Sorry but I don't understand what "WPS" means or what software you are using in your video. As far as the library/POI is concerned, your spreadsheet does not appear to...

@bdw429s I don't think so. The trim option in #339 just removes leading/trailing space from the whole CSV string, whereas this issue is about trimming individual column names/values, which seems...

@Daemach Again could you see if the new `readCsv()` helps here? https://github.com/cfsimplicity/spreadsheet-cfml/blob/develop/test/specs/readCsv.cfm

I think you're talking about [readCsv()](https://github.com/cfsimplicity/spreadsheet-cfml/wiki/readCsv) rather than [readLargeFile()](https://github.com/cfsimplicity/spreadsheet-cfml/wiki/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...

Reading the file you attached seems to work as expected using this code: ``` spreadsheet = New spreadsheet.Spreadsheet(); path = ExpandPath( "CB8188710A3B4338BE83A4D2FE9F65DF.xlsx" ); data = spreadsheet.setReturnCachedFormulaValues( true ).read( path, "query"...

> Please try this one. Same result. Reads into a query just fine using the code above. From what you say it seems that the issue is caused by the...

I think you're talking about [readCsv()](https://github.com/cfsimplicity/spreadsheet-cfml/wiki/readCsv) rather than [readLargeFile()](https://github.com/cfsimplicity/spreadsheet-cfml/wiki/readLargeFile). The `read()` method does that because a query _must_ have column names. `readCsv()` returns an array of arrays which doesn't require...

You can test it now, James (and please do). But support is only experimental and partial at the moment. My experience so far is that the test suite runs really...

Hi Sébastien I'm not sure I understand what you're asking for. Absolute references using $ signs are generally for formulas as I understand it. They're not a property of the...

> Is it also possible to specify the Sheet ? Just [change the active sheet](https://github.com/cfsimplicity/spreadsheet-cfml/wiki/setActiveSheet) to the one you want before calling the method.