Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: ThomasTHi 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