如何以编程方式在ExcelSheet中生成数据透视表

I am required to generate a Pivot table in MS Excel(not in Open Office) dynamically as per the User's query. I am programing in java and MySql(DB),so cant use the windows or MS object directly that's why wana to use VbScript . This vbscript will contain data as well as orentation on the columns in Pivot fieldList .But can any body tell me what script i should be using as i m very new to VB and objects of Excel.I am required to generate a Pivot table in MS E