How to read an Excel file using TCL Scripts

[RAGHU]

Hi all,

I have an excel file test.xls.It is created manually and few values
are added manually.

I Want to read each column of the excel and store in some variable
using TCL Scripts.

I went thro lot of examples but nothing related to above requirement I
found.

Please give suggestions or links where this code is given.

Thanks in Advance,
RAGHU

[Konstantin Khomoutov]

On 25 ноя, 12:55, RAGHU <ragh...@gmail.com> wrote:

> I Want to read each column of the excel and store in some variable
> using TCL Scripts.

Open http://wiki.tcl.tk/tcom and search for "Extract some cells from
an Excel file".

[hae]

This question was here 1 or two months ago. Check the mailing list or
search in the wiki.

[balejo]

hi Raghu,

Save the excel file into csv format... thsi will then give you a comma separated values... since it is separated by comma you can use the tcl comman to "split". split "\n" string to split per row.. split "," string to split per column..

--http://compgroups.net/comp.lang.tcl/how-to-read-an-excel-file-using-tcl-scripts/219006

[Robert Heller]

There are also packages in Tcllib for dealing with csv files, including a
parser than understands about escaping and quoting.

man n csv
man n matrix


>
>

--
Robert Heller -- 978-544-6933 / hel...@deepsoft.com
Deepwoods Software -- http://www.deepsoft.com/
() ascii ribbon campaign -- against html e-mail
/\ www.asciiribbon.org -- against proprietary attachments

[JMar...@comcast.net]

Here's an extension built on Twapi - complete with examples.

http://www.posoft.de/html/extCawt.html

[Rich]

balejo <bryan...@bitmicro.com> wrote:
: hi Raghu,

You are better off using the Tcllib csv command to process the csv
file. There are a bunch of odd quirks that make the basic split
command fail for different quirks.

http://tcllib.sourceforge.net/doc/csv.html