Link to home
Start Free TrialLog in
Avatar of Ray Padilla
Ray PadillaFlag for United States of America

asked on

Centering and Excel spreadsheet after it has been exported to HTML

I've exported an excel spreadsheet to html and uploaded the file to my wordpress site however when I open the url the spreadsheet is not centered on the page. it is set to the far left. How do I center the pages. I'd also like to have the links on the bottom to the other sheets be at the top instead of the bottom but that's not a deal breaker.
Avatar of Fran Maita
Fran Maita
Flag of Venezuela, Bolivarian Republic of image

Use the tools menu that WordPress uses and select preferences. Then go to the "Edit" tab and configure the loaded file.
WordPress.jpg
Avatar of David Favor
1) "I've exported an excel spreadsheet to html and uploaded the file to my wordpress site however when I open the url the spreadsheet is not centered on the page."

How this works depends on if you're serving the HTML as part of a WordPress page/post or as a standalone file.

If you're trying to serve this HTML through WordPress, keep in mind you'll have to strip off top content including <body> tag + strip bottom content starting with </body> tag, otherwise you'll end up with content so scrambled it will be anyone's guess how your content will render for a visitor.

2) "it is set to the far left. How do I center the pages."

Depends on #1. Inside WordPress, this won't be that hard to do + will be more complex, than just serving a .html file with all correct formatting built into the file.

3) "I'd also like to have the links on the bottom to the other sheets be at the top instead of the bottom but that's not a deal breaker."

This is a completely different question. Likely best to open another question about this.

The answer will depend on how you convert your spread sheet to HTML.

If you've written a custom script to do this, changing output format will be simple.

If you're using some existing tool, then all the tool can do is transform the spread sheet to HTML, per the tools built in parser + output logic.

You can always ingest the output HTML (100s of options for this), then reformat the DOM however you like, then output the DOM.

This can be a complex process, depending on many factors.

Best to open a new question about this one topic.
Usa el menú de herramientas que usa WordPress y selecciona tus preferencias. Luego vaya a la pestaña "Editar" y configure el archivo cargado.
Avatar of Ray Padilla

ASKER

I ended up exporting each sheet individually which then allowed me to center the sheets on my page.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.