Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: MS excel writer not working with template

  1. #1

    Default MS excel writer not working with template

    Hi,
    I just download the latest PDI and found that excel writer actually is not working as you want to use template.(I also tried PDI 5.0 as well)

    here's the error msg:
    2014/11/29 12:14:20 - Microsoft Excel Writer.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Error opening new file
    2014/11/29 12:14:20 - Microsoft Excel Writer.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2014/11/29 12:14:20 - Microsoft Excel Writer.0 - Tempate Sheet: MyTemplate not found, aborting


    Dose anybody know how to fix this issue?

    Cheers

  2. #2

    Default

    Quote Originally Posted by lifehealthcare View Post
    Hi,
    I just download the latest PDI and found that excel writer actually is not working as you want to use template.(I also tried PDI 5.0 as well)

    here's the error msg:
    2014/11/29 12:14:20 - Microsoft Excel Writer.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Error opening new file
    2014/11/29 12:14:20 - Microsoft Excel Writer.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2014/11/29 12:14:20 - Microsoft Excel Writer.0 - Tempate Sheet: MyTemplate not found, aborting


    Dose anybody know how to fix this issue?

    Cheers
    Hi,

    It works like a charm, If you use it properly.
    For your reference you can take a look to the attached transformation.
    Attached Files Attached Files

  3. #3

    Default

    Thank you mt25.
    You are right. It works fine now.

  4. #4
    Join Date
    May 2015
    Posts
    1

    Default

    Excel Writer not able to find template sheet.
    2015/05/21 09:39:08 - Microsoft Excel Writer 2.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Error opening new file
    2015/05/21 09:39:08 - Microsoft Excel Writer 2.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2015/05/21 09:39:08 - Microsoft Excel Writer 2.0 - Tempate Sheet: file:///C:/Users/sinhavin/Desktop/BO-Queries/Pentaho Data mart/pdi-ce-5.3.0.0-213/data-integration/Transformations/issues.xls not found, aborting
    2015/05/21 09:39:08 - Microsoft Excel Writer 2.0 -
    2015/05/21 09:39:08 - Microsoft Excel Writer 2.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.prepareNextOutputFile(ExcelWriterStep.java:720)

    How to pass template sheet?
    I am able to pass the template file correctly but not the template sheet.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.