Inserting data in excel sheet stored in KM using WebDynPro code...

[former_member213219]

Hi All,

I am trying to create a webdynpro application in which we are taking two values from user let say firstname and lastname and finally on click of submit button an action will be fired which will take the values and insert the same in an excel sheet stored in KM i.e. firstname should go inside firstname column and same should happen for lastname.

I am trying to work on the above requirement as suggested by one of the blog:

String dataString = new String(u2033contentu2033);

ByteArrayInputStream dataStream = new ByteArrayInputStream(dataString.getBytes());

IContent newContent = new Content(dataStream, u2033excelu2033, dataStream.available());

resource.updateContent(newContent);

But here how will we put the value in the respective columns i.e. firstname should go inside firstname column in excel sheet.

Can someone guide me urgently.

Thanks,

Harish

[former_member388485]

Hi,

You can use [Apache POI|http://poi.apache.org/].

There is an example in this [article|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/d0cc41cb-9576-2b10-99a6-ab90ef28c73b&overridelayout=true] by Ayyapparaj KV.

Regards,

Avishai Zamir