B
blichal
Guest
Hello James, The structure of a worksheet in an an .XLSX file is pretty straight forward and simple, very similar to an HTML table with rows and cells - worksheet sheetData row cell /cell /row . . . /sheetData /worksheet Although there are a few caveats - - Office usually removes empty rows and cells so you'll need to pay attention to the r (reference/position) attribute of rows and cells nodes. slibxlsx.p adds the missing rows and cells in the beginning so it will be easier to work with the worksheet. - Values are saved differently for text, numbers and dates (besides formulas). I'll be happy to help if you have any questions. I'd also search for other solutions maybe in other languages/platforms, as was suggested. It wouldn't be too complicated to add an export XLSX file to temp-table/dataset. It would even be incredibly fast if it was written in C++ (less than 0.01 seconds). I think it's also important to support export from Excel tables instead of simply exporting form an worksheet since Excel files are usually "polluted" with peoples added remarks, calculations etc. It's definitely something I plan to add to the new version of the XLSX library. But at the moment I'm a little busy with another side project (besides my regular day job). The project is sort of a Javascript web desktop and similar in concept to ADM/SmartObjects which will also be free and open source. More to come soon.
Continue reading...
Continue reading...