GoExcel Probelm

GoExcel Probelm

Anonymous
Not applicable
411 Views
2 Replies
Message 1 of 3

GoExcel Probelm

Anonymous
Not applicable

Hello everyone I am having a vary frustrating issue. For some reason my code has stopped working. It is simply opening an excel document to get a set of numbers for a W section.

GoExcel.Open("N:\GCB Platform Generator\PLATFORM\Reference Documents\SS sizing.xlsx")
GoExcel.FindRow("SS sizing.xlsx", "Wsection Sizes", "Name", "=", W_Section)
W_d = GoExcel.CurrentRowValue("d")
W_tw=GoExcel.CurrentRowValue("tw")
W_bf=GoExcel.CurrentRowValue("bf")
W_tf=GoExcel.CurrentRowValue("tf")
Parameter("W-section:1", "W_d")=W_d
Parameter("W-section:1", "W_tw")=W_tw
Parameter("W-section:1", "W_tf")=W_tf
Parameter("W-section:1", "W_bf")=W_bf
GoExcel.FindRow("SS sizing.xlsx", "Angle Sizes", "Name", "=", A_Size)
Parameter("AngleBraceWidth:1", "Angle_Size")=GoExcel.CurrentRowValue("Length")
Parameter("AngleBraceWidth:1", "Angle_Thickness")=GoExcel.CurrentRowValue("Thickness")
Parameter("AngleBraceLength:1", "Angle_Size")=GoExcel.CurrentRowValue("Length")
Parameter("AngleBraceLength:1", "Angle_Thickness")=GoExcel.CurrentRowValue("Thickness")
GoExcel.Close

 

It keeps giving me an error of cant find column "Name" any help would be greatly appreciated

0 Likes
412 Views
2 Replies
Replies (2)
Message 2 of 3

Anonymous
Not applicable

GoExcel: Could not match the column title: "Name"

 

 

That is the exact error

0 Likes
Message 3 of 3

awatt
Advocate
Advocate

I suspect the open command.  I found this in the help files:

 

When no sheet name is specified, "Sheet1" is assumed.

GoExcel.Open("Spreadsheet.xls")
0 Likes