Export in excel format

Hi Experts,

                  I have a page that displays a chart and a table. I want to the table to shown in excel format on click of a link.
                   Below is my controller code. Both the table and Chart are rendered on the fly from request parameters.
                  model.put("detailData", detailRes);

                 the above variable detailData is the one one which contains the formatted  HTML Table. I want to show this variable in excel format.
   
package com.att.analytics.ui;
 
import java.util.Arrays;
import java.util.Collection;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
 
 
import javax.servlet.http.HttpServletRequest;
 
import net.sf.json.JSONObject;
 
import org.apache.log4j.Logger;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.ServletRequestUtils;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
 
import com.si.myworld.business.Chart;
import com.si.myworld.dao.ChartData;
 
 
@Controller
@RequestMapping("/chartDetail.html")
public class DetailChartController {
 
	private static final Logger log = Logger.getLogger(DetailChartController.class);
	
	@RequestMapping(method=RequestMethod.GET)
   public String getChart(HttpServletRequest request, ModelMap model) {
		String chartType = request.getParameter("chartType");
		String chartGroup = request.getParameter("chartGroup");
		String chartSubgroup = request.getParameter("chartSubgroup");
		String timeline = request.getParameter("timeline");
		String liabilityCode = request.getParameter("liabilityCode");
				
//		log.debug("Chart Type: "+chartType);
//		log.debug("Chart Group: "+chartGroup);
//		log.debug("Chart Subgroup: "+chartSubgroup);
//		log.debug("Timeline: "+timeline);
 
// build your report here
// using the code from the jsp
		
		System.out.println("Picked from request attribute: " + chartType);
		System.out.println("Picked from request attribute: " + chartGroup);
		System.out.println("Picked from request attribute: " + chartSubgroup);
		System.out.println("Picked from request attribute: " + timeline);
		System.out.println("Picked from request attribute: " + liabilityCode);
		
		//added on 7/2/09
		int id = ServletRequestUtils.getIntParameter(request, "chartId", 0);
		String startDt = request.getParameter("startDt");
		String endDt = request.getParameter("endDt");
		
		Chart crt = new Chart();
		crt.setChartGroup(chartGroup);
		crt.setChartSubgroup(chartSubgroup);
		crt.setTimeline(timeline);
		crt.setChartType(chartType);
		crt.setLiabilityCode(liabilityCode);
		
		//added by pp 7/2/09
		crt.setChartId(id);
		crt.setStartDt(startDt);
		crt.setEndDt(endDt);
		
		System.out.println("Values from Chart object: " + crt.getChartType() );
		System.out.println("Values from Chart object: " + crt.getChartGroup() );
		System.out.println("Values from Chart object: " + crt.getChartSubgroup() );
		System.out.println("Values from Chart object: " + crt.getTimeline());
		System.out.println("Values from Chart object: " + crt.getLiabilityCode());
		
		ChartData cd = new ChartData();
	    String chartXml = cd.getChartXml(crt);
		
		System.out.println("DetailChartController>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> chart XML" + chartXml);
		
		//added 7/2/09
		String chartDatasource = cd.fetchChartDatasourceName(crt.getChartSubgroup());		
		
		model.put("chartType", chartType);
		model.put("chartGroup", chartGroup);
		model.put("chartSubgroup", chartSubgroup);
		model.put("timeline", timeline);	
		model.put("liablityCode", liabilityCode);
		model.put("detailForm", crt);
			
		//pp on 7/2/09
		model.put("chartId", id);
		model.put("startDt", startDt);
		model.put("endDt", endDt);
		model.put("chartDatasource", chartDatasource);
 
		//detail data
		//Vector detailData = cd.getChartDetailData(crt); 
		//List detailData = cd.getChartDetailDataList(crt);
		//String chartDetailHtml = cd.getChartDetailHtml(cd.getChartDetailData(crt));
		//model.put("chartDetailHtml", chartDetailHtml);
		
		String detailRes = cd.getChartDetailDataNew(crt);
		model.put("detailData", detailRes);
		
		//breadcrumb
		String breadcrumb = crt.getChartGroup() + ">>" 	+ crt.getChartSubgroup();
		model.put("breadcrumb", breadcrumb);
		
    	return "TestDetail";
    }
 
	
	@RequestMapping(method=RequestMethod.POST)
	public String setChartPosition(HttpServletRequest request) {				
		return("redirect:/index.html");
	}
	
		
	@ModelAttribute("chartGroups")
	public Collection<String> populateGroups() {
		return populateSubgroups().keySet();
	}
 
