AnsweredAssumed Answered

Excel Import Issue

Question asked by fmdataweb on Jan 11, 2018
Latest reply on Jan 13, 2018 by fmdataweb

I receive an Excel spreadsheet from a supplier monthly and have a scripted process to import this which has been working fine for years (the structure doesn't change). I've just received their latest spreadsheet and I'm getting an error when running the script - invalid import error. Looking at the spreadsheet everything appears to be the same, so I tried importing this manually and I can see what the issue is:

 

Screen Shot 2018-01-12 at 8.08.31 am.png

There's another worksheet above Sheet1 that it should be importing from called ArrayValuesWorksheet which is causing the problem. However in Excel I can't see this worksheet to delete it:

 

Screen Shot 2018-01-12 at 8.08.42 am.png

 

Anyone seen this before or know how I can delete this invisible worksheet so my script will continue to work again?

Outcomes