Nice help, expressions is a nice way, instead of a loop. It’s to think like excel formulas.
I’m having a problem then, when i process a datatble with some columns with expressions; when i do a “Write Range” to a workbook, the header name of this columns is strabge! (original_name + expression_detail), i woul prefer just the original_name on the header.
Do you know how to do this?
By now we are using a workarround; to save de datatable on CSV and then load from the CSV to a new Datatable to write the Excel then; but is not a nice way i think.