Re: [Pharo-users] Tabular: XLSX import

2015-08-21 Thread H. Hirzel
Thank you for the pointer about parsing formulas https://github.com/PerfectXL/XLParser Current status is that simple DOCX export now works https://ci.inria.fr/pharo-contribution/job/Tabular/ http://ss3.gemtalksystems.com/ss/Tabular.html http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirze

Re: [Pharo-users] Tabular: XLSX import

2015-08-17 Thread Stephan Eggermont
On 01/08/15 20:58, Юрий Мироненко wrote: Hello. Some time ago I announced Tabular , 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-con

Re: [Pharo-users] Tabular: XLSX import

2015-08-14 Thread H. Hirzel
Problem solved so far http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.63.mcz Now found out how to parse inline strings with the SAX parser I had to include t in registeredElements ^ #(row c v t) and add a method t_characters: aString self cell dat

Re: [Pharo-users] Tabular: XLSX import

2015-08-14 Thread H. Hirzel
P.S. Code in http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.59.mcz On 8/14/15, H. Hirzel wrote: > I am now looking for the place in the SAX parser where the cell > content is assigned. > > > Test script (debug it) > > |wbk wsheet wimported cell fname4| > fname4 := 'TabularCon

Re: [Pharo-users] Tabular: XLSX import

2015-08-14 Thread H. Hirzel
I am now looking for the place in the SAX parser where the cell content is assigned. Test script (debug it) |wbk wsheet wimported cell fname4| fname4 := 'TabularConstructed4Exported.xlsx'. wbk := TabularWorkbook new. self assert: (wbk worksheets isEmpty).

Re: [Pharo-users] Tabular: XLSX import

2015-08-14 Thread H. Hirzel
On 8/2/15, Ben Coman wrote: > Cool. I might have a use for this soon. > cheers -ben Hello Ben The standard to implement is huge. We are dealing with a subset. Example test documents I consider using are here http://www.openoffice.org/sc/testdocs/index.html (all which are labeled 'XML') What

Re: [Pharo-users] Tabular: XLSX import

2015-08-14 Thread H. Hirzel
e 's' (for shared string) or 'inline' for inline string. >>> But what is 'v'? >>> >>> In the case of a inline string I have for example >>> >>> >>> >>> abcdefghijklmnopqrstuvwxyz 1234567890

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread stepharo
.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.pha

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread H. Hirzel
t; In the case of a inline string I have for example >> >> >> >> abcdefghijklmnopqrstuvwxyz 1234567890 >> >> >> I'd like to compile a short summary of the meaning of these one-letter >> tags. >> >> &g

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread H. Hirzel
t; > >> Vincent >> >> > -Message d'origine- >> > De : Pharo-users [mailto:pharo-users-boun...@lists.pharo.org] >> De >> la part >> > de H. Hirzel >> > Envoyé : jeudi 13 août 2015 12:39 &

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread H. Hirzel
sers [mailto:pharo-users-boun...@lists.pharo.org] De > la part > > de H. Hirzel > > Envoyé : jeudi 13 août 2015 12:39 > > À : Any question about pharo is welcome > > Objet :

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread Vincent BLONDEAU
Indeed that is better idea! Thanks Ben, Vincent -Message d'origine- De : Pharo-users [mailto:pharo-users-boun...@lists.pharo.org] De la part de Ben Coman Envoyé : jeudi 13 août 2015 19:13 À : Any question about pharo is welcome Objet : Re: [Pharo-users] Tabular: XLSX import O

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread Ben Coman
> > À : Any question about pharo is welcome > > Objet : Re: [Pharo-users] Tabular: XLSX import > > > > On 8/13/15, Blondeau Vincent wrote: > > > > > I think the access to an empty cell should

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread Blondeau Vincent
> -Message d'origine- > De : Pharo-users [mailto:pharo-users-boun...@lists.pharo.org] De la part > de H. Hirzel > Envoyé : jeudi 13 août 2015 15:06 > À : Any question about pharo is welcome > Objet : Re: [Pharo-user

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread H. Hirzel
abularObject? Regards Hannes > > > -Message d'origine- > > De : Pharo-users [mailto:pharo-users-boun...@lists.pharo.org] De > la part > > de H. Hirzel > > Envoyé : jeudi 13 août 2015 08:51 > > À : Any question about ph

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread Blondeau Vincent
ailto:pharo-users-boun...@lists.pharo.org] De la part > de H. Hirzel > Envoyé : jeudi 13 août 2015 12:39 > À : Any question about pharo is welcome > Objet : Re: [Pharo-users] Tabular: XLSX import > > Answering my own question:

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread Blondeau Vincent
> de H. Hirzel > Envoyé : jeudi 13 août 2015 08:51 > À : Any question about pharo is welcome > Objet : Re: [Pharo-users] Tabular: XLSX import > > Hello Jurij and Vincent > > I am working on extending the

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread H. Hirzel
l >>>>>> >>>>>> self assert: ((ws col: 100 row: 100) data =''). >>>>>> >>>>>> "probably should return an empty string" >>>>>> >>>>>> >>>

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread H. Hirzel
mpty string" >>>>> >>>>> >>>>> Comments of others are invited as well. >>>>> >>>>> -- Hannes >>>>> >>>>> On 8/9/15, Юрий Мироненко wrote: >>>>>

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread H. Hirzel
st a note that Tabular needs XMLParser and >>>>>> >>> XMLWriter packages on >>>>>> >>> http://ss3.gemtalksystems.com/ss/Tabular.html. >>>>>> >> >>>>>> >> are you implying that there

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread H. Hirzel
> 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

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread H. Hirzel
. >>>> >>>> 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 documentati

