LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: svimes

I assume the answer is no but let's see:

a) I create output data in lavastorm
b) I write this to an excel output, using an excel template, in a data input sheet in that excel template
c) the excel template has some calculations on another sheet that uses the data input
d) I want to extract the results of the excel calculation back into lavastorm

*** Calculations in step c) cannot be recoded into Lavastorm - that will not be accepted as a solution by the client ***

Issue is is that excel will not refresh without opening. Is there a way that Lavastorm can force a refresh either at point b) or d)?

Thanks....

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

What are the calculations that are done on the other sheet?
It may take some work, but there are very few calculations (other than displaying a chart) that LAE could not handle.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: svimes

Hi - thanks for reply but as per my post doing the calculations in LAE is not an option. It could be multiplying by one, emit * or creating a mandelbrot. It doesn't matter as the client will not accept the xls calcs being done in LAE.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Sorry about that.. I mis-read your original post.
If you are running the Desktop version of LAE - you could do some python or java coding to open the workbook, refresh and save it.
But, if you're working with an enterprise (linux) version of LAE, that's not going to work.

===========
A starting point to process excel with python is here:
http://community.lavastorm.com/threa...t=python+excel