Skip to main content
Question

Simple Excel Plugin output

  • February 25, 2021
  • 3 replies
  • 284 views

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

 

 

 

 

This topic has been closed for comments

3 replies

Forum|alt.badge.img+3
  • 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

 


Forum|alt.badge.img+1
  • 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.

 


Forum|alt.badge.img+1
  • 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>

 

 


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