I've used the NebulaXlite -- it's good -- has a learning curve - but once
you get the rhythm it makes getting a 'pretty' spreadsheet put together not
that tough. I have a customer that uses it weekly to produce what was a
problem as a "CSV" file just because of the 'perception' that it should look
Has anyone done this successfully using the IBM UniOLEDB driver? I have a
customer struggling with this and I just don't have the background with
UniOLEDB.
-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://
I have closed this email account!
Please resend email to dprav...@hotmail.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Office 2007 and above stores its data in xml files now. .xls files are old.
All you need is to lookup the xml spec on msdn and write out to it in
databasic. There are heaps of resources on the xml format - just google it.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mai
> > From: Bill Haskett
> > You may want to simplify your life and pick up NebulaXLite.
> > http://nebula-rnd.com/products/xlite.htm
> From: Chris Austin
> That program actually seems perfect for what I'm
> looking to do Bill. Do you guys use this at your work?
> Is it a decent product?
Thanks f
my only problem was I was trying to get it to work with Excel 2000, which
has a very limited XML ability. But anything above 2003 if fairly XML compliant.
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Chris
I use an Excel template with a VBA macro to do the formatting - fonts,
colours, totals and so on.
I start the template within the Basic program after the csv-file has
been written to the user's temp directory on the c: drive.
The macro automatically loads the csv-file, formats it, then copies the
f
That program actually seems perfect for what I'm looking to do Bill. Do you guys
use this at your work? Is it a decent product?
-Chris
> Date: Tue, 13 Apr 2010 09:11:25 -0700
> From: wphask...@advantos.net
> To: U2-users@listserver.u2ug.org
> Subject: Re: [U2] import data to excel sheet...
>
>
Gerorge,
Thanks a ton! I think I will try to get OpenXML working now that I see how the
XML documents
are built up and make up the spreadsheet. It just seems very tedious to
manually create the XML
files. Now as far as getting OpenXML to work with universe, is there any
documentation out ther
Chris:
You may want to simplify your life and pick up NebulaXLite.
http://nebula-rnd.com/products/xlite.htm
HTH,
Bill
Chris Austin said the following on 4/13/2010 7:48 AM:
I was curious if there is an easy way to add
Brian,
I was curious if you had an example of how you can setup your spreadsheet
directly from UniVerse by treating the content as XML?
Are you physically writing to a .XLS type file from universe but in an XML
format?
Also, I wouldn't mind looking into OpenXML, that sounds like it may be ve
also see:
http://blogs.msdn.com/brian_jones/archive/2005/06/27/433152.aspx
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Brian Leach
> Sent: Tuesday, April 13, 2010 11:45 AM
> To: 'U2 Users List'
> Subject:
Chris
I'm using OpenXML to create spreadsheets in Excel 2007 format: and writing a
series in Spectrum about it. You can create the spreadsheets directly from
UniVerse by treating the content as XML (with a number of caveats) or you
can call out to something external that will build it using the Op
I was curious if there is an easy way to add font formatting to the .CSV files
I have been creating from UniVerse.
Right now we just write to a sequential file and call it .csv and just
use comma's to separate
the data. We then use a carriage return CHAR(13) to return to the next line in
the sp
You do realize that you have more of a chance of finding a job in India than
you do here, right. Most of the jobs here have been outsourced to your
country or China.
Jerry Banker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On
You can also use tr for this. For example to convert CHAR(13) to CHAR(10):
tr '\r' '\n' < source.csv > destination.csv
- Original Message
From: "charles_shaf...@ntn-bower.com"
To: U2 Users List
Sent: Tue, April 13, 2010 8:36:44 AM
Subject: Re: [U2] import data to excel sheet...
one method I use is I create the file using on unix with just the lf, then
I use zip to compress the file, converting the lf -> lf/cr, then transfer the
file to the windows system
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2u
Don't know if this helps, but UNIX generally provides a pair of utilities
called dos2unix and unix2dos that handle the conversion. They can be used
in scripts, etc.
>>This is a function of the operating system. On Unix systems only a
linefeed
>>character is added to the end of a line whereas o
We host at ukfast who provide the hardware and os's we then install udt and
our applications on there.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bryan Evans
Sent: 12 April 2010 19:00
To: U2 Users List
Subject:
19 matches
Mail list logo
