James used the contact form to ask about Excel and OneNote:
Pull in a Excel shreadsheet into OneNote and retain the cell formating?
It would be great if it could also mantain the formulas, but thats a plus only.
According to a comment on Brad Covelle’s Blog (link broken, details in previous post here) there was a similar powertoy that was a Contest Winner, but I can’t find it on the public internet…
Send to OneNote by Piyush Shah
- This Powertoy adds a Send to OneNote into the right-click Send To menu in Windows Explorer.
- Put a button in Excel and PowerPoint to send the selection / entire document to OneNote.
OneNote 2007 has a basic table layout, so a simple Copy/Paste will produce a table with most of the basic formatting. The row/column width data is lost and ON2007 doesn’t support Borders, so it won’t look quite the same.
OneNote 2007 does have Insert Files as Printout which produces a searchable image and looks much better, but the data can’t be modified.
OneNote 2007 also allows Hyperlinks to files, so that would be my suggested route.
Anyone have a better suggestion? Preferably something that works in 2003 as well (such as how to get Piyush’s PowerToy and what it’s out output looks like.)
Off the topic a bit, but this type of functionality is support by MindJet’s MindManager product (www.mindjet.com).
You can select a range of cells from an Excel spreadsheet, push it to MindManager, which displays the cells in the range and retains a link back to your original spreadsheet file. You can even edit the cells from w/in MindManager and it will update your spreadsheet. MM6 also supports creating a mini-spreadsheet right within a mindmap, without using Excel at all.
p.s. I’m NOT related to the company, its subsidiaries, owner, employees, etc. in any way. Just a happy customer who also likes OneNote.
Great Stuff!!!. Many Thanks
Great Stuff!!! Many Thanks