It appears that the behavior of the dialog is suffering from buffering.

This is what I found on CPAN at Win32::fileOp.

"There is a little problem with the underlying function. You have to preallocate a buffer for the selected filenames and if the buffer is too small you will not get any results. I've consulted this with the guys on Perl-Win32-Users and there is not any nice solution. The default size of buffer is 256B if the options do not include OFN_ALLOWMULTISELECT and 64KB if they do. You may change the later via variable $Win32::FileOp::BufferSize."

Set your buffering to 128KB before you attempt to use the dialog. Step up your buffer size until you get the results you are seeking.

Slow down and read the guidance offered on the CPAN.

Good luck!

UPDATE: BrowserUk set the filter '*', which forced an allocation for the filter buffer (and eased the suffering from buffering). This approach forces the OS to handle the buffer allocation; However, you may want to modify the filter to '*.xls', '*.*' or some other value as a literal. No sense in wasting resources on file types you don't need.

In reply to Re: Using Win32::FileOp::OpenDialog to get multiple files by Sagacity
in thread Using Win32::FileOp::OpenDialog to get multiple files by plendid

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.