[Pharo-dev] Excel export with Tabular

[Sven Van Caekenberghe]

Hi Hans-Martin,

This is great. I use Tabular too and was missing active development/maintenance. It would be very good to see this project move forward. It is quite important/useful in enterprise contexts.

Thx,

Sven

PS: where did you commit the changes ? any chance of moving it to GitHub (too) ?

Hello folks,
I have a need for creating excel files with more than 3 worksheets, so I
took the Tabular code and beefed up the exporter a little. It does handle
more worksheets now, uses XMLWriter to create all the ZIP members, and is
properly named now (the class was called TabularXSLXExport, note swapped S
and L).
Some tests have been added, there are a number of items that I plan to to as
- Add (possibly limited) support for styles and formulas which I
specifically need for the project I'm working on so I could write files with
the desired layout and functionality.
- Add support for reading more aspects of XLSX files, preferrably as much as
needed to be able to read and write most files without loss.
- Add rendering, maybe at the basic morphic level, maybe using something
else as I'm not really up-to-date regarding the developments in Pharo.
- Add formula evaluation.
- Add editing capabilites to have a fully functional spreadsheet (really far
off).
Cheers,
Hans-Martin
--
Sent from: http://forum.world.st/Pharo-Smalltalk-Developers-f1294837.html

[Eric Gade]

I want to second support for this effort. I had a freelance project a few
months back that had a need to generate formatted Excel documents from
external API data. It also needed an easy to use GUI for it's users. At the
time I desperately wanted to use Pharo (since RAD tools on personal
computers have sadly become an endangered species). Instead I was forced
to make an Electronic app.

In short, there is a real need for this out there and I feel like it goes
understated.

Post by Sven Van Caekenberghe
Hi Hans-Martin,
This is great. I use Tabular too and was missing active
development/maintenance. It would be very good to see this project move
forward. It is quite important/useful in enterprise contexts.
Thx,
Sven
PS: where did you commit the changes ? any chance of moving it to GitHub (too) ?

Hello folks,
I have a need for creating excel files with more than 3 worksheets, so I
took the Tabular code and beefed up the exporter a little. It does handle
more worksheets now, uses XMLWriter to create all the ZIP members, and is
properly named now (the class was called TabularXSLXExport, note swapped

S

and L).
Some tests have been added, there are a number of items that I plan to

to as

- Add (possibly limited) support for styles and formulas which I
specifically need for the project I'm working on so I could write files

with

the desired layout and functionality.
- Add support for reading more aspects of XLSX files, preferrably as

much as

needed to be able to read and write most files without loss.
- Add rendering, maybe at the basic morphic level, maybe using something
else as I'm not really up-to-date regarding the developments in Pharo.
- Add formula evaluation.
- Add editing capabilites to have a fully functional spreadsheet (really

far

off).
Cheers,
Hans-Martin
--

http://forum.world.st/Pharo-Smalltalk-Developers-f1294837.html

[Norbert Hartl]

Is there any progress on this? Can you tell the S3 url you are using?

Do you need help to put it on github?

Norbert

I put it on ss3 because I'm not yet familiar with the way Pharo uses github. Will look into it later.
I'm unsure how git repositories are used in the Pharo context. Do you use them just like you use git normally (i.e. I
use my git repository, you use yours and send me pull requests etc...). Are there any catalog systems that allow one to
register and find projects? This whole issue has always been a bit confusing in the Squeak/Pharo world due to the number
of different options.
Cheers,
Hans-Martin

Post by Sven Van Caekenberghe
Hi Hans-Martin,
This is great. I use Tabular too and was missing active development/maintenance. It would be very good to see this
project move forward. It is quite important/useful in enterprise contexts.
Thx,
Sven
PS: where did you commit the changes ? any chance of moving it to GitHub (too) ?

