At 2007-12-06 06:25AM, "raaki" wrote: > On Dec 4, 2:29 pm, cla...@lairds.us (Cameron Laird) wrote: > > In article <83ef457f-b378-4e86-bcf2-cfb3678c1...@e25g2000prg.googlegroups.com>,raaki <hemanth...@gmail.com> wrote: > > >Hi Members, > > > > >i need some procedures and suggestions regarding,writing excel format > > >file with tcl. > > > > >what i am trying to do is read multiple files of .txt format of > > >specific name in directory and trying to compare the data in each file > > >with other data and display the results in the form of tables . > > > > >is there any tcl example scripts that writes excel format, are > > >available? > > > > >can any one give me some suggestions regarding,how to search for > > >specific file and to write an excel format with tcl. > > > > . > > . > > . > > I do a lot of this: <URL:http://wiki.tcl.tk/excel>. > > Hi Cameron, > > i already went through Excel page which u referred.but i didnt find > any thing perticular for solaris. > can you guide me little deeper regrding this topic > i need to write my results into seperate excel tabular format file. Unless you need to apply formatting, it's far easier to write a delimited text file. If you use commas to separate your fields and save the file as filename.csv, Excel will open it like a spreadsheet. -- Glenn Jackman "You can only be young once. But you can always be immature." -- Dave Barry

In article <60a0f2d1-c28e-4b74-9299-25a0e76dfba8@e10g2000prf.googlegroups.com>, raaki <hemanth004@gmail.com> wrote: >On Dec 6, 12:41 pm, Glenn Jackman <gle...@ncf.ca> wrote: >> At 2007-12-06 06:25AM, "raaki" wrote: >> >> >> >> >> >> > On Dec 4, 2:29 pm, cla...@lairds.us (Cameron Laird) wrote: >> > > In article ><83ef457f-b378-4e86-bcf2-cfb3678c1...@e25g2000prg.googlegroups.com>,raaki ><hemanth...@gmail.com> wrote: >> > > >Hi Members, >> >> > > >i need some procedures and suggestions regarding,writing excel format >> > > >file with tcl. >> >> > > >what i am trying to do is read multiple files of .txt format of >> > > >specific name in directory and trying to compare the data in each file >> > > >with other data and display the results in the form of tables . >> >> > > >is there any tcl example scripts that writes excel format, are >> > > >available? >> >> > > >can any one give me some suggestions regarding,how to search for >> > > >specific file and to write an excel format with tcl. >> >> > > . >> > > . >> > > . >> > > I do a lot of this: <URL:http://wiki.tcl.tk/excel>. >> >> > Hi Cameron, >> >> > i already went through Excel page which u referred.but i didnt find >> > any thing perticular for solaris. >> > can you guide me little deeper regrding this topic >> > i need to write my results into seperate excel tabular format file. >> >> Unless you need to apply formatting, it's far easier to write a >> delimited text file. If you use commas to separate your fields and save >> the file as filename.csv, Excel will open it like a spreadsheet. >> >> -- >> Glenn Jackman >> "You can only be young once. But you can always be immature." -- Dave >Barry- Hide quoted text - >> >> - Show quoted text - > >thks suchewi and jackmann > >i already have some scripts that write .csv format,but the formatting >really doesnt look good when i open with excel. >thats why, am trying to write my results directly to .xls format I understand the question. Indeed, formatting through CSV is a challenge, one I haven't solved. I've had success in the past importing .HTML into Excel. If your project were my responsibility, that would be my next approach. To produce .xls directly on a Solaris constitutes a research topic; it's a substantial piece of work. If I decided that's what I needed, I'd first carefully research any precedents. I suspect Perl people have made progress that might apply. I summarize: look into HTML-coded formatting; report your results back here, and we'll likely be able to provide more tips.

In article <60a0f2d1-c28e-4b74-9299-25a0e76dfba8@e10g2000prf.googlegroups.com>, raaki <hemanth004@gmail.com> wrote: >On Dec 6, 12:41 pm, Glenn Jackman <gle...@ncf.ca> wrote: >i already have some scripts that write .csv format,but the formatting >really doesnt look good when i open with excel. >thats why, am trying to write my results directly to .xls format Totally off the wall suggestion: have you tried openoffice? I know there is tuno, the tcl-OOo bridge, but I don't know if it is enough to maniuplate OOo's spreadsheet program. I think this is the real difficulty. On Windows, COM can be used to manipulate Excel directly. As far as I know, there isn't anything like COM that can run directly on Solaris to manipulate Excel. OOo works on Solaris, and if tuno works, it may be easier to manipulate OOo, and then convert to Excel. -- WL real mail: wliao at sdf loSnPesAtarM org (remove the uppercase letters...)