Visualforce page render as Excel issues

Hi,

I am generating visualforce page as Excel by adding "contenttype="application/vnd.ms-excel"" in the <apex:page> tag. The excel is getting generated but formatting is bad... how do i format ? Can anyone give me example.

October 4, 2012
·
Like
0
·
Follow
0

Best Answer chosen by Admin (Salesforce Developers)

Girinoob
I got an solution. We should not use CSS 0r style class, instead of that we should do inline styling.
Check my code below:

<table width="100%"id="table1"border="0">
<tr>
<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
<th colspan='2'>xxxxx</th>
<th colspan='4'>yyyyyy</th>

</tr>
<trstyle="font-size:10pt;">
<th colspan="2">
<fontsize="2"face="Arial Unicode MS">Name
</th>
<th >
<fontsize="2"face="Arial Unicode MS">ID
</th>
<th >
<fontsize="2"face="Arial Unicode MS">Current <fontsize="2"face="Arial Unicode MS"> Grade
</th>
<th >
<fontsize="2"face="Arial Unicode MS"><fontsize="2"face="Arial Unicode MS">HR
</th>
<th colspan="2">
<fontsize="2"face="Arial Unicode MS">Phone # <fontsize="2"face="Arial Unicode MS">from DOE
</th>
<th colspan="2">
Alternate Phone
</th>
<th >
<fontsize="2"face="Arial Unicode MS">Attended <fontsize="2"face="Arial Unicode MS">FLW
</th>
<th >
<fontsize="2"face="Arial Unicode MS">At FLW
</th>
<th >
<fontsize="2"face="Arial Unicode MS">Last Known
</th>
<th >
<fontsize="2"face="Arial Unicode MS">Application <fontsize="2"face="Arial Unicode MS">Status
</th>
<th >
<fontsize="2"face="Arial Unicode MS"># of Calls <fontsize="2"face="Arial Unicode MS">Made by CFY
</th>
<thcolspan="2">
<fontsize="2"face="Arial Unicode MS">Outcome of Most <fontsize="2"face="Arial Unicode MS">Recent Call
</th>
</tr>
<apex:repeatvalue="{!listOfContactsWrapper}"var="lcw"id="theList">
<apex:repeatvalue="{!lcw.cw}"var="con">
<trbgcolor="{!con.rowColor}">
<td align="center" colspan="2"> {!con.contact.lastname}, {!con.contact.firstname}</td>
<td align="center">{!con.contact.X_ID__c}</td>
<td align="center">{!con.contact.Grade_Text__c}</td>
<td align="center">{!con.contact.Homeroom__c}</td>
<td align="center" colspan="2">{!con.contact.DOE_Phone_number__c}</td>
<tdcolspan="2"align="center"><fontsize="1"face="Arial Unicode MS">{!con.contact.Phone}</td>

<td align="center">{!con.attendedWorkshopStatus}</td>
<tdalign="center"><fontsize="1"face="Arial Unicode MS">{!con.atFLWStatus}</td>
<tdalign="center"><fontsize="1"face="Arial Unicode MS">{!con.lastKnown}</td>
<td align="center">{!con.applicationStatus}</td>
<td align="center" >{!con.numberOfCalls}</td>
<td align="center" colspan="2">{!con.recentCallNotes}</td>
</tr>
</apex:repeat>
</apex:repeat>
</table>

November 8, 2012
·
Like
0
·
Dislike
0

Jeeedeee
Just curious, did you got to an solution to this? I am facing the same problem :(

November 8, 2012
·
Like
0
·
Dislike
0

This was selected as the best answer

BPrakash1
how to use the repeat tag in the repeat tag,can you explian?

February 22, 2013
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Visualforce page render as Excel issues

All Answers

You need to sign in to do that.