Could we please have a PlugIn Report as CSV or XLS file?**
Hi @hajo ,
What is the purpose of your question?
It is relatively easy to import the “Plug-in report.txt” file into Excel and format it.
@P.A.T How does one access this file?
Hi, how did you do that?
What do you mean by “that” ?
After clicking the button marked in the picture above, a text file is generated that you can then import into Excel
No, I wanted to know how you did the import in Excel.
Thank you for your answer and have a nice weekend!
As you probably know, you can drag&drop the *.txt-File into Excel.
For formatting I used the “Text in columns” function.
OK, I’ve been working with this for a bit and I can’t get it to parse into columns properly. I’ve done this a lot for work before, so I’ve tried the various combinations of spaces, tabs, commas, and it just is too inconsistent. You can get it with some effort using Fixed Width, but even that took a few tries to get right. And you would manually have to repeat that every time you opened a new version
I’m going to have to agree with the original OP, that the report should be changed to a true CSV file so it can be more useful, and much easier to use.
you can also do this with a macro.
You may have to adjust some number values, for my example it fits exactly
Selection.TextToColumns Destination:=Range(“A56”), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 2), Array(36, 2), Array(72, 2), Array(108, 2), Array(126, 2) _
, Array(144, 2), Array(162, 2)), TrailingMinusNumbers:=True