Message 1 of 3
GoExcel Probelm

Not applicable
05-27-2015
10:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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