LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Excel Version with 4.5.3.0?

    Employee
    Posted 06-21-2012 10:53

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Cindy

    We have just recently upgraded to the 4.5.3.0 version of the software. We use Excel often to publish and share our result info with our internal customers. When we save to Excel, we are limited to the older Excel version of 65K+ rows. I am not familiar with the publishing nodes, but if I used the output Excel node, can I specify the .xlsx file type and save larger files as Excel?


  • 2.  RE: Excel Version with 4.5.3.0?

    Employee
    Posted 06-22-2012 05:54

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Tim Meagher

    Hi,

    Unfortunately this functionality is not available within the LAE at the moment
    We are aware of this limitation and are planning on adding this in the future.

    I know that this will not be in the upcoming 4.5.4 release.
    Outside of that, I can't say exactly when this will be available, except to say that it is functionality that is being considered for releases after 4.5.4.


    Regards,
    Tim.


  • 3.  RE: Excel Version with 4.5.3.0?

    Employee
    Posted 06-22-2012 07:27

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Cindy

    Ouch, Can you describe the most effective way to output a larger file and open with Excel. Output as CSV or Text?


  • 4.  RE: Excel Version with 4.5.3.0?

    Employee
    Posted 06-22-2012 07:34

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Cindy

    That's interesting since we had this ability in the ancient version we were using.


  • 5.  RE: Excel Version with 4.5.3.0?

    Employee
    Posted 06-22-2012 08:53

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mmarinelli

    Originally posted by: Cindy
					

    Ouch,  Can you describe the most effective way to output a larger file and open with Excel.  Output as CSV or Text?
    Hello Cindy,

    You have correctly identified CSV as the best way to output large data sets for use with Excel. If you use the Output Delimited node to create a file with the .csv extension, and set the field delimiter to "," and the record delimiter to "\n" (no quotes for either), you will output a file which can then be opened directly in Excel.

    Mark