Native XLS to CSV

[IZZI ZMAN]

All,

Any guidance or packages to natively convert Microsoft XLS documents to
either CSV or TXT Delimited ?

By  "natively" I don't mean Open===> Save As ! We're running on AIX RISC
platform with UV 10.2.

I google and find many PDF tools, etc...but for Linux and don't think
they are portable to AIX.

TIA, Izzi

[Joe Goldthwaite]

There are lots of python libraries that are most likely available on AIX. Pandas makes this sort of thing pretty trivial.

> --
> You received this message because you are subscribed to
> the "Pick and MultiValue Databases" group.
> To post, email to: mvd...@googlegroups.com
> To unsubscribe, email to: mvdbms+un...@googlegroups.com
> For more options, visit http://groups.google.com/group/mvdbms
> ---
> You received this message because you are subscribed to the Google Groups "Pick and MultiValue Databases" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to mvdbms+un...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/060e640c-62d9-496d-b965-92cf86539583%40gmail.com.

[Brian Speirs]

Well, I don't know anything about AIX - but does AIX support PHP? If so, then try PHPSpreadsheet:

https://github.com/PHPOffice/PhpSpreadsheet

https://phpspreadsheet.readthedocs.io/en/latest/

We use this library extensively for (a) building xlsx spreadsheets (b) converting xlsx spreadsheets to csv (c) combining spreadsheets.

Although I refer to xlsx above, the library supports xls as well (and a number of other formats too).

Cheers,

Brian

[Steven Martin Trimble]

Brian:

quick question please. does this PHP app handle the ability to create 'merged' cells.

Example: for a 4 row heading in a 20 cell spreadsheet, I'd like to have rows 2 thru 5 with cells 8 thru 11 'Merged Center'.

I have been using csv2xlsx_linux_386 and I can do most things, but not 'Merged' anything.

It is available as a downloadable binary. (ie: basically no installation)

I am running openQM commercial on CentOS 7 and Rocky Linux 8 and 9.

thanks in advance,

CDMI

Steven Trimble

(501) 772-3450 cell/text

cdm...@gmail.com

--

You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms
---
You received this message because you are subscribed to the Google Groups "Pick and MultiValue Databases" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mvdbms+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/4bd7fa19-87c1-4d22-b2b8-44e1717b1d14n%40googlegroups.com.

[Wols Lists]

Bear in mind xls is just a zip archive, and the contents are html and
the like, you should be able to get at the data and process it. There
should be stuff out there, but I know what you mean about finding
nothing when you search for it.

Cheers,
Wol

[Brian Speirs]

Hi Steve,

This is a full-featured library that lets you do most things that you would ever want to do. To answer your specific question, YES - it does let you merge cells - see here: https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#mergeunmerge-cells

We use it in Windows (QM 4.0.8), but I assume all functionality will remain the same in Linux. We have quite a number of programs that effectively build PHP scripts and execute them - and those scripts get pretty big. Watch out also for the memory requirements for large spreadsheets.

Contact me offline if you want any further details.

Cheers,

Brian

[Ian McGowan]

Steve, the easiest/"best" approach is probably to use python and a module.  I'm sure you already know IBM has AIX Toolbox for Linux, but it can still be tough to download python modules that are not "pure" - they have native compiled components for Linux/Win/Mac, but not AIX.

You can also roll your own native excel sheets by very carefully creating XML blobs like Wol says.  This is very fiddly to get right, but there's a working example at  SCI.XLSX.RECALL - Pickwiki if that helps.  It doesn't support merging of cells, so you'd have to do that in a new workbook them look at the xl/worksheets/sheet.xml and see how Excel does it natively.

[George Gallen]

I wrote a PHP program to convert a file with Pseudocode created by a series of UV subroutines then uses php-spreadsheet library to run through pseudo code and create an xlsx file.  Not native but if we change packages we only need to update the pseudo code to XLSX PHP interface

On Oct 21, 2024, at 9:37 AM, Steven Martin Trimble <cdm...@gmail.com> wrote:



To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/CAJDLGm4E58tTwMRu0r6ODPZkNzJ5vgkLsqyW9AsBe4ibEBFDnQ%40mail.gmail.com.

[Steven Martin Trimble]

Thanks for all the advice. I decided to create both: csv2xls and xml

I created an Excel spreadsheet and saved it 'as XML'. That becomes my template. I changed areas that are dynamic to have static variables and used the SWAP to replace the static variables with the dynamic data. Really pretty easy.

That way the client has multiple options.

Thanks again for your help,

CDMI

Steven Trimble

(501) 772-3450 cell/text

cdm...@gmail.com

To view this discussion visit https://groups.google.com/d/msgid/mvdbms/510f6bd8-10e7-471c-9984-0b31273202f3n%40googlegroups.com.