[fpc-pascal] Spreadsheet library/unit?

[Tomas Hajny]

On Mon, October 6, 2008 05:33, Antal wrote:
>>
>>  It is a plain text file, each row is separated with CRLF (#13#10), each
>>> cell separated with tab (#9)
>>>
>>
>> errm, surely that should be a comma, not a tab!
>
>
> The Tab as separator is just a good way to avoid using the double quote :P
> It just comes from the good old Lotus123.
> Anyway, just try to copy/paste to a notepad from an Excel and you will see
> how it works.
> And then, saved as .CSV reopen it with Office and it might work. Or it
> might
> not :P
> I am currently using this, since it is easier to manage as the double
> quotes.

An additional issue with delimiters in this case is the fact, that "C" in
"CSV" may not always be a comma (or that spreadsheet applications may
expect different characters depending on locale - e.g. semicolons, etc.).

Tomas