Tabular: XLSX import

> 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).
>
> wsheet := TabularWorksheet new.
> wsheet
> at: 1 @ 1 putData: 'abc 11';
> at: 2 @ 1 putData: 'def 21';
> at: 3 @ 1 putData: 'ghi 31'.
> wbk worksheets add: wsheet.
> TabularXSLXExport workbook: wbk fileName: fname4.
>
> wimported := XLSXImporter import: (FileLocator home / fname4 ) .
> cell := ((wimported worksheetNamed: 'Sheet1') at: 1@1).
>
> Put a halt into
> TabularWorksheet>>at:putCell:
>
> to come near the place. The cell attributes are there (inline string
> in this case)
>
> But I did not find the exact place where the cell content  'abc 11' is
> assigned.
>
> Any help?
>
> --Hannes
>
> On 8/14/15, H. Hirzel <[hidden email]> wrote:
>> On 8/2/15, Ben Coman <[hidden email]> 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 we have so far in the tabular package is quite usable, depending
>> on the project.
>>
>> My interest for next steps are
>>
>> a. get round trip :
>>       1. create tabular model
>>       2. export workbook
>>       3. import workbook
>>     working fine.
>>     (the issue is inline string parsing currently but I will soon be
>> there)
>>
>> b. cell styles
>>
>> c. multiple worksheets on export (currently limited to one with a fix
>> name; import
>>    can deal with several worksheets in a workbook)
>>
>> -- Hannes
>>
>>
>>
>>
>>> On Sun, Aug 2, 2015 at 2:58 AM, Юрий Мироненко <[hidden email]>
>>> 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-concept now, but even at this stage it's
>>>> quite
>>>> usable.
>>>>
>>>> Thanks, Vincent!
>>>
>>>
>>
>

> P.S. Code in
> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.59.mcz
>
> On 8/14/15, H. Hirzel <[hidden email]> 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 := 'TabularConstructed4Exported.xlsx'.
>> wbk := TabularWorkbook new.
>> self assert:  (wbk worksheets isEmpty).
>>
>> wsheet := TabularWorksheet new.
>> wsheet
>> at: 1 @ 1 putData: 'abc 11';
>> at: 2 @ 1 putData: 'def 21';
>> at: 3 @ 1 putData: 'ghi 31'.
>> wbk worksheets add: wsheet.
>> TabularXSLXExport workbook: wbk fileName: fname4.
>>
>> wimported := XLSXImporter import: (FileLocator home / fname4 ) .
>> cell := ((wimported worksheetNamed: 'Sheet1') at: 1@1).
>>
>> Put a halt into
>> TabularWorksheet>>at:putCell:
>>
>> to come near the place. The cell attributes are there (inline string
>> in this case)
>>
>> But I did not find the exact place where the cell content  'abc 11' is
>> assigned.
>>
>> Any help?
>>
>> --Hannes
>>
>> On 8/14/15, H. Hirzel <[hidden email]> wrote:
>>> On 8/2/15, Ben Coman <[hidden email]> 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 we have so far in the tabular package is quite usable, depending
>>> on the project.
>>>
>>> My interest for next steps are
>>>
>>> a. get round trip :
>>>       1. create tabular model
>>>       2. export workbook
>>>       3. import workbook
>>>     working fine.
>>>     (the issue is inline string parsing currently but I will soon be
>>> there)
>>>
>>> b. cell styles
>>>
>>> c. multiple worksheets on export (currently limited to one with a fix
>>> name; import
>>>    can deal with several worksheets in a workbook)
>>>
>>> -- Hannes
>>>
>>>
>>>
>>>
>>>> On Sun, Aug 2, 2015 at 2:58 AM, Юрий Мироненко <[hidden email]>
>>>> 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-concept now, but even at this stage it's
>>>>> quite
>>>>> usable.
>>>>>
>>>>> Thanks, Vincent!
>>>>
>>>>
>>>
>>
>

> On 01/08/15 20:58, Юрий Мироненко 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.
>
> You might be interested in this work by a.o. @Felienne:
> https://github.com/PerfectXL/XLParser
>
> Stephan
>
>
>
>