	@ModelAttribute("chartSubgroups")
	public JSONObject getSubgroups() {
		return JSONObject.fromObject(populateSubgroups());
	}
 
	public Map<String, List<String>> populateSubgroups() {
		
		Map<String, List<String>> groups = new HashMap<String, List<String>>();
		groups.put("Payment", Arrays.asList("AUTOPAY", "TXT2PAY"));
		groups.put("Registration", Arrays.asList("REGISTRATION"));
		groups.put("UpgradeChanges", Arrays.asList(
		"UPGRADE_CHANGE"));
		
		return groups;
	}
 
	@ModelAttribute("chartTypes")
	public Collection<String> populateTypes() {
		return Arrays.asList("bar", "line");
	}
 
	@ModelAttribute("timelines")
	public Collection<String> populateTime() {
		return Arrays.asList("Daily", "Weekly", "Monthly", "Quarterly",
				"Annual");
	}
	
	@ModelAttribute("liabilityCodes")
	public Collection<String> populateCustomers() {
		return Arrays.asList("IRU", "CRU");
	}
	
	
}

Open in new window

LVL 10
aman0711Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mick BarryJava DeveloperCommented:
create another method that returns a different (excel) view

        @RequestMapping(value="/excel.html", method=RequestMethod.GET)
   public String getChart(HttpServletRequest request, ModelMap model) {
                String chartType = request.getParameter("chartType");
                String chartGroup = request.getParameter("chartGroup");
                String chartSubgroup = request.getParameter("chartSubgroup");
                String timeline = request.getParameter("timeline");
                String liabilityCode = request.getParameter("liabilityCode");
                               
//              log.debug("Chart Type: "+chartType);
//              log.debug("Chart Group: "+chartGroup);
//              log.debug("Chart Subgroup: "+chartSubgroup);
//              log.debug("Timeline: "+timeline);
 
// build your report here
// using the code from the jsp
               
                System.out.println("Picked from request attribute: " + chartType);
                System.out.println("Picked from request attribute: " + chartGroup);
                System.out.println("Picked from request attribute: " + chartSubgroup);
                System.out.println("Picked from request attribute: " + timeline);
                System.out.println("Picked from request attribute: " + liabilityCode);
               
                //added on 7/2/09
                int id = ServletRequestUtils.getIntParameter(request, "chartId", 0);
                String startDt = request.getParameter("startDt");
                String endDt = request.getParameter("endDt");
               
                Chart crt = new Chart();
                crt.setChartGroup(chartGroup);
                crt.setChartSubgroup(chartSubgroup);
                crt.setTimeline(timeline);
                crt.setChartType(chartType);
                crt.setLiabilityCode(liabilityCode);
               
                //added by pp 7/2/09
                crt.setChartId(id);
                crt.setStartDt(startDt);
                crt.setEndDt(endDt);
               
                System.out.println("Values from Chart object: " + crt.getChartType() );
                System.out.println("Values from Chart object: " + crt.getChartGroup() );
                System.out.println("Values from Chart object: " + crt.getChartSubgroup() );
                System.out.println("Values from Chart object: " + crt.getTimeline());
                System.out.println("Values from Chart object: " + crt.getLiabilityCode());
               
                ChartData cd = new ChartData();
            String chartXml = cd.getChartXml(crt);
               
                System.out.println("DetailChartController>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> chart XML" + chartXml);
                                 
                String detailRes = cd.getChartDetailDataNew(crt);
                model.put("detailData", detailRes);
               
               
        return "excel";
    }
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java EE

From novice to tech pro — start learning today.