Standalone Excel to csv conversion?

[Joao S. O. Bueno]

Hi

I am currently working part time in "turicas/rows" which
have some of the same functionality.

If you give it a try, and find it lacking in the features you are in need,
just drop a message.

On Wed, Apr 27, 2022 at 9:30 AM EML <sa212+lo at cyconix.com> wrote:

> Background: I've spent several years converting xls[x] to csv using
> 'in2csv', which is a Python app. This has always been problematical, but
> does give correct output if you're careful with the input. However, the
> current version (1.0.6) has broken some functionality, so it's probably
> no longer usable. This seems to be a generic problem with Python
> solutions which use 'xlrd'.
>
> The requirement is actually pretty trivial: the input spreadsheets
> contain only ASCII text and times, which are formatted as either
> [m]:ss.0, or [m]:ss.00. The csv output should therefore look like
> "5:10.52" for 310.52 seconds, and so on. The old in2csv frequently
> produced floating-point output instead, but this is Ok, since it's
> easily convertible to seconds.
>
> I've been looking for C/C++ alternatives, but the libraries I've found
> don't appear to be well-supported or tested, and may well have other
> problems.
>
> However, this *does* work when using LibreOffice (6.4.7.2/RHEL8) for
> one-off conversions. I can read an xls or xlsx, save-as csv, and get the
> correct result.
>
> Question: how realistic is it to hack Calc to extract a stand-alone
> Excel-to-csv converter? I can do the development as long as I can get
> usable results in a few days, and I don't have to write anything that's
> not C++. However, this is a non-starter if there are any Java
> dependencies (the code has to run on a webapp which is a minimal Ubuntu
> server install); I need something which can either link into a C++ app,
> or be run directly with minimal dependencies.
>
> I'd appreciate some feedback on how realistic this is before downloading
> any sources and looking at them. Thanks.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20220427/e7528a36/attachment.htm>