Wednesday, December 23, 2009

how to translate a Table from LaTeX to Excel (and back to LaTeX)

Copy paste the table lines into a text file (say, using wordpad).
Replace all line endings \\ nothing.
Open the text file with Excel; use "&" as delimiter.
That's it, you have all the columns in excel.
Now, you can manipulate the table in excel.

My next job is to post a macro to go from excel back to LaTeX, coming soon.

No comments:

Post a Comment