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.  Output excel

    Employee
    Posted 05-24-2016 04:12

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

    Originally posted by: ThomasT

    Hi Guys.

    I have this output excel node that used to work just fine.
    It has some inputs that is supposed to be outputted on two different sheets, this is handled by the XML.
    There is also a template to format the output as a price list.
    The node seem to run and says that the node has run successfully but when i try to open the excelfile that has been outputted it says "We found some problem in 'Telia Wholesale SP Gen udland'. Do you want us to recover as much as we can? if you trust the source of this workbook click yes".
    If i click yes the file seem OK.
    The problem is that i want to email this file, so i dont want the receiver to experience that there is something wrong with the file.

    Any idea?


    node:Output_Excel_3
    bretype:core::Output Excel
    editor:sortkey=574434c0270f2072
    input:@49e34a5e55c82040/=Cat.40fd2c74676e03c3
    input:574434c73b134801/out1=Filter_4.40fd2c7420761db6
    prop:File=N:\Afregning\Udlandstrafik\Priser til Wholesale\Telia Wholesale SP GenUdland.xlsx
    prop:OutputSpec=<<EOX
    <workbook>
    <sheet inputIndex="1" outputIndex="1" dataStartRow="19" dataStartColumn="2" outputHeaderRow="false"/>
    <sheet inputIndex="2" outputIndex="2" dataStartRow="2" dataStartColumn="1" outputHeaderRow="false"/>
    </workbook>
    EOX
    prop:TemplateInputFile=N:\Afregning\Udlandstrafik\ Priser til Wholesale\Telia Wholesale SP GenUdland Ny skabelon 2016 - 2.xlsx
    editor:XY=1700,390
    end:Output_Excel_3


  • 2.  RE: Output excel

    Employee
    Posted 05-24-2016 06:15

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

    Originally posted by: ThomasT

    OK... Just ran the node in another graph, and there it works fine, so it probably is something wrong with the graph i am working in.


  • 3.  RE: Output excel

    Employee
    Posted 05-24-2016 06:23

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

    Originally posted by: ThomasT

    And finally i found out that excel cant cope with all the characters i want to put in one single cell, so i guess that I cant blame Lavastorm for that :-)