Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4975 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

think I found the problem, the excel file was of type .xls which I saved as .xlsx - this appears to work now...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.