Magnus, I don't know that the issue is specific to the plugin. A couple of weeks ago I downloaded some files with a .XLS file extension from a vendor who uses SalesForce. They could not be opened by anything except xcel. Even google sheets which is probably the most robust option for importing anything.
This lead me to learn more about .XLS than I really wanted to know, find that this format didn't conform to the 'traditional' .XLS format, and still not fully understand why it's the way it is. In the case of the files I was dealing with there is a pretty easy fix: open it in a text editor. Regular .XLS files are standard XML. The ones I had were more like HTML and the actual data are in a table defined by HTML tags. Strip everything from the start of the file to <table> and everything after </table>. Which is to say just copy the table. Then I used an online web page to convert the HTML table to a .CSV and I was on my way. This format would be easy-ish to read directly with 4D once you look at how it's built. I probably won't 'cause I only have to do this once a year. The IT guy with the vendor said they were limited by what salesForce would give them when we talked about it. I doubt salesForce is the only entity using this format and perhaps this is what you are dealing with. On Tue, Feb 7, 2017 at 1:39 AM, 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? > -- Kirk Brooks San Francisco, CA ======================= ********************************************************************** 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] **********************************************************************
