For the shared strings in sheet1.xml for example <c r="A1" s="1" t="s">
what do the attributes s and t stand for? <row r="1" customFormat="false" ht="35.05" hidden="false" customHeight="false" outlineLevel="0" collapsed="false"> <c r="A1" s="1" t="s"> <v>0</v> </c> </row> <row r="5" customFormat="false" ht="79.85" hidden="false" customHeight="false" outlineLevel="0" collapsed="false"> <c r="B5" s="1" t="s"> <v>1</v> </c> </row> On 8/13/15, H. Hirzel <hannes.hir...@gmail.com> wrote: > 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. >>>>>> >>>>> >>>>>> >>> >>>>>> >> >>>>>> >> >>>>>> >> >>>>>> > >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> >
