How we can transfer more than 10,000 docs to Excel via file export? Once I read that it is a problem of Lotus 123...But what is the alternative I can use? I have to process a lot of numbers.
In script, I am doing it but it is too slow if you cross more than 2000 docs...
Is there anything I am missing here?
Try creating an ASCII text file and use minimal processing in your loops that writes out to the file (i.e. process entire variable and use a PrintLN to output to the file instead of outputting one var at a time. Use a good separator and then open the file with Excel. Excel will automatically launch in import wizard.