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 <hannes.hirzel@gmail.com> wrote:
On 8/2/15, Ben Coman <btc@openinworld.com> 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, ЮÑий ÐиÑоненко <assargaddon@gmail.com> 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!