Unless somebody has written a beautiful Plugin, I doubt this is possible, but I'm just wondering if I can view an Excel file in NP++ ?
The reason I ask is that I receive a number of files every few days which I need to work on and produce a Word document. I am busy automating as much as I can & NP++ is perfect for most of what I do, however, one particular .txt file, a League Table, is horribly formatted, so I have edited it & put it into an Excel file, which displays nicely using Excel. However, IF I could have this as another NP++ tabbed file it would just be so much neater and would close automatically with the rest of the files when I close NP++ at the end of my VB.net program.
Either that, or does NP++ have a "Table" option so that I could Paste the Tabbed .txt file to that rather than an Excel spreadsheet ?
None of this is worth me getting worked up over, just looking for good ways to make my life easier :-) !!!
if your Excel table contains just text, you can export it as *.csv format and then open it in N++. Then you can use replace option to replace ";" (semicolon is default separator for Excel csv dialect) with any number of tabs (\t and Regular expression box ticked). In this way you will achieve nice vertical alignment. I presume that is what you are looking for.
Loreia, yes, it's all about alignment, I'm writing a Newsletter & just need to glance at the League Table now and again & need it to be easily readable, not look like something my 2 year-old typed !!!
I won't be doing anything more on this tonight, probably not until Monday, so apologies if I don't get back to you again until then, but I will look into it ...
My original file is a Tabbed .TXT file & I read it line by line & paste it into an Excel document to get that alignment ... can I bypass that step to get the file nicely aligned in NP++ ? Anything you can suggest that I can experiment with (be clear though, I am using so many different programs, methods, languages, etc., etc. that my brain is fried !) I would appreciate it very much ...
can you share few lines of that file, and explain what it should look like after formatting?
Just woke up on the sofa, damn that bloody beer, though it does allow me to put this up now !!!
OK, I've attached a screenprint of how the file looks now in NP++ followed by how much "nicer" it looks in Excel ... this is what I'm working towards, but as I have said, this is cosmetic, if it's difficult or long-winded, I can live without it :-) ... but thanks for showing interest ...
Hi Gary, your sample file is already structured, you just need minimal intervention on it.
This should be enough to achieve desired result.
Thank you Loreia2, I will give that a try ...
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.