Results 1 to 3 of 3

Thread: Info on generating Xls from iSeries

  1. #1
    Experienced Forum Member
    Join Date
    Mar 2009
    Location
    italy
    Posts
    166
    Rep Power
    578

    Info on generating Xls from iSeries

    Hi all

    i need to generate a Xls file so that when the user open it, he has already configured the autofilter; i usually use the SQL2JXL command (http://www.mcpressonline.com/tips-t...tml) to generate the Xls . Doe's anyone kwon if is it possible to do that with this command or also with other command ??



    Thanks in advance

  2. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Posts
    1,000,000
     

  3. #2
    Driver of cars, eater of food jamief's Avatar
    Join Date
    Jan 2004
    Location
    Belvidere, IL - United States of America
    Age
    49
    Posts
    9,416
    Rep Power
    12605

    Re: Info on generating Xls from iSeries

    you can write your own..
    I prefer to write XML and have office open in Excel.
    http://www.code400.com/forum/showthr...-read-as-EXCEL
    All my answers were extracted from the "Big Dummy's Guide to the As400"
    and I take no responsibility for any of them.

    www.code400.com

  4. #3
    Analyst
    Join Date
    Jan 2005
    Location
    Levittown, PA
    Age
    50
    Posts
    332
    Rep Power
    1314

    Re: Info on generating Xls from iSeries

    I would go the route of Jamie, just using CGIDEV2 to handled the XML template.
    Your friends list is empty!

  5. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Age
    21
    Posts
    1,000,000
     

Facebook Comments


Similar Threads

  1. auto generating column
    By EddieBanz in forum SQL
    Replies: 2
    Last Post: December 12th, 2011, 12:49 AM
  2. Generating SQL from Table
    By FaStOnE in forum RDP/RDi/WDSC - Tips & Tricks
    Replies: 3
    Last Post: January 14th, 2010, 03:38 AM
  3. Generating random caracters or digits
    By 400genius in forum COBOL
    Replies: 2
    Last Post: March 6th, 2008, 11:16 AM
  4. HELP: Generating sequence #
    By rpgKnight in forum DB2
    Replies: 4
    Last Post: November 28th, 2007, 02:07 PM
  5. get info from AS400 iSeries through vb6?
    By mapperkids in forum PC programming as it relates to Iseries
    Replies: 11
    Last Post: March 30th, 2007, 03:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •