« Return to Thread: TiKZ & exceltex
Re: TiKZ & exceltex
by Mark Wibrow-2
::
Rate this Message:
Hi,
I really don't know exceltex, but simply by looking at the internals
of \inccell using \show, 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.
Sorry
Mark
2009/6/20 Walter Cazzola <cazzola@...>:
> Dear TiKZ experts,
> I'm trying to get some data from an excel file and use them as a
> parameter for the \draw command but I got this message:
>
> [Loading MPS to PDF converter (version 2006.09.02).]
> ) ABD: EveryShipout initializing macros
> ! Missing \endcsname inserted.
> <to be read again>
> \csname\endcsname
> l.13 }
>
> ?
>
> and no pdf is generated and in worst case I also get an infinite loop.
>
> The following is a short example of the problem:
>
> \documentclass[10pt,svgnames]{article}
> \usepackage{color} % used by exceltex
> \usepackage{exceltex}
>
> \usepackage{tikz}
> \usepackage{pgffor}
>
> \begin{document}
>
> \begin{tikzpicture}[]
> \foreach \x/\y/\step in {0.5/0.5/1, 10/0.5/2, 19.5/0.5/3}{
> \draw[{\inccell{dati.xls!ECOOP09!C1}}, line width=.2cm, rounded
> corners=7pt] (\x cm+.25cm,\y cm+.25cm) rectangle +(8.5,5.5) ;
> }
> \end{tikzpicture}
>
> \end{document}
>
> in this case the content of the excel is a color name such as Gold Teal
> and so on.
>
> Any idea? Any help is really appreciated.
>
> Thank you in Advance for the help
>
> 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
>
>
------------------------------------------------------------------------------
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
I really don't know exceltex, but simply by looking at the internals
of \inccell using \show, 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.
Sorry
Mark
2009/6/20 Walter Cazzola <cazzola@...>:
> Dear TiKZ experts,
> I'm trying to get some data from an excel file and use them as a
> parameter for the \draw command but I got this message:
>
> [Loading MPS to PDF converter (version 2006.09.02).]
> ) ABD: EveryShipout initializing macros
> ! Missing \endcsname inserted.
> <to be read again>
> \csname\endcsname
> l.13 }
>
> ?
>
> and no pdf is generated and in worst case I also get an infinite loop.
>
> The following is a short example of the problem:
>
> \documentclass[10pt,svgnames]{article}
> \usepackage{color} % used by exceltex
> \usepackage{exceltex}
>
> \usepackage{tikz}
> \usepackage{pgffor}
>
> \begin{document}
>
> \begin{tikzpicture}[]
> \foreach \x/\y/\step in {0.5/0.5/1, 10/0.5/2, 19.5/0.5/3}{
> \draw[{\inccell{dati.xls!ECOOP09!C1}}, line width=.2cm, rounded
> corners=7pt] (\x cm+.25cm,\y cm+.25cm) rectangle +(8.5,5.5) ;
> }
> \end{tikzpicture}
>
> \end{document}
>
> in this case the content of the excel is a color name such as Gold Teal
> and so on.
>
> Any idea? Any help is really appreciated.
>
> Thank you in Advance for the help
>
> 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
>
>
------------------------------------------------------------------------------
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
| Free embeddable forum powered by Nabble | Forum Help |
