LAE

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

Originally posted by: ahines

Hello, Again!

I've been looking for a bit for good resource for how to publish to excel. I use it now for just telling it to put an excel file somewhere at the end of a graph, but I really need to know how to manipulate the node so that it places the data into a preformed template where I have the proper conditional formatting and cell formatting, and summary formulas already in place. Does anyone have, or has seen anything like that? Thanks!

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

Originally posted by: ahines

So, after tinkering with this for days, after so much research, I have it "working". Of course this led to a new issue- Even though my data is of types double and INT, any column of numerical data that I send to excel is treated as if it is stored as text and therefore must be converted to number in order for my conditional formatting and summary formula to work. Does anyone know if there is any way to prevent this from occurring? Ideally I would like to run the graph and email out the output in final form without having to manipulate any of the published excels.

The columns in the template are pre-formatted for how I want the data to look when it is dropped in (I.E. Currency, percentages, comma-style with no decimals, etc.)

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

Originally posted by: simon.wilby

Hi there,

can I ask which lae / lal release you're using? we did some work around cell formatting and the output excel node in June (LAL release number 36 which was available for LAE 5.1,6.0 and 6.1)

Regards

Simon

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

Originally posted by: ahines

Hi, Simon! Thanks for replying! To answer your question, I am using 6.1. This may end up being a very simple answer, but I've not really found anything up to date to use as examples, just lot's of talk about the upcoming changes that were probably referring to 6.0/6.1 or one of it's predecessors.

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

Originally posted by: simon.wilby

ok, so if you're on lae 6.1 then you will have the latest version of that particular node. Have you attempted using the PreserveCellStyles and the FormatOutput parameters?

From your post I would suggest the FormatOutput paramter is the one that you want. From the tooltip:

Allowable options:
From BRD - The data in the output Excel spreadsheet is formatted to match the data types in the input BRD
From Template - The data in the output Excel spreadsheet uses the same format as specified in the template file
No Formatting - All data is output as text
True - Performs the same action as the "From BRD" choice. This option is for backward compatibility.
False - Performs the same as the "No Formatting" choice. This option is for backward compatibility.
Optional parameter. The default value for this setting is "From BRD".

if that doesn't help would you be able to share any files such as the template excel file and your lae graph/example?

Regards

Simon