Best practices for importing Excel files with functions in them

Best practices for importing Excel files with functions in them

  
What is the strategy for importing an Excel spreadsheet where some columns contain functions instead of static data?  Do you simply store the static data in entities and run functions in the tables?  Or do you create some kind of structure to hold the function data if you want to be able to reference it without having to code that function every time?

Thx.

Craig
Hi Craig.
If the excel has only one sheet you will have no problem, Outsystems platform already interpret functions and replace by the correct values.

check this
http://www.outsystems.com/NetworkForums/ViewTopic.aspx?Topic=Import-calculated-fields-from-Excel

Regards,
Carlos Rocha