[pmwiki-users] Excel and CSV copy/paste into pmwiki?

[Neil Herber]

At 2005-02-24  11:03 PM -0600, Patrick R. Michaud is rumored to have said:
>Okay, try this:
>
>1.  Open an Excel worksheet.
>2.  Select a section of your worksheet and copy it to the clipboard (CTRL+C).
>3.  Browse to http://www.pmwiki.org/wiki/Test/ExcelPaste?action=edit .
>4.  Paste the clipboard into the text area (CTRL+V).
>     The text columns might appear misaligned when you do the
>     paste -- don't worry about that yet.
>5.  Press the "Excel" button at the end of the graphical toolbar.
>
>If all works as planned, then the Excel data you pasted should
>appear as a PmWiki simple table, ready for editing.  You're also
>in page preview mode, so the preview of the table appears beneath
>the edit form.
>
>Would something like that be useful/usable for you?

Patrick

I tried it and it would be useful for me! The only complaint I have is the 
automatic left-alignment of all the cells. In my case they were mostly 
numbers that should be right aligned, but there is no easy way to make that 
global change.


Neil

Neil Herber
Corporate info at http://www.eton.ca/
Eton Systems, 15 Pinepoint Drive, Nepean, ON, Canada K2H 6B1
Tel: (613) 829-4668