CSV ignoring between Quotes

[catweasel]

I’m trying to parse a CSV file, that has some data within Quotes, that I want to keep as a chunk not split any commas within it. Do I have to go through it as chars and count quotes, or is there an easier way? for example

Item, “spread1, spread2”, NextItem

Would be

Item
spread1, spread2
NextItem

(Or read an Excell file)

[tonfilm]

there is an excel file reader by sebl: Excel to XDocument - wip - Forum
and there are many CSV related nugets: NuGet Gallery | Packages matching csv

[bjoern]

I’ve had some success with EPPlus (4.5.3.3 - the last free version)] – extending a patch generously provided by @sebl. I can have a look on monday at the office, if you are interested.

[catweasel]

It would be useful to excell support, so it would be great to see that, thanks!

[bjoern]

Here you go:
VL.Excel.7z (131.4 KB)

[catweasel]

Doesnt like my xls file :(

[bjoern]

save as xlsx?
or post a sample file.

[catweasel]

Tried that first! Dropbox
I changed the worksheet name in the patch, but still no go. Its not my final xls, or even the one I need to use, just one that was lying around, be nice to know why it might or might not work.

[bjoern]

It works (with xlsx) when the sheetname doesn’t contain spaces.

[catweasel]

Ah, anyway of working around that, as a generalised solution of excel docs, its not ideal. I can make it work for this project I guess, but I guess this a closed source library so there is no way to fix. Maybe I’ll try and find another one