RE: AS400 file with formulas into Excel

["Winchester Terry" <terry.winchester@xxxxxxxxxxxxxxx>]

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.