trying to get list of sheets a fast as possible
Run it several times
if C.SourceFile='' then exit;
Xls := TXlsFile.Create(false);
try
Xls.VirtualMode:=true;
Xls.IgnoreFormulaText := true;
Xls.RecalcMode:=TRecalcMode.Manual;
Xls.Open(C.SourceFile);
TableCount:=Xls.SheetCount;
TablesList.Clear;
for i := 1 to TableCount do
TablesList.Add(Xls.GetSheetName(i));
finally
FreeAndNil(Xls); <<<< MEMORY IS NOT RELEASED
end;
Mike
Hi,
This is one of the resons Virtual Mode is not supported or documented in 5.0.5. As I've mentioned in the post before this one, Virtual Mode will be available in 5.0.6 to be released next week. Those leaks have been fixed and we have intensively tested it,it wasn't tested in v5.0.5.
Regards,
Adrian.
OK Thanks
Any update on this one?
Please be a little patient. Right now I am doing the last polishing to 5.1 (including reviewing the docs, adding some more demos, testing in all plattforms like firemonkey, xe, xe2 36/64, etc). I was counting to have it ready for this week, but I think it is best to publish it by the start of the next. This way I can review it more in depth, and make sure everything is in place. We've also added new functionality to virtual mode (like for example the ability to read a single sheet or only sheet names) that I think you will find useful.
Regards,
Adrian.
Just a quick note that 5.1 is finally released, and it contains the virtual mode functionality.
sorry for the delays.