Luacom uses more than 2G of memory when it reads excel files with more than 6000 lines
The test code is as follows:
oExcel = luacom.CreateObject("Excel.Application")
oExcel.ActiveWorkbook.Sheets(1):Select () --Let's say the data is in the first sheet
sheetcache={}
local i=0
while true do
i=i+1
local row = oExcel.Activesheet.Rows(i).Value2[1]
if #row==0 then break end
sheetcache[i]=row
end
moteus
commented
4 years ago
Luacom uses more than 2G of memory when it reads excel files with more than 6000 lines The test code is as follows: oExcel = luacom.CreateObject("Excel.Application") oExcel.ActiveWorkbook.Sheets(1):Select () --Let's say the data is in the first sheet sheetcache={} local i=0 while true do i=i+1 local row = oExcel.Activesheet.Rows(i).Value2[1] if #row==0 then break end sheetcache[i]=row end