Import Unpopulated Excel Data
I am writing a script that will import an excel sheet and perform various cleaning and analysis actions on it. However, the excel sheets that will be imported are updated daily and have 20,000+ rows that will only populate when you refresh it in excel. I have not been able to find a way to refresh this data sheet in the excel import wizard or in JMP without going into the excel sheet and refreshin...