Download to excel between two given dates
I already implemented Export to Excel funtionality in webdynpro java. Now i have a requirement to download the data to Excel only between two given dates.
I am taking two dates from the user and based on that it should download data into excel file.
Guide me on this or send pseudocode for this.
Lakshmi Narayana Chowdary Namala replied
If I understand your question correctly,
you are gettting some data from R/3. You need to filter out that data which is in between two given dates , export that data to excel.
If yes, then take one more ValueNode with same structure.
and bind the filtered data to this node.
To filter out model node, use
if( (objDate.compareTo(stDate)>=0) && (objDate.compareTo(endDate)<=0) )
// Create element for value Node , set the values (ie. i'th record values) and add to ValueNode.
Long process, but you can use
Now export the ValueNode to excel
Edited by: Lakshmi Narayana Chowdary Namala on Sep 22, 2008 12:04 PM