import html table with rotated headers in excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • willem sanders

    #1

    import html table with rotated headers in excel

    I have a html-document with a table that has rotated columnheaders. The css I use for the rotated headers is listed below. -webkit and -moz dot the trick for webkit and mozilla browsers. writing-mode + filter is for IE

    It works fine in the browser but importing the html in Excel drops the text-rotation

    Code:
    <html>
    <head>
    <Style>
    .rotate {
      -webkit-transform: rotate(90deg); 
      -moz-transform:rotate(90deg);
      writing-mode:tb-rl;
      filter: flipv fliph;
    
      height:300px;
      width:20px;
      vertical-align:bottom; 
      background-color:red;
    }</style>
    </head>
    <body>
    <table>
    <tr>
    	<Td class="rotate">Col #1</td>
    	<Td class="rotate">Col #2</td>
    	<Td class="rotate">Col #3</td>
    </tr>
    
    
    </body>
    </html>
Working...