Re: [Pharo-users] Tabular: XLSX import

2015-08-13 Thread H. Hirzel
ideo: >>> 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 direct

Re: [Pharo-users] Tabular: XLSX import

2015-08-12 Thread H. Hirzel
.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'o

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread Юрий Мироненко
ro-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 > > T

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread Юрий Мироненко
; > > 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-user

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread Юрий Мироненко
x27;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! > >>>> > >&g

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread H. Hirzel
s://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. >>

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread H. Hirzel
igurationOfTabular directly. >>> >>> Best, >>> Vincent >>> >>> -Message d'origine- >>> De : Pharo-users [mailto:pharo-users-boun...@lists.pharo.org] De la part >>> de >>> H. Hirzel >>> Envoyé : same

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread stepharo
5 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

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread H. Hirzel
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.

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread H. Hirzel
ular 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 : R

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread Vincent BLONDEAU
nOfTabular 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 Configura

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread H. Hirzel
gt;>> >>>>> 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 a

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread H. Hirzel
gt;>> 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/

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread stepharo
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 p

Re: [Pharo-users] Tabular: XLSX import

2015-08-08 Thread H. Hirzel
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 >

Re: [Pharo-users] Tabular: XLSX import

2015-08-04 Thread Юрий Мироненко
eed 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] Ta

Re: [Pharo-users] Tabular: XLSX import

2015-08-04 Thread Blondeau Vincent
ers [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

Re: [Pharo-users] Tabular: XLSX import

2015-08-02 Thread Юрий Мироненко
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 : > Hi, > > it would be sooo cool to have a confi

Re: [Pharo-users] Tabular: XLSX import

2015-08-02 Thread Юрий Мироненко
I'm in active development/improvement of this importer just now. So just be sure that you checked comments to the releases uploaded before actually using it. 2015-08-02 11:07 GMT+03:00 Ben Coman : > Cool. I might have a use for this soon. > cheers -ben > > On Sun, Aug 2, 2015 at 2:58 AM, Юрий Ми

Re: [Pharo-users] Tabular: XLSX import

2015-08-02 Thread Esteban Lorenzano
Hi, it would be sooo cool to have a configuration in the catalog… Esteban > On 01 Aug 2015, at 20:58, Юрий Мироненко wrote: > > Hello. > Some time ago I announced Tabular > , some effort to make a tool > for spreadsheets import/export. > > Th

Re: [Pharo-users] Tabular: XLSX import

2015-08-02 Thread Ben Coman
Cool. I might have a use for this soon. cheers -ben On Sun, Aug 2, 2015 at 2:58 AM, Юрий Мироненко wrote: > Hello. > Some time ago I announced Tabular, some effort to make a tool for > spreadsheets import/export. > > This is short notice: Vincent Blondeau have added XLSX import functionality! >

[Pharo-users] Tabular: XLSX import

2015-08-01 Thread Юрий Мироненко
Hello. Some time ago I announced Tabular , 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