IBM i

 View Only
  • 1.  Writing xml excel or docx docunent template

    Posted Wed April 27, 2022 09:09 PM

    How can I populate an excel xml template or docx Ms word template besides using CGIDEV2 which I am not allow to dowload in my company



  • 2.  RE: Writing xml excel or docx docunent template

    Posted Thu April 28, 2022 09:45 AM
    Hello, not exactly sure what you want to do with the resulting output (email? save to IFS or network drive? or just open the spreadsheet when you run the process?) but Db2 Web Query (http://ibm.biz/db2webqueryi) does have the ability to have a "report" that points to an excel template to generate an appropriate spreadsheet with data from your data source (Db2 files, SQL views/SPs/Statements - even non Db2 databases). You may want to reach out to the web query team at QU2@us.ibm.com to see if perhaps you already own a license of it and/or discuss the technique used to do this with the template.

    ------------------------------
    Doug Mack
    mackd@us.ibm.com
    ------------------------------



  • 3.  RE: Writing xml excel or docx docunent template

    IBM Champion
    Posted Thu April 28, 2022 10:23 AM

    What can you download?  There is nothing standard on the IBM i that I can think of that can do this.  There are various options in PHP, Python, node.js, Java, etc. but all would require downloading packages.

    Your company do understand that CGIDEV2 was written by IBM right?  I



    ------------------------------
    Jon Paris
    ------------------------------



  • 4.  RE: Writing xml excel or docx docunent template

    IBM Champion
    Posted Thu April 28, 2022 12:11 PM
    As Jon says there are options. 

    This is similar to the Word Merge question you asked over on midrange.com.

    Without downloading and installing something you aren't getting anything Excel related :-)


    ------------------------------
    Richard Schoen
    ------------------------------



  • 5.  RE: Writing xml excel or docx docunent template

    Posted Thu April 28, 2022 04:05 PM
    The reason for this is we have a welcome letter that will be used as a template to be send by email to every new customer, so we would like to populate the template from a program and send it by email, in regard to excel we got a template excel report which is used  like a list of new customer we would like to populate the template from a program too and yes this is a question that I made in midrange too






  • 6.  RE: Writing xml excel or docx docunent template

    Posted Thu April 28, 2022 04:42 PM
    Jose, it's not about understanding the reasons why you want to do this. We all understand that, and even if we didn't, the point is:

    Your company has to make a choice. They can choose EITHER to stick to the no-download policy OR make it possible for you to work with Word and Excel. Well, I guess there is one other alternative, which is to wait for you to independently build, from scratch, yourself, the necessary programming that is already in CGIDEV2 (or other downloadable alternatives).






  • 7.  RE: Writing xml excel or docx docunent template

    IBM Champion
    Posted Thu April 28, 2022 05:34 PM
    After pondering this a bit more, maybe Jose is trying to say that he needs a method to generate merged documents using templates. And then after merging he wants the final document emailed rather than downloaded. 

    Either way the answer is pretty much the same. There are ways. 

    However I would probably suggest not emailing .docx or .xlsx files.  Many companies are leery about opening these types of documents for security reasons.

    Maybe generating PDF and then emailing the PDF docs is the way. 


    ------------------------------
    Richard Schoen
    ------------------------------