Hello
Can you give an example how to load an Excel-File with ProgressBar?
Sincerely Peter
Hi,
There is no direct support for showing a progress bar, mainly
because opening a file should normally be fast enough, and adding extra
code to do a feedback will just slow down normal file loading.
But
you can show some spinning progress animator while loading just by
opening the file in a different thread, and showing the animation in the
main thread while the other does the work.
If you look at the
"custom preview" demo, you will see an example of how to show a progress
bar when exporting to pdf for example. The same code can apply to
showing a pregress when opening the file, but FlexCel doesn't have a
"TProgress" for opening, so you can't show real progress like "100000
cells read from 10000000".
Hello
Thank you for the answer.
It is a pity that it does not exist a Progessbar. Would it be possible to create one?
I have Excel-Files with 100.000 of Lines and loading can take some minutes.
Sincerely
Peter
As said, you can load the file in a different thread, and in the main thread keep some "loading" animation. The only thing we could add to that is some estimate information that you could show in the loading screen (loaded 10,000 rows of 10000,0000 rows...), but it might not always work: Sometimes the total number of rows is not saved in the file, so we don't know how many rows are left still to load.
In any case, I can see to have a Loadding progress information added. You would still need to run it in a different thread, but you would have some information to show in the progress.