Excel Sheet not found Error.

[emilda.chiuye]

Hello There

This is quite bizarre, the excel worksheet was working fine before I renamed it from "Sheet1" to "New Welds"

I have tried everything from removing spaces between the words placing a number 1 at the end eg "NewWelds1"

I started a whole new spreadsheet and left it as the default "Sheet1" still inventor refuses to co-operate.

Everything was just fine before I renamed the sheet.

I have attached a snippet of the error message in hopes of someone out there understanding exactly what

Inventor is saying to me.

Regards

Emilda

[A.Acheson]

How are you calling the excel sheet through ilogic or is it a linked excel sheet to retrieve parameters? Please post the ilogic code if used. 

[emilda.chiuye]

Thanks for the response,

Oh yes, ofcourse, I have provided  snippets

xlsPath = "D:\INVENTOR iLogic\Tubes.xlsx"

WELD_AT_TUBE_C_Inlet = GoExcel.CellValue(xlsPath, "NewWelds1", "B17")
FCW1_TUBE_C_INLET = GoExcel.CellValue(xlsPath, "NewWelds1", "B18")

[emilda.chiuye]

Allow me to add that this is a third sheet in the workbook. 

When I was troubleshooting and started a new sheet I referenced the default "Sheet1" in hopes of Inventor recognizing a single sheet in the work book only, alas, that did not solve the issue.

[A.Acheson · Accepted solution]

I was only able to reproduce the error if the excel sheet was missing or mislabeled. Perhaps also if the excel sheet isn't closed fully or has not been saved since the last edit it could throw this error too. 

xlsPath = "C:\Desktop\New folder\Test.xlsx"
GoExcel.DisplayAlerts = False

WELD_AT_TUBE_C_Inlet = GoExcel.CellValue(xlsPath, "NewWelds1","A2")
MessageBox.Show(WELD_AT_TUBE_C_Inlet, "Title")

WELD_AT_TUBE_D_Inlet = GoExcel.CellValue(xlsPath, "NewWelds2","A2")
MessageBox.Show(WELD_AT_TUBE_D_Inlet, "Title")

GoExcel.Close
GoExcel.DisplayAlerts = True

 What version of inventor are you using? Are you able to simply open and close a file and see it open in windows and close? 

[emilda.chiuye]

Thanks a mil, indeed, the excel spreadsheet was missing. Why can't Inventor just say Error: "Xlsx missing" instead of

misleading me with a sheet not found message. 

Blame Inventor for my shortcomings. hahha.

[A.Acheson]

Yes unfortunately I wouldn't rely on the error messages being too useful. In this case it is correct it cannot find the sheet but it did not say it couldn't find the workbook / file first. You can either use good old fashioned detective work by steeping through the code with message box or check windows to ensure the file is opening and exists etc

Or maybe build in this snippet if there is a chance the excel book is moving around. 

If(System.IO.File.Exists(xlsPath)) Then
	'Enter excel processing here
Else
	MessageBox.Show("Error Finding Path", "iLogic")
End If

[hkeny]

Hi all, I am getting the same error. Except my .xlsx file is not missing? I have it saved in my file path that i am calling out in the code. 

Any clue for a fix here? 

[WCrihfield]

Just guessing here, but have you tried using that 'excelFilePath' variable within the 'GoExcel.CellValues()' call, instead of a separate String containing just the file name?  I know the error seems to be about the sheet name, and not the file name, but just trying to cover one of the steps in the 'process of elimination'.  Also, not sure if capitalization is important for the sheet name, but is 'BOM' capitalized differently in the Excel file, or is it possible that there is a 'space' in the tab name in the Excel (can be hard to see) maybe?

[hkeny]

Thank you @WCrihfield, that seemed to have done the trick, I declared the file path as a String variable but never used it. It is odd because the code seemed to work just fine before I brought the file containing the code into Vault.