Multiple charts in container in multiple tabs in excel
I have displayed multiple charts in separate tabs in a container in one qvw sheet. my requirement is to export each chart with data and image in separate tabs in same excel. Tried many options but failed ..HELP required here please ...When the user clicks on EXPORT button after installing IE plugin, all the charts in the container irrespective of active and inactive tab should be exported in one excel in separate tabs along with data +image .
Re: Multiple charts in container in multiple tabs in excel
Attaching the qvw file which has the export functionality to pull in reports in different tabs in excel.. The only problem now i face is i am bot able to extract the image of the inactive tab from the container. When i activate the tab , that sheets data +image get exported and other tab's data only gets exported. help appreciated !