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

David Wierbiki dave at myrikgames.com
Fri Feb 25 08:12:34 CST 2005


Patrick,
 
THAT is exactly what we need!  Perfect.  If this addon is made available I will implement pmwiki immediately for our Project.  It was the only thing holding us back really.  I have a couple of former accountants that only work in Excel - I understand why, it's just been a real pain to accommodate them.
 
Thank you SO much for doing this.  ANd thank you to everyone else who offered suggestions.  Proves even further that pmwiki has a great community supporting it.
 
Thanks again!
 
David Wierbiki
Myrik Games


"Patrick R. Michaud" <pmichaud at pobox.com> wrote:
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: /pipermail/pmwiki-users/attachments/20050225/7300ccf0/attachment.html 


More information about the pmwiki-users mailing list