Hello folks,
I have a need for creating excel files with more than 3 worksheets, so I
took the Tabular code and beefed up the exporter a little. It does handle
more worksheets now, uses XMLWriter to create all the ZIP members, and is
properly named now (the class was called TabularXSLXExport, note swapped S
and L).
Some tests have been added, there are a number of items that I plan to to as
- Add (possibly limited) support for styles and formulas which I
specifically need for the project I'm working on so I could write files with
the desired layout and functionality.
- Add support for reading more aspects of XLSX files, preferrably as much as
needed to be able to read and write most files without loss.
- Add rendering, maybe at the basic morphic level, maybe using something
else as I'm not really up-to-date regarding the developments in Pharo.
- Add formula evaluation.
- Add editing capabilites to have a fully functional spreadsheet (really far
off).
Cheers,
Hans-Martin
--
Sent from: http://forum.world.st/Pharo-Smalltalk-Developers-f1294837.html

[V***@lamresearch.com]

Hi Norbert,

I just converted the repository to git few days ago: https://github.com/VincentBlondeau/Tabular
I missed to inform you on the mailing list. A thing that is now done!

Thanks,
Vincent

-----Original Message-----
From: Pharo-dev <pharo-dev-***@lists.pharo.org> On Behalf Of Norbert Hartl
Sent: Wednesday, November 28, 2018 8:53
To: Pharo Dev <pharo-***@lists.pharo.org>
Subject: Re: [Pharo-dev] Excel export with Tabular

Is there any progress on this? Can you tell the S3 url you are using?

Do you need help to put it on github?

Norbert

I put it on ss3 because I'm not yet familiar with the way Pharo uses github. Will look into it later.
I'm unsure how git repositories are used in the Pharo context. Do you
use them just like you use git normally (i.e. I use my git repository,
you use yours and send me pull requests etc...). Are there any catalog
systems that allow one to register and find projects? This whole issue has always been a bit confusing in the Squeak/Pharo world due to the number of different options.
Cheers,
Hans-Martin

Post by Sven Van Caekenberghe
Hi Hans-Martin,
This is great. I use Tabular too and was missing active
development/maintenance. It would be very good to see this project move forward. It is quite important/useful in enterprise contexts.
Thx,
Sven
PS: where did you commit the changes ? any chance of moving it to GitHub (too) ?

Hello folks,
I have a need for creating excel files with more than 3 worksheets,
so I took the Tabular code and beefed up the exporter a little. It
does handle more worksheets now, uses XMLWriter to create all the
ZIP members, and is properly named now (the class was called
TabularXSLXExport, note swapped S and L).
Some tests have been added, there are a number of items that I plan
- Add (possibly limited) support for styles and formulas which I
specifically need for the project I'm working on so I could write
files with the desired layout and functionality.
- Add support for reading more aspects of XLSX files, preferrably as
much as needed to be able to read and write most files without loss.
- Add rendering, maybe at the basic morphic level, maybe using
something else as I'm not really up-to-date regarding the developments in Pharo.
- Add formula evaluation.
- Add editing capabilites to have a fully functional spreadsheet
(really far off).
Cheers,
Hans-Martin
--
https://urldefense.proofpoint.com/v2/url?u=http-3A__forum.world.st_P
haro-2DSmalltalk-2DDevelopers-2Df1294837.html&d=DwIFAg&c=RWI7EqL8K9l
qtga8KxgfzvOYoob76EZWE0yAO85PVMQ&r=kIZIYXBAA3fhM7P5HOuTC5w6mnEApTfXP
Tq3lR34ZiY&m=EPbX5TzJOZHDpUVDsq332xD1gqtrIVoQbAznjKQPUdA&s=dW_yz-tezHKlcwFvYmnlCbnMBIEdRMUYhIUjKF9XZSc&e=

[Ben Coman]

I put it on ss3 because I'm not yet familiar with the way Pharo uses
github. Will look into it later.
I'm unsure how git repositories are used in the Pharo context. Do you use
them just like you use git normally (i.e. I
use my git repository, you use yours and send me pull requests etc...).

Yes. Exactly like that.

cheers -ben