Need Required Java Code to Store Data directly into Excel File

[Davidson Rajapal]

Hi friends,

I have a below code which gives output with "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 Empty 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++)
					{
						
//Here is the below Code where it saves 4 html web page with data separately

                                                Page dataPage = (Page)bcPage[i];
						dataPageName = dataPage.getDefaultName().getValue();
                                          	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());

//Here is the below Code where it saves Empty Excel file

                                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);
		}
	}

[Jeff Verdegan]

Davidson Rajapal wrote:If you know Please modify this below code.

Hi, Davidson, and welcome to the Ranch!

Please note that this site is NotACodeMill.(⇐click) It doesn't help you learn if somebody just writes or fixes the code for you. If you provide enough detail and show some effort (and it appears here that you have, so good job!), people will be happy to help guide you toward solving your own problem.

Good luck!

[Priyanka Chaurishia]

Use Apache POI for these kind of requirements.

[Davidson Rajapal]

Hi All,

It will be good if any of you update the above mentioned code depending upon my requirement and provide me. So that I will try in my end and let you know.

Thanks in Advance.

[Tim Moores]

Davidson Rajapal wrote:It will be good if any of you update the above mentioned code depending upon my requirement and provide me.

I'm sure you would like that folks here do your work for you, but that's not going to happen. What prevents you from doing it yourself, apart from the obvious need to learn the POI API? Which is no big deal, as the POI site has numerous examples which you can study.

[Jeff Verdegan]

Davidson Rajapal wrote:
It will be good if any of you update the above mentioned code depending upon my requirement and provide me.

So, you didn't click the link when I pointed out previously that this site is NotACodeMill? Or you read it and still thought it would be okay to ask others to do your work for you?