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
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 <pharo-dev@fam-mosner.de> 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
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 <sven@stfx.eu> 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 <pharo-dev@fam-mosner.de> 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
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 <sven@stfx.eu>:
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 <pharo-dev@fam-mosner.de> 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
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 <pharo-dev@fam-mosner.de>:
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 <sven@stfx.eu>:
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 <pharo-dev@fam-mosner.de> 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
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-bounces@lists.pharo.org> On Behalf Of Norbert Hartl Sent: Wednesday, November 28, 2018 8:53 To: Pharo Dev <pharo-dev@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
Am 12.11.2018 um 22:41 schrieb Hans-Martin Mosner <pharo-dev@fam-mosner.de>:
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 <sven@stfx.eu>:
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 <pharo-dev@fam-mosner.de> 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=
On Tue, 13 Nov 2018 at 05:42, Hans-Martin Mosner <pharo-dev@fam-mosner.de> 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
participants (7)
-
Ben Coman -
Eric Gade -
Hans-Martin -
Hans-Martin Mosner
-
Norbert Hartl -
Sven Van Caekenberghe -
Vincent.Blondeau＠lamresearch.com