title: How to generate Pivot table in ExcelSheet Programatically
body: <p>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.</p>