function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
P.T.P.T. 

How to Get Multiple Tables per Worksheet to Export

Hello All,

I'm successful in generating a multi-worksheet workbook in Excel from VF using MS xmlns="urn:schemas-microsoft-com:office:spreadsheet  and XML. Problem is if I try to include more than one Table per worksheet, only the first worksheet is generated.  

I would think this setup would work:

<Worksheet ss:Name="Sheet 1">
  <Table x:FullColumns="1" x:FullRows="1">
  ....[[CONTENT Table 1]]
</Table>
 <Table x:FullColumns="1" x:FullRows="1">
  ....[[CONTENT Table 2]]
</Table>
</Worksheet>

Each table has its own repeater, with values of separate lists from the Controller. Is there some setting or attribute that I need to consider in order to get more than one table per sheet to appear?

Thanks for any help!

P.T.
Best Answer chosen by pcon
pconpcon
All of the examples I have been able to find show that there is only a single table per worksheet.  This question (while being implemented via Visualforce) is not a good question for these boards because at it's heart, it's an Excel question and since you are able to generate an Excel file correcty via Visualforce, it seems like the problem lies in your Excel markup.  I would recommend asking the question of how to generate the XML for multiple Excel tables in a single worksheet on an a site more attuned to doing Microsoft Office work.

All Answers

pconpcon
All of the examples I have been able to find show that there is only a single table per worksheet.  This question (while being implemented via Visualforce) is not a good question for these boards because at it's heart, it's an Excel question and since you are able to generate an Excel file correcty via Visualforce, it seems like the problem lies in your Excel markup.  I would recommend asking the question of how to generate the XML for multiple Excel tables in a single worksheet on an a site more attuned to doing Microsoft Office work.
This was selected as the best answer
P.T.P.T.
Pcon, agreed and thanks for your reply. It is more of an Excel question so I'll bounce my question over to the MSDN boards. Cheers.