Skip to main content
Question

Simple Excel Plugin output

  • February 25, 2021
  • 3 replies
  • 285 views
M
Do Gooder (Customer)
Forum|alt.badge.img+3

Hi I have created a Excel Report Plugin Layout which is producing an xml file containing the data that I require but when I open it in Excel I can see that there are duplicate columns (screenshot 2).

Looking at the XML (screenshot 1) it has a ExpandedColumnCount of 67 but there are actualy only 18 columns of data. I have attached the xml showing the duplicate column headers. 

Is this a problem with my .rpl file or is it something else?

 

Screenshot 1 - Part of XML file

 

The XML file (attached

 

 

 

Screenshot 2 - Excel Output

 

 

 

 

2 Attachments
    This topic has been closed for comments

    3 replies

    M
    Do Gooder (Customer)
    Forum|alt.badge.img+3
    • mbrown1892
    • Author
    • Do Gooder (Customer)
    • 5 replies
    • March 1, 2021

    These are the missing screenshots from above 

    XML Produced in App Message queue

     

    XML when viewed in Excel

     

    A
    Do Gooder (Customer)
    Forum|alt.badge.img+1
    • apawaskar
    • Do Gooder (Customer)
    • 3 replies
    • March 10, 2021

    Can you help please me . I want to output the file as Excel using Simple Excel Plugin . I have set the output method as FILE but it is not working.

     

    A
    Do Gooder (Customer)
    Forum|alt.badge.img+1
    • apawaskar
    • Do Gooder (Customer)
    • 3 replies
    • March 12, 2021

    Thanks for the replies. I tried putting the path in the file-directory tag but that did not work , but when I put the path in the file tag it works .  You need to put in the file tag as below.

    <file>\\net1\IFSExport\Fin\Test2\</file>

     

     

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings