O$816-MacOS-ExcelFormat

[jmv]

Hello Mike,


> Le 29 août 2018 à 12:03, Michael Matthews via omnisdev-en <omnisdev-en at lists.omnis-dev.com> a écrit :
> 
> But to make a correct .xlsx file, you will need the LibXl stuff that you suggest.  You will need to buy the licence from them, and then use the xComp/DLL to produce the Excel file.

I have bought the license.

My problem : the six stock exchange publishes quotes in an excel file.

I would like excel to produce an csv file by procedure inside omnis.

I know there is something like odbc to build a bridge between omnis and excel, but for the name I know nothing about it.

So I open the xls file in Excel, save it as csv file and import the data into omnis.

I am trying to do it automatically, as I have bought the LibXl stuff.

So I understand that to put a .csv extension instead of a .xls extension would work. So I will try this.

Thank You very much for your times.

Best regards,

Jean-Marc