ExcelDecode(Container{;Sheet})

Idea created by Fred(CH) on Mar 13, 2018
    Active
    Score3
    • Benjamin Fehr
    • Hemant Kumar Patel
    • Fred(CH)

    The idea :

    In the same way than we have now for text files with TextDecode calc function, it would be very handy to have a text convertion form an Excel file stored in a container field.

     

    Uses :

    The specific case that brought me to hope a such calc is following : we want to import data upon night automatically from a ftp server. Using Insert From Url, we are able to insert the file in the container field using a server side script; however, there is no way to get the data contained in the Excel file. If the Export Field Content step was not a client activity only, it would be easy to then to use it following by an import records step : Insert File + Export Field Content + Import Records.

     

    However, what about a very more direct access to Excel data ?