Skip to Content
avatar image
Former Member

Exceding the limit of numbers in Excel at target side

Hi ,

I am working on Proxy to file scenario in that data is coming frm SAP tables at source side data type is string and in target side also data type is string .

But when I am getting the data in .csv excel file if the number are exceding the limit they are converted in Exponational form.

let say in 1 coloum if 15 numbers are coimg then it is ok

if they are coming as a 16 numbers they are converting into 453E+11 form .

Please suggest me on this issue...

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Apr 07, 2010 at 07:05 PM

    Hi Gangadhar,

    Please check this note and see its there or not:

    Note 958486 - Arithmetic or Statistic function returns wrong result

    Also this weblog and help:

    /people/thorsten.nordholmsbirk/blog/2006/04/03/never-ever-use-xis-built-in-arithmetic-functions

    Regards,

    ---Satish

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2010 at 08:39 PM

    That is not anything to do with PI. Expand the column width when you open the file in excel. Automatically you would see the full number.

    If not you might have to create an Excel file instead of CSV file.

    VJ

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Why this happening in case of numbers why not in case of charecters

      Characters will appear as it is....there is no exponential factor for a character....is your excel not getting savedwith Number Formatting?

      If XI is passing the value as 12345678912345 then the value should appear as it is in excel also, if formatting is done to number.

  • avatar image
    Former Member
    Apr 08, 2010 at 08:42 AM

    Hi,

    If you open the CSV file with a text editor, how does the content look like ? Especially for cols > 15 ...

    rgds

    Chris

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 12, 2010 at 03:31 PM

    solved..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 12, 2010 at 03:31 PM

    solved.. user have correct at their side

    Add comment
    10|10000 characters needed characters exceeded