Reading .xls excel files

Do we have software able at least to read excel files ?

Straight out of the box, I doubt it, but .xs is just zipped xml, so unpack and peruse in a text viewer.

Gnumeric on AmiCygnix ? (I tried to launch it to test but idesk crashed.)

@broadblues
uinarc does not recognise the file, do i need something more?

I downloaded unzip from OS4depot and triedt to unzp it directly

12.Work40:_12_Abortion/bevolking> unzip pop2010-2016mov_nl_tcm325-234223.xls ram:out
Archive: pop2010-2016mov_nl_tcm325-234223.xls
End-of-central-directory signature not found. Either this file is not
a zipfile, or it constitutes one disk of a multi-part archive. In the
latter case the central directory and zipfile comment will be found on
the last disk(s) of this archive.
unzip: cannot find zipfile directory in pop2010-2016mov_nl_tcm325-234223.xls,
and cannot find pop2010-2016mov_nl_tcm325-234223.xls.zip, period.


I donladed the file as http://statbel.fgov.be/nl/binaries/po ... 6mov_nl_tcm325-234223.xls

@JosDuchIt,
.xls are not xml zipped archives,
but you can open them with gnumeric on AmiCygnix

@JosDuchIt

.xls files up until version Office 2000 can be opened with TurboCalc 5.02

you could also use the hundred of so free online converters to the format you want !

@pvanni

Oops my mistake, .xlsx is the modern xml version.

@Lio yes best bet would be convert to CSV or somthig on the net somewhere.

@TSK

Quote:

Maybe this is the problem with OS4.1 FE update 1. Please dont't use the display driver "picasso96clonewbdb", use "picasso96clonewb" instead. It should work, but is a bit slower.

@JosDuchIt

Gnumeric on AmiCygnix loads and saves .xls and also the newer .xlsx files.

@ Lio & others
@cygnusEd


I downloaded gnumeric and launched it. It reads the file mentioned above, but i experience the same problem as with converters i used (converson to html)

Way down the excel page you have (withexcel) the possibility (links?) to load/see similar pages for different years.
On one converted html file the links appeared on top of the page but did not work, with an other one the links simply did not appear.
That is also the gnumeric behavior

@JosDuchIt

I tried this with Gnumeric:

- Created a file with a link in it using menu item "Insert/Hyperlink...".
- Saved it in .xls and .xlsx format
- Loaded these files again in Gnumeric

The links were still there.

I'm afraid this will not help you, but it would be interesting what you get, if you load such an .xls or .xlsx file into Excel (Don't have it here)

@JosDuchIt

I just downloaded the file you linked to on a Win 7 system with MS Office.

AFAICS, the "links" you refer to are not links, but tabs. They display different pages (worksheets?) inside the same .xls file (workbook?).

I don't remember whether this is a specific MS concept, or other spreadsheet programs also support them, and specifically I don't remember if TurboCalc does.

Best regards,

Niels

@nbache
@JosDuchIt

Tabs are also supported under Gnumeric. I've loaded the test file (pop2010-2016mov_nl_tcm325-234223.xls) and the tabs are there.

@cygnusEd


On my ipad i did see the tabs aborve the data and here only the years 2016 till2010, si i expected to se them there too

But now i see tabs too below the data ,but only the year 2008 2009
I did notice however the rrows left and right which give acces tot years 2010 etc.
In all the experience i needed: Thanks a lot for help & gnumeric.
I will try to read some help on the net now