Excel tabs that were saved in html: how to take up

Asked

Viewed 81 times

4

inserir a descrição da imagem aquiI made a spreadsheet in excel with several tabs and then saved in html because I want to use in my site. The spreadsheet tabs are at the bottom, the site user would have to scroll down to change the tab you want, I would like the tabs to be placed up inside my html page. Thank you,

html css excel vba

1 answer

2


When saving in HTML format, an HTML with a Frameset of two Rows, in the pattern below:

<frameset rows="*,39" border=0 width=0 frameborder=no framespacing=0>
 <frame src="bar_arquivos/sheet001.htm" name="frSheet">
 <frame src="bar_arquivos/tabstrip.htm" name="frTabs" marginwidth=0 marginheight=0>
 <noframes>
  <body>
   <p>Esta página usa quadros, mas o seu navegador não dá suporte para eles.</p>
  </body>
 </noframes>
</frameset>

The first frame is the page where the contents of the tabs are displayed, and the second the tab code page (tabstrip.htm).

To change the position, just reverse the order of the frames and also reverse the *,39, getting 39,* (the value 39 means frame pixel height).

Then it would look like this:

<frameset rows="39,*" border=0 width=0 frameborder=no framespacing=0>
 <frame src="bar_arquivos/tabstrip.htm" name="frTabs" marginwidth=0 marginheight=0>
 <frame src="bar_arquivos/sheet001.htm" name="frSheet">
 <noframes>
  <body>
   <p>Esta página usa quadros, mas o seu navegador não dá suporte para eles.</p>
  </body>
 </noframes>
</frameset>

  • Sam, thank you so much! I’ve been trying to figure this out for a long time!!

  • 1

    Young dude. If you solved the problem, be sure to prioritize the answer by marking . Thanks!

  • 1

    Order and Progress, rs, ce tái?

Browser other questions tagged html css excel vba

You are not signed in. Login or sign up in order to post.