Filelist with URL path

[#1]

Hello,

Is it possible to browse files using Filelist and an http path?

Something like:

for each File in filelist ('http://myserver/directory/*.xls')

   Load *

   FROM $(File)

          (biff, embedded labels, table is Sheet1$);

next File

I tried and I do not get an error but no data either althought it works fine with a local path:

for each File in filelist ('D:\directory\*.xls')

   Load *

   FROM $(File)

          (biff, embedded labels, table is Sheet1$);

next File

Thanks,

jc

[#2]

is that what you want...?

for each vExt in 'xls'

for each vFoundFile in filelist( '\\myserver\directory'& '\*.'& vExt)

Tab1:

Load

*

from $(vFoundFile) (biff, embedded labels, table is data$);;

Next vFoundFile;

Next vExt;

//all the files should have "data" sheet

i've just checked and it works for me:)

[nstefaniuk]

Hi.

In my opinion you can't because the HTTP protocol doesn't support it.

If you request this URL http://files.ubuntu-gr.org/ubuntistas/pdfs/ you will get a HTML page, not a collection of files. Then you can read this HTML page and detect tag <tr><td><a> ...</a></td></tr> but it's not easy.

And the most important: you need to have no index.html in your directory, else you can't get the file listing. In fact it's a 0 level of security for web : if you don't have the exact URL you can't find a file.