oilcan Posted April 9, 2011 Posted April 9, 2011 I am trying to run a simple script to do a search on our FM database based on the values in a column in an excel spreadsheet using Scribe. The document loads without any error, but when I go into my loop to parse the values by the row I get this error from my error feedback scripting: Reading values is not supported for the file Shipments!A2 For the record I am trying to read a value from a sheet entitled Shipments, first column skipping column label and on down the column. This error plays on each iteration of my loop (A2 updates accordingly, A3, etc). I cannot see any error in my syntax as being a problem...it's pretty straightforward. What am I missing here? Here is the top half of my loop to show what I'm trying to do: Set Variable [$i; Value:1] Loop Set Variable [$i; Value:$i + 1] Set Variable [$readRow; Value:ScribeDocReadValue ( "Shipments!A" & $i )] If [not $readRow] Show Custom Dialog ["An Error Occurred"; ScribeLastError] End If Exit Loop If [isEmpty ($readRow)] ...do stuff... End Loop
oilcan Posted April 9, 2011 Author Posted April 9, 2011 think I found the problem, the excel file was of type .xls which I saved as .xlsx - this appears to work now...
Recommended Posts
This topic is 4975 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now