<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Thanks very much, Alan. I have used your old program many times, and it has saved me a lot of labor (not to mention probably countless mistakes!)<div><br></div><div>David Derbes</div><div>U of Chicago Lab Schools</div><div><br><div><div>On Feb 20, 2010, at 5:45 PM, Alan Munn wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On Feb 20, 2010, at 5:39 PM, David Derbes wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Alan Munn put together a very nifty and perhaps easier solution called xl2latex, based on an earlier program by Tom Counsell. Apparently this is now renamed to csv2latex. Anyway, the version I used (and continue to use) is a Ruby program. Basically, you open up the Terminal and also your Excel file. You copy the cells into memory. In Terminal, you execute the command <br><br>ruby xl2latex.rb<br><br>(making sure that the program xl2latex.rb is in your directory so that the Ruby interpreter can find it), and the terminal reports "OK. Data in memory". You then type Command-V at that point in your LaTeX source you want the table of Excel data, and there it is.<br><br>Perhaps the new version is the old one renamed with a few bells and whistles...<br></div></blockquote><div><br></div>Yes, I've added an Applescript that allows you to choose a table type, and it's now included directly into TeXShop, which is what David M's question was about.</div><div><br></div><div>You (David D.) might want to check out the newer version; it requires no terminal use at all.</div><div><br></div><div>Alan</div><div><br></div><div><blockquote type="cite"><div><br>David Derbes<br>U of Chicago Lab Schools<br><br>On Feb 20, 2010, at 4:23 PM, Alain Schremmer wrote:<br><br><blockquote type="cite"><br></blockquote><blockquote type="cite">On Feb 20, 2010, at 3:05 PM, David Messerschmitt wrote:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">As one of those lazy users who just wants things to work without a lot of fuss, I was excited to find the Macros Help in TexShop 2.31 describing a Default Applescript Macro "Paste Spreadsheet Cells". With considerable excitement I went to the TexShop Macros->Applescript menu to look for it, and was disappointed that it was not listed. Assuming this refers to csv2latex, I then looked for csv2latex among the macro menus and could not find it either. Am I missing something simple? It would be great if this useful macro was available without a lot of installation fuss.<br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Being one of the laziest users on this list, I certainly could not cast the first stone.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">In the case of cvs2latex, I downloaded it, unzipped it, did something else and created the following macro in TeXShop:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">--Applescript direct<br></blockquote><blockquote type="cite">--If you change the location of the csv2latex script, you must change<br></blockquote><blockquote type="cite">--this script accordingly to reflect the new location.<br></blockquote><blockquote type="cite">set mainList to {"cells","booktabs", "simple","longtable" }<br></blockquote><blockquote type="cite">choose from list mainList with prompt "Choose a table format"<br></blockquote><blockquote type="cite">set tablestyle to result as text<br></blockquote><blockquote type="cite">do shell script "~/Library/texmf//csv2latex" & " " & tablestyle<br></blockquote><blockquote type="cite">tell application "System Events" to keystroke "v" using {command down}<br></blockquote><blockquote type="cite">--End of Applescript<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">At this point, though, I can't remember what the something else was but since I am terminally install-challenged ...<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">And, unless someone beats me to it, I should have the solution tomorrow.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Regards<br></blockquote><blockquote type="cite">--schremmer<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">----------- Please Consult the Following Before Posting -----------<br></blockquote><blockquote type="cite">TeX FAQ: <a href="http://www.tex.ac.uk/faq">http://www.tex.ac.uk/faq</a><br></blockquote><blockquote type="cite">List Reminders and Etiquette: <a href="http://email.esm.psu.edu/mac-tex/">http://email.esm.psu.edu/mac-tex/</a><br></blockquote><blockquote type="cite">List Archive: <a href="http://tug.org/pipermail/macostex-archives/">http://tug.org/pipermail/macostex-archives/</a><br></blockquote><blockquote type="cite">TeX on Mac OS X Website: <a href="http://mactex-wiki.tug.org/">http://mactex-wiki.tug.org/</a><br></blockquote><blockquote type="cite">List Info: <a href="http://email.esm.psu.edu/mailman/listinfo/macosx-tex">http://email.esm.psu.edu/mailman/listinfo/macosx-tex</a><br></blockquote><blockquote type="cite"><br></blockquote><br>----------- Please Consult the Following Before Posting -----------<br>TeX FAQ: <a href="http://www.tex.ac.uk/faq">http://www.tex.ac.uk/faq</a><br>List Reminders and Etiquette: <a href="http://email.esm.psu.edu/mac-tex/">http://email.esm.psu.edu/mac-tex/</a><br>List Archive: <a href="http://tug.org/pipermail/macostex-archives/">http://tug.org/pipermail/macostex-archives/</a><br>TeX on Mac OS X Website: <a href="http://mactex-wiki.tug.org/">http://mactex-wiki.tug.org/</a><br>List Info: <a href="http://email.esm.psu.edu/mailman/listinfo/macosx-tex">http://email.esm.psu.edu/mailman/listinfo/macosx-tex</a><br><br></div></blockquote></div><br><div apple-content-edited="true"> <span class="Apple-style-span" style="border-collapse: separate; font-family: 'Lucida Grande'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>-- </div><div>Alan Munn</div><div><a href="mailto:amunn@gmx.com">amunn@gmx.com</a></div><div><br></div></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"> </div><br></div>----------- Please Consult the Following Before Posting -----------<br>TeX FAQ: <a href="http://www.tex.ac.uk/faq">http://www.tex.ac.uk/faq</a><br>List Reminders and Etiquette: <a href="http://email.esm.psu.edu/mac-tex/">http://email.esm.psu.edu/mac-tex/</a><br>List Archive: <a href="http://tug.org/pipermail/macostex-archives/">http://tug.org/pipermail/macostex-archives/</a><br>TeX on Mac OS X Website: <a href="http://mactex-wiki.tug.org/">http://mactex-wiki.tug.org/</a><br>List Info: <a href="http://email.esm.psu.edu/mailman/listinfo/macosx-tex">http://email.esm.psu.edu/mailman/listinfo/macosx-tex</a><br><br></blockquote></div><br></div></body></html>