Focal Point
[SOLVED] Caster Burst Excel Compoud

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4437066096

August 07, 2018, 08:38 AM
JACQUETL
[SOLVED] Caster Burst Excel Compoud
hello a new question please

I need via caster in burst mode (dynamic distribution list) to send 1 EXCEL file with 2 tabs

Caster generates 1 file per tab and per recipient, I want only one file with 2 tabs

is it possible, macgyver technique or other ^^

This message has been edited. Last edited by: JACQUETL,


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH
August 07, 2018, 02:41 PM
MartinY
Using XLSX template file it's possible.

TABLE FILE
...
BY BURST_VALUE
...
ON TABLE HOLD AS SHEET1 FORMAT XLSX TEMPLATE XLSXTEMPLATE.xltx SHEETNUMBER 1
...
END
-RUN

TABLE FILE
...
BY BURST_VALUE
...
ON TABLE PCHOLD         FORMAT XLSX TEMPLATE SHEET1.xlsx       SHEETNUMBER 2
...
END
-RUN



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
August 08, 2018, 02:52 AM
JACQUETL
Great ! Thanks MartinY

Bu i have another problem.
I must integrated image on my xls file.

Image don't work with xlsx template file.
Have you idea ?


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH
August 08, 2018, 08:03 AM
MartinY
quote:

Image don't work with xlsx template file.
Have you idea ?

Your question have already been asked (by you) and answered

See : Excel Template Image


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
August 08, 2018, 08:13 AM
JACQUETL
Thanks Martin

but i have a problem
If i resume

I want burst coupound excel with image

1> xls template don't work with image
2> xls coupound excel work only with xls template


it's a headache Sweating

I can not cover the need
Confused


in any case thanks for the returns


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH
August 08, 2018, 08:21 AM
MartinY
Sometime you hit a dead end. But there is a NFR to support image in a XLSX template.
Just have to wait to have it available in a future release...


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
August 08, 2018, 08:22 AM
JACQUETL
Thank you MartinY


I just have to explain that to end users ;-)


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH
August 08, 2018, 08:39 AM
MartinY
GL Big Grin

Note : Edit your first post, go to the subject and add [SOLVED] at the beginning or see Forum Guidelines and FAQs for other "status" description


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007