Visualforce export Excel with wrapped text

hello, i am printing a Table into a Excel spread-sheet and need the text to wrap in the <Cell> tags? Below is the Style im using so far

<Style ss:ID="s1">
<Alignment/>
                    <Borders>
           <Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"/>
           <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
           </Borders>
                    <Font ss:Bold="1"/>
                    <Interior ss:Pattern='Solid' ss:Color="#2f9f38" ss:white-Space="normal"/>
               <NumberFormat/>
               <Protection/>
            </Style>

February 4, 2019
·
Like
0
·
Follow
1

Best Answer chosen by Connor Cain

Saravanan Rajarajan
Hi Connor Cain,

Try this

Apparently, the wrap Text attribute in the Style ID works

<Style ss:ID="s1"> <Alignment ss:Horizontal="Center" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> <Font ss:Bold="1"/> <Interior ss:Pattern='Solid' ss:Color="#2f9f38" ss:white-Space="normal"/> <NumberFormat/> <Protection/> </Style>

Adding the ss:WrapText="1" in the alignment made it work perfectly.

February 7, 2019
·
Like
1
·
Dislike
0

Connor Cain
Figured it out. In the Alignment section you need to set WrapText to True:

<Alignment ss:WrapText="1"/>

February 4, 2019
·
Like
0
·
Dislike
0

Browse by Topic

Welcome to Support!

Show

sorted by

Visualforce export Excel with wrapped text

All Answers

You need to sign in to do that.