-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joshua Gallant
Sent: Thursday, February 09, 2012 11:44 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
I was going to ask the same question about embedded
On 09/02/12 16:55, Charlie Noah wrote:
Hi Josh,
I'd be happy to share my routines with you, if they would be of any use.
I have a program I use to load a csv file, and a subroutine which
converts back and forth between csv, dynamic and fixed width, either a
line at a time or an entire flat
On 09/02/12 16:47, Charlie Noah wrote:
I'm exporting from Excel and importing into jBASE. DCOUNTing on the
header line is an excellent idea. I'll give that a try. Since I'm using
a convert routine, if that fixes the problem, it will be fixed for any
spreadsheet I import.
It may very well be
Hi Wol,
Yes, many people have written their own routines, and the ones on
Pickwiki do most of the things mine do. Different strokes...
Regards,
Charlie
On 02-11-2012 5:22 AM, Wols Lists wrote:
On 09/02/12 16:55, Charlie Noah wrote:
Hi Josh,
I'd be happy to share my routines with you, if
Yes, parsing csv is a pain. So far it may just be easier to default
format the column, at least until I can get my distributor to fix the
spreadsheet. I save as tab delimited, and as long as I remember to
format first, everything is OK.
Thanks,
Charlie
On 02-11-2012 5:27 AM, Wols Lists
Sent: Thursday, February 09, 2012 11:44 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
I was going to ask the same question about embedded line feeds. I've been
dealing with a lot of outside companies the last few months transferring
data and found a lot have embedded line
On 11/02/12 15:38, Israel, John R. wrote:
Windows uses a CR LF where UNIX uses just one (I forget which as I sit at
home). The other is converted to a FM. Stripping off the offending
character from Windows will still leave the file in a traditional FM
delimited structure that is easy to
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester
Sent: Monday, February 06, 2012 5:45 PM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
It's been my experience in the past that you can avoid issues with the
comma delimeter as long as you enclose your
Thanks Don! This is quite nice -- and well documented!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don
Sent: Wednesday, February 08, 2012 9:15 PM
To: 'U2 Users List'
Subject: Re: [U2] Building an Excel File [AD
Of Charlie Noah
Sent: 09 February 2012 14:46
To: U2 Users List
Subject: Re: [U2] Building an Excel File
While everyone is thinking about CSV and Excel, maybe I can get a solution
to a problem that's been plaguing me for a long time.
First, let me say that it's been my experience that Excel
-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Thursday, February 09, 2012 10:54 AM
To: 'U2 Users List'
Subject: Re: [U2] Building an Excel File
This is standard and documented behaviour of a csv - if you have a cell
it, or have it skip a
column as well.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Thursday, February 09, 2012 9:46 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
While everyone
Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Thursday, February 09, 2012 11:06 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
Thanks George. I changed the tabs to pipes just to display them
To: U2 Users List
Subject: Re: [U2] Building an Excel File
While everyone is thinking about CSV and Excel, maybe I can get a solution
to a problem that's been plaguing me for a long time.
First, let me say that it's been my experience that Excel (and Open Office,
which emulates Excel /so /well) has
Sent: Thursday, February 09, 2012 11:06 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
Thanks George. I changed the tabs to pipes just to display them here.
Normally I save as tab delimited with no surrounding character. Since
the cell contents copies and pastes as 2 lines, I'm
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Thursday, February 09, 2012 11:22 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
It's certainly possible, although I can't detect it. Do you know how I
would see it in the spreadsheet itself?
Charlie
On 02
] On Behalf Of Charlie Noah
Sent: Thursday, February 09, 2012 11:06 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
Thanks George. I changed the tabs to pipes just to display them here.
Normally I save as tab delimited with no surrounding character. Since
the cell contents
: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Thursday, February 09, 2012 11:06 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
Thanks George. I changed the tabs to pipes just to display them here.
Normally I save
-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Thursday, February 09, 2012 11:22 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
It's certainly possible, although I can't detect it. Do you know how I
would see
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: 09 February 2012 16:31
To: U2 Users List
Subject: Re: [U2] Building an Excel File
BTW, this occurs usually, when a textbox is used for data entry, someone
pastes
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Thursday, February 09, 2012 11:06 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
Thanks George. I changed the tabs to pipes just to display them
Gallen
Sent: 09 February 2012 16:31
To: U2 Users List
Subject: Re: [U2] Building an Excel File
BTW, this occurs usually, when a textbox is used for data entry, someone
pastes a URL, then hits the ENTER key And then types some more data. To the
original database/excel file it's one cell (.xls file
Of Symeon Breen
Sent: Thursday, February 09, 2012 11:53 AM
To: 'U2 Users List'
Subject: Re: [U2] Building an Excel File
It is entitrely possible and ok to have new lines inside a cell in excel and
inside a cell in a csv
The following
col1,2,col3 and
New line,col4
Is ok because the new line
To: U2 Users List
Subject: Re: [U2] Building an Excel File
I was going to ask the same question about embedded line feeds. I've been
dealing with a lot of outside companies the last few months transferring data
and found a lot have embedded line feeds all over.
- Josh
On 2/9/12 11:11 AM
of the row.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Thursday, February 09, 2012 11:57 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
The problem occurs before it ever
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: February-09-12 9:04 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
What Symeon suggests should still work, since the break is inside the quotes
(assuming your using Quoted csv and not tabs), so if you go
.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: February-09-12 9:04 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
What Symeon suggests should still work, since the break is inside
Until someone decides to skip trailing, empty columns... :o
YMMV
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: February-09-12 9:25 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
: February-09-12 9:25 AM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
Hmmm... getting a bit complicated now. I think George's suggestion to DCOUNT
the header line and concat if the number of columns are less might be simpler.
I really appreciate all the ideas, though. They give me something
] Building an Excel File
Thanks George. I changed the tabs to pipes just to display them here.
Normally I save as tab delimited with no surrounding character. Since
the cell contents copies and pastes as 2 lines, I'm not sure whether
these suggestions would solve my problem.
Thanks again
Since the discussion has shifted from building Excel to consuming
CSV, here's a reminder that I have a little utility on my
freeware page called ExcelExport, which exports multiple sheets
from a workbook into quoted CSV.
http://nebula-rnd.com/freeware/
There is also a page dedicated to CSV at
Sorry to come in a bit late here. I have worked through a couple of
versions of NebulaXLite and must say I am very impressed, with
both the astounding results and the thoughtful improvements Tony
has made to this breakthrough tool. If you have a requirement to
clone an existing spreadsheet, but
Sent: Thursday, February 09, 2012 3:16 PM
To: U2 Users List
Subject: Re: [U2] Building an Excel File [AD]
Sorry to come in a bit late here. I have worked through a couple of
versions of NebulaXLite and must say I am very impressed, with both the
astounding results and the thoughtful improvements
: Re: [U2] Building an Excel File [AD-FREE]
Thanks Don! This is quite nice -- and well documented!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don
Sent: Wednesday, February 08, 2012 9:15 PM
To: 'U2 Users List
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, February 06, 2012 4:45 PM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
Can they open an XML file coded for Excel
programs?
-Original Message-
From: Joshua Gallant jgall...@cbd.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, Feb 7, 2012 12:41 pm
Subject: Re: [U2] Building an Excel File
We were running JET until our latest UniVerse upgrade earlier this year.
e used it all over
: Tue, Feb 7, 2012 11:37 pm
Subject: Re: [U2] Building an Excel File
Wil, you didn't say 'I', so you're not saying it 'again'.
responded to what you said.
You're doing that troll thing again.
o again, I say - Just stop it man.
From: Wjhonson
And again I never said csv was Excel.
From: Wjhonson
ding ding ding... gentlemen, to your corners...
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I'm curious; was the university in Florida Barry University?
Someone I worked with years ago went there as a Pick programmer.
The following code might be helpful
subroutine ucsv(result,source,status,is.oconv)
*
* Public Domain program for OpenQM by Keith Johnson 2012
*
* OCONV Converts
No, it was Stetson University in Deland.
On 02-08-2012 4:47 PM, Keith Johnson [DATACOM] wrote:
I'm curious; was the university in Florida Barry University?
Someone I worked with years ago went there as a Pick programmer.
The following code might be helpful
subroutine
@listserver.u2ug.org
Subject: Re: [U2] Building an Excel File
Wil, while the OP asked about reading Excel on an iPhone, the
title of the thread is Building an Excel File. That prompted
suggestions for how to create Excel, including use CSV.
Yes, all spreadsheet clients including Excel will open a CSV
file
Hi Bob,
I don't suppose CrowFlite can be obtained these days, can it? It looks
like Phil has retired. If it were available, would it work with the
newer versions of Excel? What about Open Office?
In the 80s I worked for a university in Florida, where we used a
Pick-based spreadsheet modeled
.
If I have missed something, let me know.
John
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard A. Wilson
Sent: Monday, February 06, 2012 4:50 PM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
try
] Building an Excel File
try this subroutine. Note it is written for an old Revelation G2b application
so change as needed
Rich
SUBROUTINE
EXCEL_SCRIPTS_SUBR(RESULT,PROCESS,FROM.FILE,TO.FILE,EXTRA.INFORMATION)
*
*
* Purpose
This looks VERY promising!
Thanks
John
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera
Sent: Monday, February 06, 2012 7:04 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Building an Excel File
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Monday, February 06, 2012 8:06 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Building an Excel File
Not responding to any particular quote here, just the CSV topic in general.
Respected colleagues, CSV
Compusheet? I remember working with that!
-Dianne
On 2/7/2012 6:50 AM, Charlie Noah wrote:
Hi Bob,
I don't suppose CrowFlite can be obtained these days, can it? It looks
like Phil has retired. If it were available, would it work with the
newer versions of Excel? What about Open Office?
In
Hi Dianne,
You're telling your age here! ;^)
Actually, it was EasyCalc, which was probably very similar to Compusheet.
Charlie
On 02-07-2012 9:30 AM, Dianne Ackerman wrote:
Compusheet? I remember working with that!
-Dianne
On 2/7/2012 6:50 AM, Charlie Noah wrote:
Hi Bob,
I don't suppose
On 2/7/2012 6:50 AM, Charlie Noah wrote:
Hi Bob,
I don't suppose CrowFlite can be obtained these days, can it? It looks like
Phil has retired. If it were available, would it work with the newer
versions of Excel? What about Open Office?
CrowFlite is long out of date, both in support of
Hm, don't remember EasyCalc, but Compusheet was on a Reality system. It
was so much easier when we only had to know what was native in our own
systems and not be concerned with a million different things to connect
to in the outside world!
-Dianne
On 2/7/2012 10:45 AM, Charlie Noah wrote:
Amen! I don't think I would want to go back to 9600 baud serial
communications, though. My first Reality job was contract programming
for a local service bureau, using an ADDS Viewpoint terminal and 300
baud acoustical coupler. They handed me the terminal, modem and a set of
manuals and said
-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: 07 February 2012 16:13
To: U2 Users List
Subject: Re: [U2] Building an Excel File
Amen! I don't think I would want to go back to 9600 baud serial
communications, though. My first Reality job
Dig it up and market it because Universe is no longer offering JET.
-Original Message-
From: Brian Leach br...@brianleach.co.uk
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Tue, Feb 7, 2012 9:43 am
Subject: Re: [U2] Building an Excel File
IIRC didn't VMARK buy CompuSheet
-
From: Brian Leach br...@brianleach.co.uk
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Tue, Feb 7, 2012 9:43 am
Subject: Re: [U2] Building an Excel File
IIRC didn't VMARK buy CompuSheet, at around the same time they bought JET?
t's probably lying around on and old QIC somewhere..
I'd
with no
problems.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green
Sent: Tuesday, February 07, 2012 7:20 AM
To: 'U2 Users List'
Subject: Re: [U2] Building an Excel File
I have to say amen to Tony's comments. Why
across with no
problems.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green
Sent: Tuesday, February 07, 2012 7:20 AM
To: 'U2 Users List'
Subject: Re: [U2] Building an Excel File
I have to say amen
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood
Sent: Tuesday, February 07, 2012 12:57 PM
To: 'U2 Users List'
Subject: Re: [U2] Building an Excel File
why when i was writing interfaces we did it with rocks and sticks, AND we
had to walk through the snow
@listserver.u2ug.org
Sent: Tue, Feb 7, 2012 10:08 am
Subject: Re: [U2] Building an Excel File
Why back in our day, the bits traveled at 110 baud, and simplex too.
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
n Behalf Of Allen E. Elwood
Users List u2-users@listserver.u2ug.org
Sent: Tue, Feb 7, 2012 10:08 am
Subject: Re: [U2] Building an Excel File
Why back in our day, the bits traveled at 110 baud, and simplex too.
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
n
the bits back in order!
-Original Message-
From: George Gallenggal...@wyanokegroup.com
To: U2 Users Listu2-users@listserver.u2ug.org
Sent: Tue, Feb 7, 2012 10:08 am
Subject: Re: [U2] Building an Excel File
Why back in our day, the bits traveled at 110 baud, and simplex too
Just think if you had dropped them IN order you could now be in the Data
Processing Hall of Fame !
-Original Message-
From: Dianne Ackerman dia...@aptron.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, Feb 7, 2012 10:32 am
Subject: Re: [U2] Building an Excel File
Ick
To: U2 Users List
Subject: Re: [U2] Building an Excel File
I have always tried to avoid csv files because we have all kinds of
characters in our descriptions (commas, double and single quotes, etc.)
It is also very easy to build a row of data with 254 delimiters, then
simply convert @FMs to tabs
:
Dig it up and market it because Universe is no longer offering JET.
-Original Message-
From: Brian Leach br...@brianleach.co.uk
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Tue, Feb 7, 2012 9:43 am
Subject: Re: [U2] Building an Excel File
IIRC didn't VMARK buy CompuSheet
is no longer offering JET.
-Original Message-
From: Brian Leachbr...@brianleach.co.uk
To: 'U2 Users List'u2-users@listserver.u2ug.org
Sent: Tue, Feb 7, 2012 9:43 am
Subject: Re: [U2] Building an Excel File
IIRC didn't VMARK buy CompuSheet, at around the same time they bought JET?
t's
So what are they using in place of JET?
Did you ever use JET-EDIT to edit your programs?
-Original Message-
From: Joshua Gallant jgall...@cbd.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, Feb 7, 2012 12:41 pm
Subject: Re: [U2] Building an Excel File
We were running
From: Bob Rasmussen
It would be conceivable, though not necessarily
profitable, to have an Excel add-in that would pull
data out of Pick via a network-based object call.
Conceivable? How about Done. Phil Gerber has referred people to
NebulaXChange as the replacement for CrowFlite.
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Tuesday, February 07, 2012 3:18 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Building an Excel File
From: Bob Rasmussen
It would be conceivable, though not necessarily profitable, to have an
Excel
Sorry, Tony, I should have been aware of your offerings.
Maybe you need to charge A LOT for your product, and then people would be
interested :-)
On Tue, 7 Feb 2012, Tony Gravagno wrote:
From: Bob Rasmussen
It would be conceivable, though not necessarily
profitable, to have an Excel
.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Monday, February 06, 2012 10:06 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Building an Excel File
Not responding to any particular quote
I think somewhere this jumped the track.
No one is saying that CSV is Excel
Rather the OP wanted a way to read an Excel file on the Iphone.
Can the Iphone natively read Excel files?
I know that it can natively read csv files, because we're doing it.
It puts the csv file into a neat table with a
Wil, while the OP asked about reading Excel on an iPhone, the
title of the thread is Building an Excel File. That prompted
suggestions for how to create Excel, including use CSV.
Yes, all spreadsheet clients including Excel will open a CSV
file.
But that led to my assertion that CSV is not
sounds awesome tony, really. rocket shouldn't launch without it
:-)
On 2/7/2012 7:14 PM, Tony Gravagno wrote:
Wil, while the OP asked about reading Excel on an iPhone, the
title of the thread is Building an Excel File. That prompted
suggestions for how to create Excel, including use CSV.
, as a
table.
However it does it.
-Original Message-
From: Tony Gravagno 3xk547...@sneakemail.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Tue, Feb 7, 2012 7:15 pm
Subject: Re: [U2] Building an Excel File
Wil, while the OP asked about reading Excel on an iPhone, the
title
Wil, you didn't say 'I', so you're not saying it 'again'.
I responded to what you said.
You're doing that troll thing again.
So again, I say - Just stop it man.
From: Wjhonson
And again I never said csv was Excel.
From: Wjhonson
No one is saying that CSV is Excel
Can they open an XML file coded for Excel, but without formatting and colors
and such?
If so, you may just have to have two files produced, one for the phones and one
for desktops.
I haven't checked, but are there any perl modules that can convert an XML file
to an .xls file
This would
try this subroutine. Note it is written for an old Revelation G2b
application
so change as needed
Rich
SUBROUTINE
EXCEL_SCRIPTS_SUBR(RESULT,PROCESS,FROM.FILE,TO.FILE,EXTRA.INFORMATION)
*
*
* Purpose: Create Excel
, 2012 4:45 PM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
Can they open an XML file coded for Excel, but without formatting and colors
and such?
If so, you may just have to have two files produced, one for the phones and one
for desktops.
I haven't checked, but are there any perl
I will delve into this code tomorrow.
Thanks.
John
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard A. Wilson
Sent: Monday, February 06, 2012 4:50 PM
To: U2 Users List
Subject: Re: [U2] Building an Excel
On 06/02/12 21:44, George Gallen wrote:
I haven't checked, but are there any perl modules that can convert an XML
file to an .xls file
This would require unix, but not any user intervention.
You can get Perl for Windows. Done by ActiveState, I think MS has taken
them over so it's even a
: Monday, February 06, 2012 4:45 PM
o: U2 Users List
ubject: Re: [U2] Building an Excel File
Can they open an XML file coded for Excel, but without formatting and colors
and
uch?
f so, you may just have to have two files produced, one for the phones and one
or desktops.
I haven't checked
I forgot to mention that they will look beautiful, columns and rows all neatly
lined up
-Original Message-
From: Wjhonson wjhon...@aol.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Mon, Feb 6, 2012 2:28 pm
Subject: Re: [U2] Building an Excel File
ebuild the files as csv files
[AD]
NebulaXLite creates rich XML workbooks (multiple sheets) which
can be opened by Google Docs and Open Office, in addition of
course to Excel. The XML isn't Excel-specific, it conforms to
open standards, and Excel happens to open those files as well.
in reliance on, the information contained in or attached to this
message is prohibited.
-Original Message-
From: Israel, John R. johnisr...@daytonsuperior.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Mon, Feb 6, 2012 2:25 pm
Subject: Re: [U2] Building an Excel File
John:
Perhaps the easiest way to do this is with Adobe's ColdFusion.
To get started... the developer version of ColdFusion is free.
--Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent:
, February 06, 2012 4:45 PM
o: U2 Users List
ubject: Re: [U2] Building an Excel File Can they open an XML file
coded for Excel, but without formatting and colors and uch?
f so, you may just have to have two files produced, one for the phones
and one or desktops.
I haven't checked, but are there any
by that.
-Original Message-
From: Israel, John R. johnisr...@daytonsuperior.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Feb 6, 2012 3:27 pm
Subject: Re: [U2] Building an Excel File
I have always tried to avoid csv files because we have all kinds of characters
n our descriptions
in
eliance on, the information contained in or attached to this message is
rohibited.
Original Message-
From: Israel, John R. johnisr...@daytonsuperior.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Mon, Feb 6, 2012 2:25 pm
Subject: Re: [U2] Building an Excel File
I dump csv files and convert to true excel with perl using
Spreadsheet::WriteExcel module. Once scripted it's pretty painless and
automated.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
-
From: Kevin King ke...@precisonline.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Feb 6, 2012 4:02 pm
Subject: Re: [U2] Building an Excel File
The CSV format is really pretty simple. Commas between fields. If a field
ontains a comma or quote it should be quoted. If a field
it.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester
Sent: Monday, February 06, 2012 5:45 PM
To: U2 Users List
Subject: Re: [U2] Building an Excel File
It's been my experience in the past that you can avoid issues
Can the iphone open a true excel file though?
-Original Message-
From: Jeff Butera jbut...@hampshire.edu
To: u2-users u2-users@listserver.u2ug.org
Sent: Mon, Feb 6, 2012 4:04 pm
Subject: Re: [U2] Building an Excel File
I dump csv files and convert to true excel with perl using
Subject: Re: [U2] Building an Excel File
I dump csv files and convert to true excel with perl using
preadsheet::WriteExcel module. Once scripted it's pretty painless and
utomated.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun
Makes one long for CrowFlite, doesn't it?
For those that don't remember, CrowFlite was an add-in to Excel that
allowed it, at a per-cell level, to reach back into a Pick database and
grab individual pieces of data. In other words, it was a pull solution
as well as a push.
I'm cc'ing its
93 matches
Mail list logo