Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.