Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2013
    Posts
    4

    Question Unanswered: .xlsx file generation in Ab Initio

    HI
    I am able to generate a .xls file successfully using "Write Excel" component in Ab Initio , & same able to read properly after transferring to local drive.
    Now I am just changing the output file extension from .xls to .xlsx in the graph & this time too the graph is completed successfully but while opening the file it is saying "File format or File extension is not valid", Why?
    What else I need to do in order to read the .xlsx properly?
    FYI, I am using Ab Initio 3.1.2 version.
    Please help me ASAP!!!
    Last edited by Soumalya; 11-16-13 at 13:58.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Save it as xls, open in Excel and then save as xlsx.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Nov 2013
    Posts
    4

    Question Re: .xlsx file generation in Ab Initio

    No, There will have a problem in case of 66000+ data & I need all the data in single worksheet, In this case, I can't generate it to .xls, rite? It will throw error.

  4. #4
    Join Date
    Nov 2013
    Posts
    4

    Question Re:.xlsx file generation in Ab Initio

    There will have a in case of 66000+ data. I can't generate it in .xls. It will throw error. Therefore I need to know the process to generate .xlsx in Ab Initio & the file should be readable.

  5. #5
    Join Date
    Nov 2013
    Posts
    4

    Question Re:.xlsx file generation in Ab Initio

    There will have a problem in case of 66000+ data. I can't generate it in .xls. It will throw error. Therefore I need to know the process to generate a file in .xlsx format in Ab Initio & the file should be readable.

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    This is not an Ab Initio forum. I would call Ab Initio support, check their website, or try Google.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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