Focal Point
[SOLVED] Caster Burst Excel Compoud
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 , August 08, 2018 08:44 AM 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, PDFIn 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, PDFIn 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
I can not cover the need
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, PDFIn 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
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, PDFIn Focus since 2007