DOI and Excel

[Former Member]

Hi

I have been searching for information on Desktop Office Integration and Excel specifically and found nothing on my problem. I am relatively new to ABAP.

I have a FM that returns a table full of paragraphs (with a line number and text line of 255 characters to denote the text in the paragraph). That's fine, the problem comes on extracting these multiple lines of text to Excel. The soi_generic_item type declares a row(4), column(4)and value(255). Now this value(255) is the limiting factor. I can write out 255 characters of text, but cannot join multiple lines together as they are truncated.

<i> lt_val type soi_generic_table,

lf_val type soi_generic_item.

loop at gt_txt into gf_txt.

case gf_txt-linno.

when 1.

lf_val-value = gf_txt-txtln.

when others.

concatenate lf_val-value

' '

gf_txt-txtln

into lf_val-value.

endcase.

append lf_val to lt_val.

endloop.</i>

If there is 1 line it is ok. If there are multiple lines (field LINNO for example could be line 15) then yes it appends, but as "lf_val-value" is 255 characters, it will get truncated and displays in Excel only the first 255 characters.

The export parameter contents is of type soi_generic_table, comprised of soi_generic_item.

<i> call method hnd_excel_sheet->set_ranges_data

exporting

ranges = lt_rng

contents = lt_val

updating = -1

no_flush = 'X'

importing

error = o_error

retcode = gs_rcode.</i>

I would like to be able to output to Excel approximately 3000 characters.

Is there a limit on the number of chars Excel can receive? In this case, it looks like 255.

I am writing out other types of data to other cells, such as dates and numerics. This all works ok.

Any pointers would be gladly appreciated.

Thanks

Nick

[Former Member]

Hi Nick,

If you want documents on Desktop Office Integration,

just check these links.

http://www.esnips.com/doc/741a848e-f49a-4436-bec4-e21950f6c94c/desktop-office-integration.pdf

http://www.esnips.com/doc/2080a9ec-64f9-49c4-bd03-d9f56bc2437c/MSWord--Excel-with-ABAP.pdf

Regards,

SP.

[Former Member]

Sylendra

I have the first PDF and used that in the first instance to figure out what I needed. Yes there is an Important Considerations section under the Spreadsheet interface, which mentions soi_generic_table and value being 256.

As for the 2nd PDF that is OLE and from what I gathered before, that would mean I would have to close the spreadsheet interface, reopen using the OLE methods and populate Excel. This to me would seem a bit daft to do this. I understand from another post that someone said it works in OLE, but not using the DOI.

The spreadsheet is a pre formatted 10 worksheet spreadsheet, I have managed to populate 3 of them and have data being exported, I am just stuck on this one.

Regards

Nick

[Former Member]

Hi Nick,

Please end me ur email address i will send u PDF for Dekstop Intergration which covers every thing.

Sure it will help u

Mark Helpfull answers ( Rewards Points )

Regards

Manoj

[Former Member]

Manoj

If this is the same PDF as Sylendra's post, then I have that already.

I used that to start with. It is helpful, but no real world examples included and doesn't give you example of how to use them. I ended up using "insert_range" then "set_range_data" only to find out they were the wrong way around.

Regards

Nick

[Former Member]

Hi Nick,

Can you please explain me how you have uploaded, because i am facing same problem?

Cell is having below mentioned data:

"The programme design was accepted by the NS and fully funded by donors.

Delegation OD team were generally very competent. Many NS counterparts were

excellent though some were less effective and required coaching. Projects were

generally achieved according to plan and budget, though external factors and

the NS context meant that some of the original plans had to be amended. The

external programme evaluation was completed satisfactorily and yielded useful

results both for Serbia Montenegro and for the Federation generally"

If possible please send code?

-Rajneesh Gupta

Edited by: Rajneesh Gupta on Jul 31, 2009 12:40 PM

Edited by: Rajneesh Gupta on Jul 31, 2009 12:40 PM