Creating an spreadsheet as an e-mail attachment sprdsht line data is GT 255

Morning,

I can create an e-mail with a spreadsheet attachment. Unfortunately the line data that I want to include in each line of the spreadsheet is greater than 255 characters. This is a problem as the function module I am using SO_DOCUMENT_SEND_API1 will only permit a line length of 255 characters because the parameter contents_bin is a table of line type SOLISTI1. The line type SOLISTI1 consists of one field which is 255 characters in length.

Does anyone know of a way of getting more than 255 characters into each line of the excel spreadsheet?

I would prefer to use business communication server classes (e.g. CL_BCS) to implement the solution if possible. However, I have the same issue there. When I call the method DOCUMENT->ADD_ATTACHMENT where DOCUMENT is an instance of class CL_DOCUMENT_BCS the parameters I_ATT_CONTENT_TEXT and I_ATT_CONTENT_HEX are based upon table types SOLI_TAB and SOLIX_TAB. Table types SOLI_TAB and SOLIX_TAB are based upon line types SOLI and SOLIX respectively. Both of these line types have one field LINE. The respective data elements are limited to 255 characters - SO_TEXT255 and SO_RAW255.

Any assistance would be very much appreciated.

Thanks and regards

John.