Home  
Login
Username:

Password:

Remember me



Lost Password?

Register now!
Sections
Who's Online
59 user(s) are online (51 user(s) are browsing Forums)

Members: 1
Guests: 58

daveyw, more...
Support us!
Recent OS4 Files
OS4Depot.net





Reading .xls excel files
Just can't stay away
Joined:
2009/2/9 19:32
From Brussels Belgium
Posts: 1080
Do we have software able at least to read excel files ?

   Report Go to top

Re: Reading .xls excel files
Just can't stay away
Joined:
2006/12/4 23:15
Posts: 1881
Straight out of the box, I doubt it, but .xs is just zipped xml, so unpack and peruse in a text viewer.


_________________
Blender For OS4.x : Blues : Walker Broad
   Report Go to top

Re: Reading .xls excel files
Just can't stay away
Joined:
2007/2/23 13:49
From Finland, the land of Santa, sauna, sisu and salmiakki
Posts: 1059
Gnumeric on AmiCygnix ? (I tried to launch it to test but idesk crashed.)

_________________
Rock lobster bit me, so excuse me.
X1000 + AmigaOS 4.1 FE. Be authentic.
"Anyone can build a fast CPU. The trick is to build a fast system." - Seymour Cray
   Report Go to top

Re: Reading .xls excel files
Just can't stay away
Joined:
2009/2/9 19:32
From Brussels Belgium
Posts: 1080
@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

   Report Go to top

Re: Reading .xls excel files
Not too shy to talk
Joined:
2006/12/5 22:11
From Lecco, Italy
Posts: 287
@JosDuchIt,
.xls are not xml zipped archives,
but you can open them with gnumeric on AmiCygnix

   Report Go to top

Re: Reading .xls excel files
Not too shy to talk
Joined:
2006/12/6 19:36
Posts: 412
@JosDuchIt

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

   Report Go to top

Re: Reading .xls excel files
Not too shy to talk
Joined:
2006/12/3 23:51
From France
Posts: 367
you could also use the hundred of so free online converters to the format you want !

   Report Go to top

Re: Reading .xls excel files
Just can't stay away
Joined:
2006/12/4 23:15
Posts: 1881
@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.

_________________
Blender For OS4.x : Blues : Walker Broad
   Report Go to top

Re: Reading .xls excel files
Not too shy to talk
Joined:
2006/12/24 12:23
Posts: 466
@TSK

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


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.

   Report Go to top

Re: Reading .xls excel files
Not too shy to talk
Joined:
2006/12/24 12:23
Posts: 466
@JosDuchIt

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

   Report Go to top

Re: Reading .xls excel files
Just can't stay away
Joined:
2009/2/9 19:32
From Brussels Belgium
Posts: 1080
@ 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

   Report Go to top

Re: Reading .xls excel files
Not too shy to talk
Joined:
2006/12/24 12:23
Posts: 466
@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)

   Report Go to top

Re: Reading .xls excel files
Just can't stay away
Joined:
2006/12/1 18:01
From Copenhagen, Denmark
Posts: 1028
@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

   Report Go to top

Re: Reading .xls excel files
Not too shy to talk
Joined:
2006/12/24 12:23
Posts: 466
@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.

   Report Go to top

Re: Reading .xls excel files
Just can't stay away
Joined:
2009/2/9 19:32
From Brussels Belgium
Posts: 1080
@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

   Report Go to top





[Advanced Search]


Powered by XOOPS 2.0 © 2001-2016 The XOOPS Project