hi one can generate excel report using download latest jar from EXCELREPORTGENERATOR if u are using version 4.0.1 then u can specify the path desired location and the file name in the code itself and then then add this jar in project build path and then in project make test cases and then in testng.xml file specify suite name, class name and test name and then and then create the class and paste the following code and then refresh the package , result will be gerated at your desired location
import java.io.IOException;
import javax.xml.parsers.ParserConfigurationException;
import org.xml.sax.SAXException;
public class ExcelGenerate {
public static void main(String[]args) throws ParserConfigurationException, IOException, SAXException
{
ExcelReportGenerator.generateExcelReport(“MyProject.xls”, “D:\\workspace”);