Question

Simple Excel Plugin output

  • 25 February 2021
  • 3 replies
  • 240 views
M
Rank
Badge +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
Rank
Badge +3

These are the missing screenshots from above 

XML Produced in App Message queue

 

XML when viewed in Excel

 

A
Rank
Badge +1

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
Rank
Badge +1

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