data transfer from sap r/3 into excel sheet for mi01

hi gurus,

as i am a xi consultant i got requirement to write a program for data transfer from sap r/3 into excel sheet for MI01.can any body help me by giving sample code or example for this requirement.please help me.