Smalltalk › Pharo › Pharo Smalltalk Developers

Excel export with Tabular

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

7 messages Options

Hans-Martin

Excel export with Tabular

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
time allows:
- 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

Sven Van Caekenberghe-2

Re: Excel export with Tabular

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) ?

> On 11 Nov 2018, at 22:16, Hans-Martin <[hidden email]> wrote:
>
> 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
> time allows:
> - 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
>

darth-cheney

Re: Excel export with Tabular

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.

On Sun, Nov 11, 2018, 16:50 Sven Van Caekenberghe <[hidden email]> wrote:

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) ?

> On 11 Nov 2018, at 22:16, Hans-Martin <[hidden email]> wrote:
>
> 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
> time allows:
> - 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
>

Hans-Martin

Excel export with Tabular

In reply to this post by Sven Van Caekenberghe-2

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

Am 11. November 2018 10:50:40 nachm. schrieb Sven Van Caekenberghe <[hidden email]>:

> 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) ?
>
>> On 11 Nov 2018, at 22:16, Hans-Martin <[hidden email]> wrote:
>>
>> 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
>> time allows:
>> - 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
>>

NorbertHartl

Re: 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

> Am 12.11.2018 um 22:41 schrieb Hans-Martin Mosner <[hidden email]>:
>
> 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
>
> Am 11. November 2018 10:50:40 nachm. schrieb Sven Van Caekenberghe <[hidden email]>:
>
>> 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) ?
>>
>>> On 11 Nov 2018, at 22:16, Hans-Martin <[hidden email]> wrote:
>>>
>>> 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
>>> time allows:
>>> - 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
>>>
>
>
>
>

Vincent.Blondeau

Re: Excel export with Tabular

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 <[hidden email]> On Behalf Of Norbert Hartl
Sent: Wednesday, November 28, 2018 8:53
To: Pharo Dev <[hidden email]>
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

> Am 12.11.2018 um 22:41 schrieb Hans-Martin Mosner <[hidden email]>:
>
> 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
>
> Am 11. November 2018 10:50:40 nachm. schrieb Sven Van Caekenberghe <[hidden email]>:
>
>> 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) ?
>>
>>> On 11 Nov 2018, at 22:16, Hans-Martin <[hidden email]> wrote:
>>>
>>> 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 time allows:
>>> - 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:
>>> 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=
>>>
>
>
>
>

attachment0 (501 bytes) Download Attachment

Ben Coman

Re: Excel export with Tabular

In reply to this post by Hans-Martin

On Tue, 13 Nov 2018 at 05:42, Hans-Martin Mosner <[hidden email]> wrote:

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