When write table is asked to write to a spreadsheet file that does not exist, it creates the file. Then when Excel opens the newly created file for the first time, the display looks like this:
It appears that nothing has been written, until the user realizes that he's looking at an empty Sheet1 tab, while the values have been written to the Results tab.
Preferably, the file should be created without the Sheet1 tab. If there is no way to get rid of the Sheet1 tab, then it would still be an improvement to have the spreadsheet file open with the Results tab showing.
When
write tableis asked to write to a spreadsheet file that does not exist, it creates the file. Then when Excel opens the newly created file for the first time, the display looks like this:It appears that nothing has been written, until the user realizes that he's looking at an empty Sheet1 tab, while the values have been written to the Results tab.
Preferably, the file should be created without the Sheet1 tab. If there is no way to get rid of the Sheet1 tab, then it would still be an improvement to have the spreadsheet file open with the Results tab showing.