Export Data to Excel

Caroline

Hi there,

I am using notepad ++ mainly to compare CRIMS codes between two 2 Codes. I would like to export the result of the comparison to excel (since i have an RPA running on the excels) Can you please provide any information if an export of results to excel is possible and if so how to go about it?
Thank you

Mark Olson

@Caroline
This is definitely not a functionality in base Notepad++, and I seriously doubt that a plugin exists that would help you.

You would be better off looking for some tool unrelated to Notepad++ to help you, but that’s outside the scope of this forum.

EDIT: I don’t know if “CRIMS codes” are text documents, but if they are, you could use the ComparePlus plugin to compare them side by side. That plugin is great, probably my single most used plugin.

PeterJones

@Caroline ,

I am going to echo @Mark-Olson’s sentiment, but with a lot more wordy detail, because that’s the kind of answers I give here. ;-)

Notepad++ does not have a native compare function. Since you are saying you are using Notepad++ to compare, I have to conclude that you are using either the old Compare plugin or its much-improved successor ComparePlus. (If you are still using ComparePlugin, remove it and install ComparePlus, as that is the one that is getting continued support going forward.)

Unfortunately, even ComparePlus doesn’t have any feature to export its comparison to any format (whether it be something “standard”, like normal diff output or a patch file, or something unusual like a custom spreadsheet format)

Just so you know, Notepad++ is a text editor, and Excel natively works with binary data files. There is a text-based intermediary – the CSV format. But I cannot think of any standard CSV-based format that would be reasonable for a difference/comparison (ie, I have never heard of diff or similar tools outputting to a CSV format), so I doubt there’s anything ready-made that exists for Notepad++, any other text editor, or any command-line-based text-comparison tool like diff.

Since no one here is likely to know what are “CRIMS codes” or what “RPA running [in Excel]” is, or what format that spreadsheet-based tool would want the “differences” in for comparison, there’s not much else we can do at this point.

If you were to give us some short dummy “CRIMS”, along with a table

| header 1 | h2 | h3 |
|---|---|---|
| A1 | B1 | C1 |
| A2 | B2 | C2 |
| A3 | B3 | C3 |

header 1	header2	header3
A2	B2	C2
A3	B3	C3
A4	B4	C4

And show us what pieces from the CRIMS codes (or the “comparison of CRIMS codes”) map into each of those cells.

If it’s not too complicated, someone might be able to create a script for the PythonScript plugin that would take one or more CRIMS files and create the text-based CSV spreadsheet, which you could then open in Excel and use the “RPA” tool. And if the CRIMS codes and/or the difference format that you want is too complicated, it might be beyond the scope of free help in a text editor forum; so don’t be surprised if no one is able to help you with that, unless it’s just a simple mapping from a simple data format.

(However, if comparing the differences between two CRIMS codes is something that people in your field often do with an RPA running in Excel, it would very much surprise me if there weren’t already tools – either command-line or Excel/VBA-based – that didn’t do the comparison or otherwise convert the CRIMS codes into the right format to read in Excel. In which case, it’s not a question for Notepad++ users.)