<DIV>
<DIV>Patrick,</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Thanks again!</DIV>
<DIV> </DIV>
<DIV>David Wierbiki</DIV>
<DIV>Myrik Games</DIV>
<DIV><BR><BR><B><I>"Patrick R. Michaud" <pmichaud@pobox.com></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">On Thu, Feb 24, 2005 at 10:20:17AM -0800, David Wierbiki wrote:<BR>> My creative team needs the ability to copy/paste MS Excel or CSV<BR>> worksheets into the wiki. The only wikis that actually come with this<BR>> functionality are subscription services, and we are not prepared to do<BR>> that.<BR><BR>Just for clarification -- you're wanting to convert an MS Excel<BR>worksheet into a table that can be displayed in the wiki? You're<BR>not concerned about preserving formulas or anything like that?<BR><BR>Is it necessary that your team be able to edit the table contents<BR>after they've been posted? If not, one approach would be<BR>to allow authors to upload a .csv file using PmWiki's standard<BR>file-attachment capabilities, and provide a markup that can<BR>display a .csv attachment as an HTML table (without having to<BR>ever convert to PmWiki markup).<BR><BR>Another option
would be to get PmWiki to understand tables<BR>copy-and-pasted from Excel. Hmmm, that might be interesting.<BR>[type...type...type...]<BR><BR>Okay, try this:<BR><BR>1. Open an Excel worksheet.<BR>2. Select a section of your worksheet and copy it to the clipboard (CTRL+C).<BR>3. Browse to http://www.pmwiki.org/wiki/Test/ExcelPaste?action=edit .<BR>4. Paste the clipboard into the text area (CTRL+V). <BR>The text columns might appear misaligned when you do the<BR>paste -- don't worry about that yet.<BR>5. Press the "Excel" button at the end of the graphical toolbar. <BR><BR>If all works as planned, then the Excel data you pasted should<BR>appear as a PmWiki simple table, ready for editing. You're also<BR>in page preview mode, so the preview of the table appears beneath<BR>the edit form.<BR><BR>Would something like that be useful/usable for you?<BR><BR>Pm<BR></BLOCKQUOTE></DIV>