Java Code for Storing Data directly in Excel File

[davidson1]

I have a below code which saves 4 html page separately with data and a empty Excel file. This empty Excel file is dependent on this 4 html page data. Only While Opening this Excel file ,Each 4 html page is loading its data into each 4 spreadsheet of this Empty Excel file. Is there any way to modify this code, so that each 4 html page data will be directly load into Excel file in each 4 spreadsheet. Can you please help me? Please let me know if you have any questions? If you know Please modify this below code. I will try in my end.

public void RunReportAndSaveExcelOutput(String reportSearchPath, String saveLocation) 
	{		
		

                Option runOptions[] = new Option[5];
                
	//runOptions = new option[5];

		RunOptionBoolean saveOutput = new RunOptionBoolean();
		saveOutput.setName(RunOptionEnum.saveOutput);
		saveOutput.setValue(false);
		runOptions[0] = saveOutput;
	
		RunOptionStringArray outputFormat = new RunOptionStringArray();
		outputFormat.setName(RunOptionEnum.outputFormat);
		outputFormat.setValue(new String[]{"XLS" });
		runOptions[1] = outputFormat;
	
		RunOptionBoolean prompt = new RunOptionBoolean();
		prompt.setName(RunOptionEnum.prompt);
		prompt.setValue(false);
		runOptions[2] = prompt;
			
		RunOptionInt primaryWaitThreshold = new RunOptionInt();
		primaryWaitThreshold.setName(RunOptionEnum.primaryWaitThreshold);
		primaryWaitThreshold.setValue(0);
		runOptions[3] = primaryWaitThreshold;

		RunOptionInt secondaryWaitThreshold = new RunOptionInt();
		secondaryWaitThreshold.setName(RunOptionEnum.secondaryWaitThreshold);
		secondaryWaitThreshold.setValue(0);
		runOptions[4] = secondaryWaitThreshold;
	        
		SearchPathSingleObject repPath = new SearchPathSingleObject();
		repPath.setValue( reportSearchPath );
		
		
try
{

AsynchReply res = getReportService().run(repPath, new ParameterValue[]{}, runOptions);

		// If it has not yet completed, keep waiting until it is done.
		int count = 1;
		while(res.getStatus() != AsynchReplyStatusEnum.complete &&
				res.getStatus() != AsynchReplyStatusEnum.conversationComplete)
		{
			System.out.println("large report - waiting..." + count);
			res = getReportService().wait(res.getPrimaryRequest(), new ParameterValue[]{}, new Option[]{});
			count++;
		}


		if (res.getStatus().equals(AsynchReplyStatusEnum.complete))
		{
			AsynchDetailReportOutput reportOutput = null;
System.out.println(res.getDetails().length);
			
			for (int i = 0; i < res.getDetails().length; i++)
			{
				if (res.getDetails()[i] instanceof AsynchDetailReportOutput)
				{
					reportOutput = (AsynchDetailReportOutput)res.getDetails()[i];
					break;
				}
			}

			String excelFile = null;
			String[] data = reportOutput.getOutputPages();
			excelFile = data[0];
			//look for output pages of the excel report.
			BaseClass bcOutput[] = reportOutput.getOutputObjects();

				
			if (bcOutput != null && bcOutput.length > 0) 
			{	
				Output latestOutput = (Output)bcOutput[bcOutput.length - 1];
							
				PropEnum [] pageProperties = new PropEnum [] {PropEnum.searchPath,PropEnum.defaultName,														  PropEnum.data};
				SearchPathMultipleObject outPage = new SearchPathMultipleObject();
				outPage.setValue(latestOutput.getSearchPath().getValue() + "//page");
                                BaseClass[] bcPage = new BaseClass[100000];
					
				bcPage = cmService.query(outPage, pageProperties, new Sort[]{}, new QueryOptions() );
			

				if (bcPage != null)
				{	
					for (int i = 0; i < bcPage.length; i++)
					{	
						Page dataPage = (Page)bcPage[i];
						dataPageName = dataPage.getDefaultName().getValue(); 
                                                //String dataPageName1 = dataPage.getDefaultName() + "_" + day + "-" + (month + 1) + "-" + year;
						String saveDataPageFile = saveLocation + "/" + dataPageName ; 
                                                System.out.println(saveDataPageFile);
						File file = new File(saveDataPageFile);
						FileOutputStream fos = new FileOutputStream(file);
						fos.write(dataPage.getData().getValue());
						fos.flush();
						fos.close();
						//System.out.println("Saving report page - " + saveDataPageFile);
					}
				}

				// query to get the report name
				PropEnum [] reportProperties = new PropEnum [] {PropEnum.defaultName};
Thread.sleep(700);
				BaseClass [] reportInfo = cmService.query(new SearchPathMultipleObject(reportSearchPath), reportProperties, new Sort[]{}, new QueryOptions());
String saveExcelFile = saveLocation + "/" + reportInfo[0].getDefaultName().getValue() + ".xls"; 
				File file = new File(saveExcelFile);
				FileOutputStream fos = new FileOutputStream(file);
				Base64 b64 = new Base64();	
				byte[] binaryOutput= null; 
byte[] buffer = new byte[22528];
buffer=excelFile.getBytes();
				fos.write(buffer); 
				fos.flush();
				fos.close();
				System.out.println("Saving report " + saveExcelFile);
			}

			else
				System.out.println("No output found for report " + reportSearchPath);	


		}



}
catch(Exception e)
		{
System.out.println(e);	
		}
	}