Jump to content
Sign in to follow this  
amallison

Scribe: Reading from a written Excel file

Recommended Posts

I'm having problems reading data back from a file I have just written to with Scribe.

I load a file from a container.

Write to the fields with Scribe.

Save it to another container.

I then (have another button that ) queries this new file for some totals.

It returns empty values.

Though If I save the file to the desktop, open it and when I close it, it asks me to save it (though I make no changes), so I do.

I then put it back in the container and I am able to get the totals with Scribe.

Is it because it isn't closing/saving the file correctly?

Any suggestions why this is?

Thanks in advance.

Share this post


Link to post
Share on other sites

I know we are in correspondence via email Andrew but for the benefit of others I'll summarize the issue here.

The problem here is with writing fields to an Excel file and then attempting to get calculated cells dependent on these newly written cells prior to opening the file in Excel. When Scribe writes values to the cells it does not currently cause any calculations in other related cells to fire. Excel causes this to fire automatically upon opening/saving the document (depending on settings). It would be a fairly complicated feature to build this into Scribe and there are no plans currently to do so.

The best workaround to this currently is to write an AppleScript (Mac) to automate the open/save/close of the file.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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