http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.52.mcz 47 test run, 37 passes.
Currently I have a fixed string TabularXSLXExport>>sharedStrings_xml ^'<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"; count="1" uniqueCount="1"> <si><t> </t></si> </sst>'. How far can I safely ignore constructing a proper xl/sharedStrings.xml in the archive? On 8/13/15, H. Hirzel <hannes.hir...@gmail.com> wrote: > Found a useful summary about for generating XLSX files > > http://stackoverflow.com/questions/6055430/how-to-create-xlsx-file-without-using-any-excel-library-php/18820405#18820405 > > On 8/13/15, H. Hirzel <hannes.hir...@gmail.com> wrote: >> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.50.mcz >> >> Another question is about the >> >> #colspan: property of a cell >> >> >> (wsheet cells at: 1 @ 1) colspan: 1. >> >> actually makes cell A1 span 2 columns. >> >> Is this OK according to the standard? >> >> >> >> >> TabularXLSXExportTest>>testExport7 >> >> | wbk wsheet | >> wbk := TabularWorkbook new. >> self assert: (wbk worksheets isEmpty). >> >> wsheet := TabularWorksheet new. >> wsheet >> at: 1 @ 1 putData: 'aaa'; >> at: 3 @ 1 putData: 'ccc'. >> (wsheet cells at: 1 @ 1) colspan: 1. >> >> wbk worksheets add: wsheet. >> TabularXSLXExport workbook: wbk fileName: fname7. >> >> "manual inspection shows that the exported file is fine" >> "But is the colspan command fine? Add a colspan test to TabularCell" >> >> >> On 8/13/15, H. Hirzel <hannes.hir...@gmail.com> wrote: >>> Hello Jurij and Vincent >>> >>> I am working on extending the export function (export of several >>> worksheets). >>> >>> For this I am adding some more tests currently and I'd like to have >>> your feedback on some of the basic functions regarding initial values. >>> >>> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.49.mcz >>> (41 tests run, 32 passes) >>> >>> in particular on class TabularWorksheetTest (3 tests) >>> >>> We have for example >>> >>> >>> Test which passes >>> >>> testCellsReadingEmptyCell0 >>> "accessing a cell without data" >>> >>> ws col: 1 row: 1 putData: 11. >>> ws col: 2 row: 1 putData: 21. >>> >>> self assert: (ws col: 1 row: 1) data equals: 11. >>> self assert: (ws col: 2 row: 1) data equals: 21. >>> >>> self assert: ((ws col: 3 row: 1) isNil). "Is this OK to have >>> nil returned?" >>> >>> >>> >>> Test which does not pass >>> >>> testCellsReadingEmptyCell >>> >>> self assert: ((ws col: 100 row: 100) data =''). >>> >>> "probably should return an empty string" >>> >>> >>> Comments of others are invited as well. >>> >>> -- Hannes >>> >>> On 8/9/15, Юрий Мироненко <assargad...@gmail.com> wrote: >>>> If your are using at least Pharo 4.0, you can use the catalog browser >>>> to >>>> load the ConfigurationOfTabular directly. >>>> >>>> You have only publish it for MetaRepoForPharo50, so it didn't work for >>>> Pharo 4. >>>> BUt, thanks to your explanations, I just have published in >>>> MetaRepoForPharo40 as well - works like charm! >>>> >>>> 2015-08-08 12:45 GMT+03:00 Vincent BLONDEAU < >>>> vincent.blond...@polytech-lille.net>: >>>> >>>>> Hi, >>>>> >>>>> I added the dependencies to PharoExtras/XMLWriter and XMLParser. >>>>> I didn't add the dependencies before because I used Tabular with >>>>> Moose, >>>>> and Moose already loads these dependencies... >>>>> >>>>> Now it should work. I created the new 0.2 release with the required >>>>> dependencies. >>>>> >>>>> By the way, I used Versionner to create the configuration. I don't >>>>> know >>>>> if >>>>> there is a documentation but there is a video: >>>>> https://www.youtube.com/watch?v=cFRJDuWL-Q0 >>>>> >>>>> It is a very fast tool to manage your projects! >>>>> >>>>> If your are using at least Pharo 4.0, you can use the catalog browser >>>>> to >>>>> load the ConfigurationOfTabular directly. >>>>> >>>>> Best, >>>>> Vincent >>>>> >>>>> -----Message d'origine----- >>>>> De : Pharo-users [mailto:pharo-users-boun...@lists.pharo.org] De la >>>>> part >>>>> de H. Hirzel >>>>> Envoyé : samedi 8 août 2015 10:34 >>>>> À : Any question about pharo is welcome >>>>> Objet : Re: [Pharo-users] Tabular: XLSX import >>>>> >>>>> If I do >>>>> >>>>> ConfigurationOfXMLWriter load >>>>> >>>>> then >>>>> >>>>> TabularExperimentalExport writeTestFile >>>>> >>>>> is fine generating an Excel file. >>>>> >>>>> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.27.mcz >>>>> >>>>> I am currently exploring the code and trying to figure out how it >>>>> works. >>>>> >>>>> --Hannes >>>>> >>>>> On 8/8/15, H. Hirzel <hannes.hir...@gmail.com> wrote: >>>>> > I understand that Юрий Мироненко asks how to construct his >>>>> > ConfigurationOfTabular file >>>>> > >>>>> > http://ss3.gemtalksystems.com/ss/Tabular.html >>>>> > >>>>> > So I pointed him to the Pharo By Examples book 2 Chapter 9 Managing >>>>> > Projects with Metacello >>>>> > >>>>> > >>>>> > The Tabular project needs a XMLWriter class. I assume the regular >>>>> > pharoExtras is fine. I do not know. >>>>> > >>>>> > I am just looking at the code to see how the reading and writing of >>>>> > MSOffice files, Excel in this particular case, is done so far. >>>>> > >>>>> > For reading a TabularSAXParser is included in the package. Probably >>>>> > not necessary. >>>>> > >>>>> > I moved it out here >>>>> > http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.26.mcz >>>>> > >>>>> > Hannes >>>>> > >>>>> > >>>>> > >>>>> > On 8/8/15, stepharo <steph...@free.fr> wrote: >>>>> >> >>>>> >> >>>>> >> Le 8/8/15 09:11, H. Hirzel a écrit : >>>>> >>> What about >>>>> >>> http://rmod.lille.inria.fr/deepIntoPharo/index.html >>>>> >>> >>>>> >>> p. 163 depending on a project without Metacello description p. >>>>> >>> 164, >>>>> >>> depending on a project with a Metacello configuration >>>>> >>> >>>>> >>> In the mean time just a note that Tabular needs XMLParser and >>>>> >>> XMLWriter packages on >>>>> >>> http://ss3.gemtalksystems.com/ss/Tabular.html. >>>>> >> >>>>> >> are you implying that there is no expression of dependencies and >>>>> >> that >>>>> >> in addition it depend on a different XML Parser/Writer than >>>>> >> pharoExtras ones? >>>>> >> >>>>> >> Stef >>>>> >>> >>>>> >>> Some class comments are welcome as well :-) >>>>> >>> >>>>> >>> I understand that I can read Excel files and that you just started >>>>> >>> to check out how to write them? >>>>> >>> >>>>> >>> --Hannes >>>>> >>> >>>>> >>> On 8/4/15, Юрий Мироненко <assargad...@gmail.com> wrote: >>>>> >>>> Thank you Vincent. >>>>> >>>> Some things is much clearer for me now. >>>>> >>>> >>>>> >>>> *It's shame on me that I lost all this Metacello progress, >>>>> >>>> especially taking into account I was on the ESUG conference where >>>>> >>>> it was presented. >>>>> >>>> It >>>>> >>>> was my only conference unfortunately.* >>>>> >>>> >>>>> >>>> I see that you already started this job: you added >>>>> >>>> ConfigurationOfTabular. >>>>> >>>> What I really want to do with this configuration: add >>>>> >>>> dependencies >>>>> >>>> to XMLParser and XMLWriter packages. Can you help with this, >>>>> >>>> please? >>>>> >>>> >>>>> >>>> 2015-08-04 17:19 GMT+03:00 Blondeau Vincent >>>>> >>>> <vincent.blond...@worldline.com> >>>>> >>>> : >>>>> >>>> >>>>> >>>>> Hi, >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> To add a configuration in the catalog, first you should have a >>>>> >>>>> configuration for your project. You can create it with the >>>>> >>>>> versionner if needed. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Second, you have to add some methods adding meta-description to >>>>> >>>>> your project. The versionner do it for you: in the configuration >>>>> >>>>> list, select your project, do a right click and select add >>>>> >>>>> catalog >>>>> >>>>> methods. >>>>> >>>>> >>>>> >>>>> It creates all the mandatory methods for the catalog. You now >>>>> >>>>> have >>>>> >>>>> to fill them (look at the class side of the configuration). >>>>> >>>>> >>>>> >>>>> Finally, commit your configuration on your repo and on the >>>>> >>>>> MetaRepoForPharo30/40/50 depending where your project is >>>>> >>>>> working. >>>>> >>>>> >>>>> >>>>> The link is here: >>>>> >>>>> http://smalltalkhub.com/#!/~Pharo/MetaRepoForPharo50 >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Once published, your project will be in the catalog in the image >>>>> >>>>> (Tools>catalog browser) and on the web >>>>> >>>>> http://catalog.pharo.org/. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Tell me if you need help to do it, >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Cheers, >>>>> >>>>> >>>>> >>>>> Vincent >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> *De :* Pharo-users [mailto:pharo-users-boun...@lists.pharo.org] >>>>> >>>>> *De la part de* ???? ????????? >>>>> >>>>> *Envoyé :* dimanche 2 août 2015 10:25 *À :* Any question about >>>>> >>>>> pharo is welcome *Objet :* Re: [Pharo-users] Tabular: XLSX >>>>> >>>>> import >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> It looks like I need some guidance to understand contemporary >>>>> >>>>> packaging/deployment/versioning system. I know it exists, but I >>>>> >>>>> don't know details. Can you kick me in the right direction? >>>>> >>>>> Maybe >>>>> >>>>> some link? >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> 2015-08-02 11:21 GMT+03:00 Esteban Lorenzano >>>>> >>>>> <esteba...@gmail.com>: >>>>> >>>>> >>>>> >>>>> Hi, >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> it would be sooo cool to have a configuration in the catalog… >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Esteban >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On 01 Aug 2015, at 20:58, Юрий Мироненко <assargad...@gmail.com> >>>>> >>>>> wrote: >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Hello. >>>>> >>>>> >>>>> >>>>> Some time ago I announced Tabular >>>>> >>>>> <http://ss3.gemtalksystems.com/ss/Tabular.html>, some effort to >>>>> >>>>> make a tool for spreadsheets import/export. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> This is short notice: Vincent Blondeau have added XLSX import >>>>> >>>>> functionality! >>>>> >>>>> It's also mostly proof-of-concept now, but even at this stage >>>>> >>>>> it's >>>>> >>>>> quite usable. >>>>> >>>>> >>>>> >>>>> Thanks, Vincent! >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> ------------------------------ >>>>> >>>>> >>>>> >>>>> Ce message et les pièces jointes sont confidentiels et réservés >>>>> >>>>> à >>>>> >>>>> l'usage exclusif de ses destinataires. Il peut également être >>>>> >>>>> protégé par le secret professionnel. Si vous recevez ce message >>>>> >>>>> par erreur, merci d'en avertir immédiatement l'expéditeur et de >>>>> >>>>> le >>>>> >>>>> détruire. L'intégrité du message ne pouvant être assurée sur >>>>> >>>>> Internet, la responsabilité de Worldline ne pourra être >>>>> >>>>> recherchée >>>>> >>>>> quant au contenu de ce message. Bien que les meilleurs efforts >>>>> >>>>> soient faits pour maintenir cette transmission exempte de tout >>>>> >>>>> virus, l'expéditeur ne donne aucune garantie à cet égard et sa >>>>> >>>>> responsabilité ne saurait être recherchée pour tout dommage >>>>> >>>>> résultant d'un virus transmis. >>>>> >>>>> >>>>> >>>>> This e-mail and the documents attached are confidential and >>>>> >>>>> intended solely for the addressee; it may also be privileged. If >>>>> >>>>> you receive this e-mail in error, please notify the sender >>>>> >>>>> immediately and destroy it. >>>>> >>>>> As >>>>> >>>>> its integrity cannot be secured on the Internet, the Worldline >>>>> >>>>> liability cannot be triggered for the message content. Although >>>>> >>>>> the sender endeavours to maintain a computer virus-free network, >>>>> >>>>> the sender does not warrant that this transmission is virus-free >>>>> >>>>> and will not be liable for any damages resulting from any virus >>>>> >>>>> transmitted. >>>>> >>>>> >>>>> >>> >>>>> >> >>>>> >> >>>>> >> >>>>> > >>>>> >>>>> >>>>> >>>>> >>>> >>> >> >
