Re: TiKZ & exceltex

> Hi,
>
> \show\inccell
>
> then look in the log file.
>
> What you get is a definition like this
>
> \stepcounter {exceltexCounterC}
> \ifx \cellrefs \undefined \immediate \write 10{c:\theexceltexCounterC :#1}
> \InputIfFileExists {\jobname -excltx/c-\theexceltexCounterC }{}{}
> \else \immediate \write 10{c:#1}\InputIfFileExists {\jobname
> -excltx/c-#1}{}{}\fi
>
> This is fine in the normal course of LaTeX processing (which is what
> you get inside a node as TikZ "escapes" to LaTeX for the node
> contents). But when you throw all of that into the key parser, or as
> an argument to the color macros, it is not (as far as I know) ever
> going to work.
>
> Regards
>
> Mark
>
> 2009/6/22 Walter Cazzola <cazzola@...>:
>> 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
>