Register to post in forums, or Log in to your existing account
 

Play RetroMUD
Post new topic  Reply to topic     Home » Forums » zMUD General Discussion
Grae
Beginner


Joined: 21 May 2006
Posts: 11

PostPosted: Sun May 21, 2006 1:07 pm   

#write help
 
I am hoping to use #write to write to an excel file. how do I write to columns other than the first one? or is this not possible?
Reply with quote
Guinn
Wizard


Joined: 03 Mar 2001
Posts: 1127
Location: London

PostPosted: Sun May 21, 2006 1:51 pm   
 
Not easily possible. The #WRITE command is purely for appending text to an existing text file. Excel uses it's own .XLS format which zMud couldn't write directly into.

What is may be possible to do, and what I'd guess you've managed so far, is to write the text file as a .CSV (Comma Separated Variable) and then have Excel open it from there.
You'd then separate each column with a comma, and each row on a new line.

A quick 3x5 grid looking like this in Excel



looks like this in Notepad (as a CSV file).
Code:
"Cell A,1",Cell B1,Cell:C1
Cell A2,"Cell B2,",Cell C2
Cell A3,Cell B3,",Cell C3"
Cell_A4,Cell B4,Cell C4
Cell A5,Cell#B5,Cell C5


If you really want to get into playing with Excel and zMud then you want to look into the COM functions, but I don't know anything about that ;)

Hope that gets you started.
(Oh, and if you want to get into the COM functions then they'll be greatly improved with CMUD, the first Beta is out soon in all good bookshops)
Reply with quote
Display posts from previous:   
Post new topic   Reply to topic     Home » Forums » zMUD General Discussion All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

© 2009 Zugg Software. Hosted by Wolfpaw.net