Any advice on making better CSV's for eventual MV to Excel exports. I've used CSV's for years (avoiding A1 containing ID) and have been using HTML for some formatting. The HTML problem is I usually have to create the spreadsheet with its formatting, save as HTML and edit the 'text' of the HTML.
SLK seems attractive. Where do I begin. Thanks ----- Original Message ----- From: "Ewinger Klaus" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, October 21, 2005 3:14 AM Subject: AW: [U2] [UV][OT]Embed command in CSV file? > Barry, > > Instead of using CSV, you could use SLK Format ("Symbolic Link Format"). It is slightly more work to format the data, but you have total control about cell formatting. You also get your cell types correctly, e.g. a date is formatted as a date and not as a string. Even formulas are possible. And the nice thing about it is, that it is pure ASCII. Not a binary format like .XLS. > > -Klaus > > > > -----Urspr|ngliche Nachricht----- > Von: Barry Brevik [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 20. Oktober 2005 20:05 > An: U2-users (E-mail) > Betreff: [U2] [UV][OT]Embed command in CSV file? > > A little off-topic... > > From universe, I am creating a sequential file which is formatted as a CSV file, in other words each field is quoted and separated from each other by commas, for example: > > "John","Jacob","Dingleheimer Schmidt" > > The intent is that the resulting file is opened with Excel. > > You can force any cell into multiple lines by embedding a CHAR(10), for > example: > > WRITESEQ \"John","Jacob","Dingleheimer\:CHAR(10):\Schmidt"\ TO MY.CSV.FILE THEN NULL > > ...when viewed in Excel will give you... > > John Jacob Dingleheimer > Schmidt > > ...which is a great way of expressing multi-values. > > Finally I arrive at the crux. When you open such a document in Excel, it only displays one line per row even if a cell in that row contains multiple lines. To see all lines you have to select all and hit FORMAT | ROW | AUTOFIT. My users seem to be incapable of dealing with that, so... > > ...does anyone know if it is possible to embed some kind of command in a CSV file that will get Excel to autofit those rows automatically? > > Barry Brevik > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
