topic Re: ABAP ole, select column in Application Development and Automation Discussions

ABAP ole, select column

Ronnn — Wed, 18 Dec 2013 13:45:07 GMT

Hi ABAP Gurus,

I want to execute some commands in Excel. I need to past some data from Excel into the sheet. Large numbers however are notated in a scientific way e.g. 3453+e10, but I want them to written in full e.g. 345383982034.

I know this can be done when the column in which the data is about to be past has properties as text. I can manage in doing this by command:

h_column 'NumberFormat' = '@'.

But I first need to select the whole column (column A), and I do not want to select a range, since I don't know the amount of lines available at run-time.

I've tried retrieving usable code from the macro that I have recorded, but I somehow can't get it working.

Anyone has an example how to fix this?

many thanks,

Ron.

Re: ABAP ole, select column

jayaprakashhj — Thu, 19 Dec 2013 08:22:15 GMT

Hi,

are you passing data from Excel to internal table or from internal table to Excel?

I had this problem sometimes ago and found soln.

But let me know clearly what is your issue.

Regs,

Re: ABAP ole, select column

Ronnn — Thu, 19 Dec 2013 16:03:29 GMT

Hi Jayaprakash,

I found the answer already. To be correct (and now I have noticed the error in my post) I neede to extract data from SAP into Excel.

I solved it, by selecting the column with

call method of

          h_excel

          'Columns' = h_column

        exporting

          #1        = 'A:A'.    " <--- -first column

      call method of

          h_column

          'Select'.

(in a nutshell). But that did the trick. Thanks for replying though!

regards,

Ron.