Search
Thursday, August 28, 2008 ..:: Forum ::.. Register  Login
 
  Forum  Templates  Excel  Numeric data in generated Excel sheet
Disabled Previous
 
Next Next
New Post 1/30/2008 12:21 PM
  rfligg
43 posts
7th Level Poster


Numeric data in generated Excel sheet 
Modified By rfligg  on 1/30/2008 2:31:30 PM)

 

 

 

Hello,

I need to sum numeric data in generated Excel sheet but I encountered a problem:

1. When I use formatted data (<wr:out select=\"self::node()/@att2\" type=\"NUMBER\" pattern=\"#,##0.00\"/>), I can sum numeric data in range (0,1000) (i.e. only positive numbers without thousand separator)

2. Without formatting, I can sum only positive numbers.

I've attached a sample file.

Is there any way to generate an Excel sheet, where the numeric fields can be used as numbers?

We are running version 4.1.65

Thanks,

Jan

 
 sample.zip
New Post 1/30/2008 3:35 PM
  rfligg
43 posts
7th Level Poster


Re: Numeric data in generated Excel sheet 

Jan,

The solution you are looking for cannot be done in version 4.X.  In version 6.X it can be accomplished.  This would be done by creating your same forEach loop and OUT tags without number formatting and type formatting and placing this in an Excel spreadsheet and saving in XLSX format (the current template format for AutoTag for MS Excel).  To save in this format if you are using MS Office 2003 you will need to download and install the MS Office 2007 Compatibility Pack located here:  Office 2007 Compatibility Pack .  To achieve the number formatting simply select the cells you want formatted in MS Excel and choose the formatting for the number output you desire natively in MS Excel.  You can add the native Excel SUM function by clicking on the SUM button and then selecting the cell of the tag whose values you would like to sum.  The template attached to this post demonstrates this.

 

    --Ryan

 
 sample-altered-XLSX.zip
Disabled Previous
 
Next Next
  Forum  Templates  Excel  Numeric data in generated Excel sheet
Membership Membership:
Latest New User Latest: louisedean
New Today New Today: 0
New Yesterday New Yesterday: 0
User Count Overall: 55

People Online People Online:
Visitors Visitors: 34
Members Members: 0
Total Total: 34

Online Now Online Now:
All contents copyright (c) 2002 - 2008 by Windward Studios, Inc. All Rights Reserved.   Terms Of Use  Privacy Statement