Skip to Content
avatar image
Former Member

setting cell format in i_oi_spreadsheet

Hi all,

We are using class i_oi_spreadsheet to export data from SAP to an Excel sheet. We create a new document, so we don't use an existing Excel template.

One of the columns we export contains only numbers, and in Excel they arrive without leading 0's. So if we have '0100' in one cell it arrives in Excel as '100'... but this is not what we want.

Any idea how to 'instruct' Excel that he should keep it as '0100'?

Thanks,

ioana

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 02, 2004 at 01:41 PM

    Hello Ioana,

    The simpliest way is to define the field as CHAR and move

    the "0100" into it

    and add a SPACE as first sign => " 0100". Then it works.

    BR

    Michael

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 03, 2004 at 08:29 AM

    Hi

    You can set the format of the column to be "Text". But this has to be done before the data is moved to excel. As you can creating a new excel file, this should not be problem for you.

    Hope it helps.

    Balaji

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 05, 2004 at 09:44 PM

    Hi!

    I haven't dealed with this topic and even not tried but I reply with the thought that it may help.

    Have you tried these methods of the interface "I_OI_SPREADSHEET":

    "SET_FORMAT"

    "SET_FORMAT_STRING"

    "SET_RANGES_FORMAT"

    ???

    *--Serdar

    Add comment
    10|10000 characters needed characters exceeded