[TxMt] Re: Latex tables and Excel

[William Yang]

Charilaos Skiadas wrote:
> Will,
> On Oct 1, 2006, at 2:15 PM, William Yang wrote:
> 
>> Daniel Käsmayr wrote:
>>> Will,
>>> an interesting question I was thinking about last night as well. I 
>>> haven't tested this, but exporting as csv (comma separated or any 
>>> other symbol is posssible, I believe) opens up all kinds of 
>>> possibilities with TextMate's regex search…?
>>> btw and very OT: … is there any alternative to excel on the mac? a) 
>>> for calculating and b) for plotting?
> 
> Ok, first answering Daniel's OT question:
> There is the R language, depending on what you want to do. I will 
> probably use it for most of my spreadsheeting needs. 
> http://www.r-project.org/
> 
>>> Dan
>> I was hoping for something simpler since I work with small 
>> tables...something like copy table into Textmate, click convert, and 
>> boom, Latex table.  I modified the existing Convert Table script to 
>> work with Excel and it works for my needs, but probably misses many 
>> corner cases.  If anyone has a better solution please post. Thanks
> 
> So, could you explain to us why just copying and pasting from Excel 
> didn't work for you? I don't have Excel on my mac to test, but the Excel 
> in my windows machine seems to paste the cells as being tab-delimited, 
> which IIRC is what the convert macro expects, so it would seem you 
> wouldn't need to do anything at all differently. So could you show us 
> the pasted Excel text that wasn't working for you? (You can use the 
> Pastie service, i.e. select the text in textmate, and press 
> ctrl-shift-opt-V, then paste the resulting link here.
> 
>> Will
> 
> Haris
> 
> 
> 
http://pastie.caboo.se/15703
But this doesn't seem to preserve the tabs?

Here it is pasted directly:

Size	GCC IPC	GZIP IPC
1024	0.8026	0.1987
2048	0.8031	0.1987
4096	0.8025	0.1987
32768	0.8026	0.1987

This is what the "Convert table.." in the Latex bundle output:

\begin{tabular}{cc}
\hline
Size & GCC IPC GZIP IPC\\
\hline
1024 & 0.8026 & 0.1987\\
2048 & 0.8031 & 0.1987\\
4096 & 0.8025 & 0.1987\\
32768 & 0.8026 & 0.1987\\
\hline
\end{tabular}
The numbers are parsed right, but the title is not.

This is how my script outputs, which is the correct one:
\table[ht]
	\centering
	\begin{tabular}{ccc}
	\hline
	Size & GCC IPC & GZIP IPC\\
	\hline
	1024 & 0.8026 & 0.1987\\
	2048 & 0.8031 & 0.1987\\
	4096 & 0.8025 & 0.1987\\
	32768 & 0.8026 & 0.1987\\
	\hline
	\end{tabular}
	\caption{Table Caption}
	\label{Table Label}
\end{table}



Will