>If you create an HTML file and name it with a .xls extension Excel will
open
>it quite happily and adjust columns to fit all by itself.
Wow! You are right! How cool is that?
That is pretty cool. I noticed that a in a results in visually
correct data in Excel, but generates an extra row, when w
>If perl is an option, you may want to look into
> the spreadsheet module
Duh-oh!
I didn't think of that. I love Perl... I use it as often as possible, and
I'll even call it from UV. I developed an email module to take a UV
generated seq file (properly formatted) and use it as an email template,
One of my "hits" here is an application that can extract the contents
of an invoice from our U2 system and produce as an Excel spreadsheet
with multiple tabs. The main users of this appliation are our billing
and collections staff. They love being able to send a client the
spreadsheet representat
Tony Gravagno wrote:
Mark Johnson wrote:
Tony:
What's the fastest path for someone who's been providing
the CSV's for the last 10 years and wants to deliver
something more complete. I don't want to spend a lot of
my client's money on packages.
When I originally offered the NebulAnaly
Mark Johnson wrote:
> Tony:
> What's the fastest path for someone who's been providing
> the CSV's for the last 10 years and wants to deliver
> something more complete. I don't want to spend a lot of
> my client's money on packages.
When I originally offered the NebulAnalysis package it was only
columns, add column headers, etc, etc, even to the extent of using
Excel's "macro recorder". So, it might take a couple of goes to get it
right, but once it's there, it's there forever
But, I suppose that'd apply to XML as well as .csv
It works - and it's cheap
Anyone looking for the SYLK format can go to:
http://www.wotsit.org/search.asp?page=2&s=database
Craig
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
: Sunday, October 23, 2005 5:46 PM
Subject: RE: [U2] [UV][OT]Embed command in CSV file? [ad]
> Barry Brevik wrote:
> > ...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 wrote:
> ...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?
The DIY solution is to use XML, for which there are examples around the
Net. It's always amazed me that most IT people think that a
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.
SL
users@listserver.u2ug.org'
Subject: RE: [U2] [UV][OT]Embed command in CSV file?
>However, if your users are on Office 2003, you might be best off
>creating your document as XML where you will have access to complete
Sadly, we are not uniformly on Office 2003, but I like the idea of usin
AM
> To: 'u2-users@listserver.u2ug.org'
> Subject: RE: [U2] [UV][OT]Embed command in CSV file?
>
>
> >However, if your users are on Office 2003, you might
> be best off
> >creating your document as XML where you will have access
> to complete
>
>
>However, if your users are on Office 2003, you might be best off
>creating your document as XML where you will have access to complete
Sadly, we are not uniformly on Office 2003, but I like the idea of using
XML. I already use HTML extensively in my reports, and I use alot of CSS and
Java
>Instead of using CSV, you could use SLK Format
> ("Symbolic Link Format"). It is slightly more work
Ah, I believe I remember this format from the Lotus days.
I am interested in this idea. I don't suppose you have a link to any SLK
format specifications?
Barry
---
u2-users mailing list
u2-us
>From universe, I am creating a sequential file which is formatted as
a CSV
[snip]
>...does anyone know if it is possible to embed some kind of command
Barry, no, it's not possible in csv, closest is to embed a formula.
However, if your users are on Office 2003, you migh
Hi Barry,
Why don't you do a macro in excel that will do the Format/row/autofit and
let your users have it?
Louie
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik
Sent: 20 October 2005 20:05
To: U2-users (E-mail)
Subject: [U2] [UV][OT]Embed c
16 matches
Mail list logo