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
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,
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.
revelationWow! You are right! How cool is that?/revelation
That is pretty cool. I noticed that a br in a td results in visually
correct data in Excel, but
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
, 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?
The DIY solution is to use XML, for which there are examples
Anyone looking for the SYLK format can go to:
http://www.wotsit.org/search.asp?page=2s=database
Craig
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Sunday, October 23, 2005 5:46 PM
Subject: RE: [U2] [UV][OT]Embed command in CSV file? [ad]
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.1.361 / Virus Database: 267.12.4/146 - Release Date: 21/10/05
Regards
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
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
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
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
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
: [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 using
XML. I already use HTML
.
SLK seems attractive. Where do I begin.
Thanks
- Original Message -
From: Ewinger Klaus [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
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
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
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
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 might
17 matches
Mail list logo
