jjensen / lua-xlsx Goto Github PK

Hello, can you add the depend library(such as 'ziparchive') code into this project?
You know, not all person use the luarocks.

Which license? If you'll say (L)GPL, that's deal breaker.

Maybe it is not an issue

when testing, I open xlsx with 11.2MB (dimension: 30000x60), it goes to consume more than 1.2G and continue to go up, at that time ,my computer freezed,
I found the biggest consumer is lom.parse('xl/worksheets/sheet1.xml') and xmlize.xml_depth() in luaize().
It seems that parsing the whole xml at first make that problem .

While I just want to read the xlsx and store into database , could you give an example for faster and memory-conserved xlsx reader , thank you!

C:\xxx\lua53.exe: .\xlsx.lua:109: attempt to index a nil value (field '?')
stack traceback:
	.\xlsx.lua:109: in method '__load'
	.\xlsx.lua:308: in function 'xlsx.Workbook'
	...s\xxx\luaplus\Src\Modules\xlsx\tests\printxlsx.lua:6: in main chunk
	[C]: in ?

Which cell content is '=1+1'.

local filename = "C:\\Users\\Administrator\\Desktop\\test.xlsx"  --normal and existing excel file, contains 1 sheet
local xlsx = require 'xlsx' 
local workbook = xlsx.Workbook(filename)
print("total sheets=" .. workbook:GetTotalWorksheets())  --print 1 , OK
workbook:Close() -- ERROR: attempt to call method 'Close' (a nil value)

workbook:Close() got removed ?

It seems that it need other repositories including ziparchive and xmlize but I failed to compile any of them. Both of them did not provide makefile and I don't know how to do it.
Hopes help. Thank you!