{"id":1019,"date":"2012-11-07T16:08:49","date_gmt":"2012-11-07T16:08:49","guid":{"rendered":"http:\/\/johncanning.net\/wordpress\/?p=1019"},"modified":"2012-11-07T16:08:49","modified_gmt":"2012-11-07T16:08:49","slug":"converting-tables-from-excel-2010-to-latex-using-excel2latex-add-in","status":"publish","type":"post","link":"http:\/\/johncanning.net\/wp\/?p=1019","title":{"rendered":"Converting tables from Excel 2010 to LaTeX using excel2latex add-in"},"content":{"rendered":"
\"Orginal<\/a>
Orginal Excel 2010 table<\/figcaption><\/figure>\n

Building all but the simplest tables in LaTeX is not a particularly intuitive process. I\u2019ve just been trying out the Excel2Latex add-in for converting tables from Excel (2010) into LaTeX. I eventually got it to work, but it look a lot of on-line detective work to work it all out. It appears that it was easier to use in Excel 2003.<\/p>\n

    \n
  1. First of all you need to download <\/a>the add in file\u00a0 The file has the extension .xla<\/li>\n
  2. It will tell you to open the file in excel. When I tried to open the file in Excel nothing happened, but the file got saved under username\/temp rather than in username\/downloads. (as I was opening it up online).<\/li>\n
  3. In early versions of excel this might have been enough and the Excel2Latex add-in would appear under the tools menu. This was not the case in Excel 2010.<\/li>\n
  4. I then opened Excel and clocked on \u201cFile\u201d, then \u201cOptions\u201d.<\/li>\n
  5. I then selected Add-ins from the left hand side.<\/li>\n
  6. A list of available Add-ins came up, but Excel2Latex did not appear.<\/li>\n
  7. At the bottom of the dialogue box you should find the word \u2018Manage\u2019. Select Add-ins from the drop down menu and click \u2018Go\u2019<\/li>\n
  8. A list of available add-ins will appear. If Excel2Latex is there select it, but in my case it was not there. If this is the case click \u2018Browse\u2019 and find the file excel2Latex.xla. Select it and it should be added to your list of add-ins.<\/li>\n
  9. Now close Excel down.<\/li>\n
  10. When excel is re-opened a new heading will appear at the top of the Excel window labelled \u2018add-ins\u2019 . Click on this menu item and you should see two new buttons. \u201cConvert table to LaTeX\u201d and \u201cConvert all stored tables to LaTeX\u201d.<\/li>\n
  11. Open up an excel file (if you have not already done so) and Click on \u201cadd-ins\u201d, then \u201cConvert table to LaTeX\u201d. \"New<\/a><\/li>\n
  12. Excel will then generate the LaTeX code for your table.\"LaTeX<\/a><\/li>\n
  13. Export or copy+paste into your usual .tex\/ LaTeX editor\n
    \"Code<\/a>
    Code pasted into my LaTeX editor<\/figcaption><\/figure>\n

    \n<\/li>\n

  14. The final result in my .pdf file! Looks nice I think.\n

    \"PDF<\/a>
    PDF screenshot<\/figcaption><\/figure><\/li>\n<\/ol>\n

    Notes<\/strong><\/p>\n

    Excel2latex can cope with formats such as italic<\/em> and bold<\/strong>,but not colour at present.<\/p>\n\n\n