1

I would like to write text blocks in excel and then import this excel sheet into latex to be available there in a variable with a (multi)-list-like structure. The idea is then to select certain elements of that list and use them as text blog in latex.

So let's write some pseudo code:

input.csv or input.xlsx (depending on whether xlsx works as well):
"$$f(x)=x^2$$" ; "Some text"
"Some other text" ; "even more text"

latex:
textblocks = import(input.csv)
\begin{document}
textblocks[1,1] (* lower right cell in input.csv *)
textblocks[0,0] (* upper left  cell in input.csv *)
\end{document}

The question is, is it possible to import an excel sheet to an list-like object in latex where elements can then be accessed in the suggested manner. I am not really familiar with the way latex works "behind the scenes".

Just as a side mark: I am aware of Excel2LaTeX. But I am much more interested in a more integrated solution that I can use within my actual LaTeX source file.

  • Do you want Excel files or csv? Your code contains both, but which one doe you want? – TeXnician May 7 '17 at 9:34
  • I would prefer excel, but realize, that there could be issues with contents of cells not being strings (e.g. when you calculate a value in excel). So I would be fine with exporting to csv first to avoid problems like that. – Asking Questions May 7 '17 at 9:35
  • Looking a little bit further I found this question which might link to mine very well and could be a solution : Link LaTeX Documentation to Excel Data – Asking Questions May 7 '17 at 9:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.