Magnus, Has the format of the files changed from .XLS to .XLSX? If that's the case, then I don't think the plugin you're using will work. We use Pluggers XL plugin for these files. If you would like to send me a sample file, I'll take a look at it for you.
Pat On 7 February 2017 at 09:39, Magnus Torell <[email protected]> wrote: > I am using XLS 11 for importing stock level from another system. (Many > Thanks) > I just receive excel files (.xls). It has been working for a year since I > started. > However the files that started to come a week ago will not be read with XLS > II > They open just fine in Excel, but the most simple commands with XLS II seem > to fail? > I just do following to see a difference between old and new files. > Ever since beginning with XLS II I have had to do a trick, and that is to > open and save > the file with excel -Mac excel 2011- on my computer. That seems to have > triggered > something that makes the file recognized by XLS II plugin) > > C_TIME($dref) > $dref:=Open document($vName2;"*";Read mode) > If (OK=1) > $filePath:=Document > CLOSE DOCUMENT($dref) > $wb:=XLS Load ($filePath) > $sheet:=1 > $cols:=XLS Get total columns ($wb;$sheet) > $rows:=XLS Get total rows ($wb;$sheet) > > With the failing files I get no $cols or $rows at all. > Files seems identical to me. What can be the reason? > The supplier have automatic generated xls files and they do not know of any > changes. > > What can be the change? Any ideas are appreciated. > > Best Regards > > Magnus Torell > > > > -- > View this message in context: http://4d.1045681.n5.nabble. > com/XLS-II-plugin-tp5750156.html > Sent from the 4D Tech mailing list archive at Nabble.com. > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** -- ************************************************* CatBase - The Database Publishing Solution tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky ************************************************* ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
