Hi Chris
I would investigate Tony's product first - that may well save you a bunch of
work. I'm generating OpenXML from a number of different places - so if your
requirement is for UniVerse only I'd look to Nebula and see if it covers
your needs.
If you do find afterwards that you still want to
: Re: [U2] import data to excel sheet...
Hi Chris
I would investigate Tony's product first - that may well save you a bunch of
work. I'm generating OpenXML from a number of different places - so if your
requirement is for UniVerse only I'd look to Nebula and see if it covers
your needs
It's worth mentioning that NebulaXLite does exactly what Brian
describes, but without the developer needing to touch the XML. I
manage all of that so that the developer just works with BASIC
arrays containing data and style info. The process of creating a
spreadsheet is similar to creating a
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 on
...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: Tuesday, April 13, 2010 1:49 AM
To: 'U2 Users List'
Subject: Re: [U2] import data to excel sheet...
This is a function of the operating system. On Unix systems only a
linefeed
character is added to the end of a line whereas on Windows both
carriage
return
in
the spreadsheet.
If I wanted to make a word appear as blue or in bold, how are you guys doing
this?
Thanks.
-Chris
Date: Mon, 12 Apr 2010 11:47:20 -0700
From: jacque...@yahoo.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] import data to excel sheet...
Hi Jaweed,
If you
the OpenXML SDK
2.0 or an equivalent toolkit.
Brian
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 13 April 2010 3:48 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] import data to excel sheet
: [U2] import data to excel sheet...
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
be very
useful for our needs here. I appreciate the response.
-Chris
From: br...@brianleach.co.uk
To: u2-users@listserver.u2ug.org
Date: Tue, 13 Apr 2010 16:44:31 +0100
Subject: Re: [U2] import data to excel sheet...
Chris
I'm using OpenXML to create spreadsheets in Excel 2007 format
appear as blue or in bold, how are you guys doing
this?
Thanks.
-Chris
Date: Mon, 12 Apr 2010 11:47:20 -0700
From: jacque...@yahoo.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] import data to excel sheet...
Hi Jaweed,
If you already produced a number of files with the CHAR(13
there
for that?
I know Brian mentioned he was writing an article, I would be very inclined to
read it.
-Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Tue, 13 Apr 2010 10:47:58 -0500
Subject: Re: [U2] import data to excel sheet...
also see:
http
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
: Mon, 12 Apr 2010 11:47:20 -0700
From: jacque...@yahoo.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] import data to excel sheet...
Hi Jaweed,
If you already produced a number of files with the CHAR(13) as the end of
line separator, you probably still handle them with excel, if you
Austin
Sent: Tuesday, April 13, 2010 12:03 PM
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
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 for the
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 13 April 2010 16:54
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] import data to excel sheet...
Brian,
I was curious if you had an example of how you can setup your spreadsheet
directly from UniVerse by treating
: Re: [U2] import data to excel sheet...
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
Can anyone tell me what is wrong with the following code for importing data
from txt file to an excel sheet, when its launch
Excel it giving some error message, but when I open the downloaded file from
my disc, all the data is in one line with some especial
Chars. Any help will be appreciated.
(10) should do it.
Good luck!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed
Sent: Monday, April 12, 2010 7:53 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] import data to excel sheet...
Can anyone tell me
to the CSV going and add in the other layers as you go.
From: robert.hou...@fwic.net
To: u2-users@listserver.u2ug.org
Date: Mon, 12 Apr 2010 09:01:03 -0700
Subject: Re: [U2] import data to excel sheet...
Hi Jaweed,
I haven't looked too closely at your code, but I did notice on thing that I
] import data to excel sheet...
Hi Jaweed,
I haven't looked too closely at your code, but I did notice on thing that I
would consider the most likely candidate:
CHAR(13) is a carriage return, not a line feed. Try using CHAR(10) instead
for your LINE.FEED variable. You might have to use CHAR(13
Always glad to help! :)
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed
Sent: Monday, April 12, 2010 9:23 AM
To: 'U2 Users List'
Subject: Re: [U2] import data to excel sheet...
Hey Robert Houben,
It worked
the Mac uses CHAR(13) as
an EOL separator, the import should work.
- Original Message
From: Robert Houben robert.hou...@fwic.net
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, April 12, 2010 12:01:03 PM
Subject: Re: [U2] import data to excel sheet...
Hi Jaweed,
I haven't
-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: Monday, April 12, 2010 11:01 AM
To: U2 Users List
Subject: Re: [U2] import data to excel sheet...
Hi Jaweed,
I haven't looked too closely at your code, but I did notice
24 matches
Mail list logo