« Return to Thread: TiKZ & exceltex

Re: TiKZ & exceltex

by Walter Cazzola-2 :: Rate this Message:

Reply to Author | View in Thread

Dear Mark
thanks for your reply.

On Mon, 22 Jun 2009, Mark Wibrow wrote:

> I really don't know exceltex, but simply by looking at the internals
> of \inccell using \show,

this sounds interesting, could you explain me how to use \show? just a
small example will help.

> I predict with some confidence that the approach you are trying will
> never work.

> Essentially you are trying to input file contents `on-line' whilst the
> key is being processed which can't be done.

Well, from the little I can understand of LaTeX/TeX pdflatex just mark
in .aux file which cells are necessary and a perl script extract the
data from the excel, write them one for a file that will be input in the
second pdlatex run. So the data are not extracted on-the-fly. I hope
this gives me some more hope.

In the meanwhile I tracked down the problem as an incompatibility of
(x)color (that should be used by \draw) and exceltex since if I put the
data extracted from the excel file somewhere else it works. For example

   \documentclass[10pt,svgnames]{article}
   \usepackage{color} % used by exceltex
   \usepackage{exceltex}

   \usepackage{tikz}
   \usepackage{pgffor}

   \begin{document}

     \begin{tikzpicture}[] {
             \draw[Gold, line width=.2cm, rounded corners=7pt] (.25cm,.25cm) rectangle +(8.5,5.5) node {{\inccell{dati.xls!ECOOP09!C1}}};
       }
     \end{tikzpicture}
     \textcolor{{\inccell{dati.xls!ECOOP09!C1}}}{Hello World!!!}
   \end{document}

the first occurrence of \inccel works smootly but the second one crashes
with the message:

   [Loading MPS to PDF converter (version 2006.09.02).]
   ) ABD: EveryShipout initializing macros (./crap-excltx/c-1)
   ! Missing \endcsname inserted.
   <to be read again>
                      \csname\endcsname
   l.14 ...ell{dati.xls!ECOOP09!C1}}}{Hello World!!!}

   ?

any more idea?

Cheers

Walter

--
Walter Cazzola, PhD - Assistant Professor, DICo, University of Milano
E-mail cazzola@... Ph.: +39 02 503 16300  Fax: +39 02 503 16253
· · · ---------------------------- · · · ---------------------------- · · ·
                ... recursive: adjective, see recursive ...
· · · ---------------------------- · · · ---------------------------- · · ·
------------------------------------------------------------------------------
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
_______________________________________________
pgf-users mailing list
pgf-users@...
https://lists.sourceforge.net/lists/listinfo/pgf-users

 « Return to Thread: TiKZ & exceltex