LAE

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

Originally posted by: malcolmhartill

Started to use BRE, downloading some data from an iSeries which is being ultimately output to an delimited file (CSV).
The question is can I output directly to an Excel spreadsheet, and if I can, can it go to specific tab inside excel.
I am using BRE v4.1.5.0 Build 268.

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

Originally posted by: timonk

Hello,

There are currently under the "Experimental" category in the Core library an Input from Excel , and an Output to Excel node.

To activate experimental nodes, open your Tools--> Preferences menu, and go to the Advanced menu. (button on first tab). Check off Use Experimental Nodes.

These nodes are detailed in the Core library help, under the Experimental section. Here is an excerpt from the Output Excel node.

"Outputs data to an Excel workbook. The workbook will contain one sheet per input data set(input pin). Output is a compatible format of Excel 97/2000/XP/2003. "

I did a quick test to confirm. So you can output to separate tabs in an xls workbook.
-Each input to the Excel Output node becomes a separate sheet.
-The name of each sheet is the same as what you have named the Input on the I/O tab for the Excel Output node in the node editor.

I recommend you give these a try and see if they fit your needs.
Regards
Timon Koufopoulos
MDA Support.

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

Originally posted by: malcolmhartill

Timon
Thanks for that, managed to get the experimental bits working and outputing to a spreadsheet. I must be having a senior moment, I can't quite work out how to get it to go to a particular sheet. Do you have an example of how you acheived this.
Malcolm.

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

Originally posted by: malcolmhartill

Timon
Didn't give up and can now get the data going into a spreadsheet in a sheet with whatever name I want. The problem/feature, is that if it is an existing spreadsheet with other sheets it will trash all the other sheets, and leave the new one in it's place. Do you know how to get around this or is this working as designed.
Malcolm

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

Originally posted by: timonk

Malcom,
Unfortunately the Output Excel node currently functions in the manner you describe. It will overwrite the file it is pointed at. There is not at this time an appending capability in that particular node, either to existing sheets or new sheets. It might be possible to setup a Python node to do what you want, but it would take some work.

-Timon