RE: AS400 file with formulas into Excel

This seems to work for a CSV assuming the right row numbers
have been entered into the formula:

X,X,X,X,1.00,X,X,X,X,X,X,X,X
X,X,X,X,2.00,X,X,X,X,X,X,X,X
,,,,"=Sum(E1:E2)",,,,,,,,


Terry

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Wednesday, July 08, 2009 3:13 PM
To: Midrange Systems Technical Discussion
Subject: Re: AS400 file with formulas into Excel

I second the idea that CSV isn't going to work.

As Pete says, POI is one option. Another is outputting .XML

HTH,
Charles


On Wed, Jul 8, 2009 at 2:40 PM, Pete Helgren<Pete@xxxxxxxxxx> wrote:

Are you outputting to a CSV file? Or are you writing to a POI
interface?  If it is the latter, I'd have to see some code

to understand

how you are writing to the cell.  If it is the former, to

my knowledge

there isn't any way to write a formula to a cvs file that get
"interpreted" into a formula.

Pete

Jeff Wilson wrote:

I can create a file in SQL that has formulas in it (i.e.

'=A1*B1') and I can send them to my PC and open them in Excel
2002. However, the formulas are showing instead of the
results. If I click inside the cell and hit Enter, I get the
value instead of the formula. BUT, I want this automated and
don't want a macro, so I want this to be opened to show the
formula result instead of the formula without doing anything.
I tried using CAST to a few other types, but that didn't
work. It works if I send it as a HTML, but would prefer the
xls extension, if possible. Thanks for any thoughts on this.

-Jeff

--
This is the Midrange Systems Technical Discussion

(MIDRANGE-L) mailing list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Confidentiality Notice:

The preceding e-mail message (including any attachments) contains information that may be confidential, protected by applicable legal privileges, or constitute non-public information. It is intended to be conveyed only to the designated recipient(s). If you are not an intended recipient of this message, please notify the sender by replying to this message and then delete it from your system. Use, dissemination, distribution or reproduction of this message by unintended recipients is
not authorized and may be unlawful.