November 10, 2016 at 7:33 am
Hey guys, I've been tasked with automating an excel sheet which has 2 tabs. One called "Raw Data" is where I'm loading the data and there's another tab that has excel calculations on the data in the raw tab. I have a template for the excel file where I deleted all of the rows in the Raw Data tab. I have the package copying the excel file from a template folder over to the folder where I load it and concat the date on the end of the filename then I load the Raw Data tab. My problem is that the tab with the calculations aren't changing to show the values from the new data in the Raw Data tab. Is there a way to do this?
Thanks
November 10, 2016 at 8:07 am
dndaughtery (11/10/2016)
Hey guys, I've been tasked with automating an excel sheet which has 2 tabs. One called "Raw Data" is where I'm loading the data and there's another tab that has excel calculations on the data in the raw tab. I have a template for the excel file where I deleted all of the rows in the Raw Data tab. I have the package copying the excel file from a template folder over to the folder where I load it and concat the date on the end of the filename then I load the Raw Data tab. My problem is that the tab with the calculations aren't changing to show the values from the new data in the Raw Data tab. Is there a way to do this?Thanks
Presumably you're not happy with 'Open the Excel file and hit the 'calculate' button'?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply