[pmwiki-users] Excel and CSV copy/paste into pmwiki?
nospam at mail.eton.ca
Thu Feb 24 23:06:16 CST 2005
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?
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
Corporate info at http://www.eton.ca/
Eton Systems, 15 Pinepoint Drive, Nepean, ON, Canada K2H 6B1
Tel: (613) 829-4668
More information about the pmwiki-users