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

[Patrick R. Michaud]

On Thu, Feb 24, 2005 at 10:20:17AM -0800, David Wierbiki wrote:
>    My creative team needs the ability to copy/paste MS Excel or CSV
>    worksheets into the wiki.  The only wikis that actually come with this
>    functionality are subscription services, and we are not prepared to do
>    that.

Just for clarification -- you're wanting to convert an MS Excel
worksheet into a table that can be displayed in the wiki?  You're
not concerned about preserving formulas or anything like that?

Is it necessary that your team be able to edit the table contents
after they've been posted?  If not, one approach would be
to allow authors to upload a .csv file using PmWiki's standard
file-attachment capabilities, and provide a markup that can
display a .csv attachment as an HTML table (without having to
ever convert to PmWiki markup).

Another option would be to get PmWiki to understand tables
copy-and-pasted from Excel.  Hmmm, that might be interesting.
[type...type...type...]

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?

Pm