Jump to content
We've recently updated our Privacy Statement, available here. ×

Excel Script to Python


Deon Mayfield

Recommended Posts

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
Link to comment
Share on other sites

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.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...