Excel Script to Python

[Deon Mayfield]

I have an excel file that I use to copy/paste well data into from a Spotfire project. A script in excel runs and then I link the results back to Spotfire. Is there a way to translate the excel script into Python, so I can do everything in Spotfire and eliminate excel

[Khushboo Rabadia]

You can start by checking from where the data is getting sourced and try to setup database connection in spotfire either through dsn/connector/information links. Once the data is imported, you can check in execl macro what it actually does , is it replacing any columns values or pivoting/unpivoting data etc, Try to setup those exact steps if feasible through transformations then if there is something complex that cannot be achieved using built in operations, try using iron python script.