Viewing Need more formatting features for text box

Need more formatting features for text box



User: Richard S. 2 years ago
I like the ability to import a spreadsheet, but with CSV I lose all the formatting (fonts and links). How about supporting import of a "numbers" spreadsheet. OR provide more features for the Table widget.
User: Paul-RAGESW 2 years ago
Hi Richard,

If you want to import a spreadsheet, I would recommend using Google Sheets and embedding it on your EverWeb site.

Simply open your spreadsheet in Google Sheets and then go to File->Publish to the web.

Select the Embed option and click Publish

With the code provided by Google Sheets, paste that into the HTML Snippet Widget in EverWeb.

-------------------------------
Paul
EverWeb Developer
User: Richard S. 2 years ago
That works good except I can only see the upper left portion of the spreadsheet when "snipped" into my website. Scroll down on this page; https://www.chrisstevensblues.com/schedule.html
Thanks
User: Paul-RAGESW 2 years ago
Hi Richard,

There should be a width and height parameter that you can adjust. If you can share the snippet code here, I can see if I can help you, or double check the interface with the snippet code in Google Sheets to see if there is a width and height setting.

Also, try to adjust the width and height of the HTML Snippet widget in EverWeb.

-------------------------------
Paul
EverWeb Developer
User: Richard S. 2 years ago
<iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-1vQvBv4FIrEEe1KmBQYVxJaol0DQBuTBtLGasAu8Hvs5hq4ziZXJq2eE6CUuHwGWEtQraPl8kD8f35bO/pubhtml?widget=true&amp;headers=false"></iframe>
Thanks Paul
User: Ole V. 2 years ago
This site is useful: https://www.tablesgenerator.com/html_tables#
User: wellnl 2 years ago
This article may help with expanding the height/width of the embedded Google Sheets spreadsheet. I have not tried it myself yet btw

https://www.groovypost.com/howto/embed-a-google-sheet-in-a-website/
User: Paul-RAGESW 2 years ago
Seems Google makes it a little tricky to adjust the height and width of the spreedsheet. Fortunatly you can slightly edit the code to do this.

Where you see the beginning iframe replace it with this

iframe width="100%" height="500"

So the final code would like this;

<iframe width="100%" height="500" src="https://docs.google.com/spreadsheets/d/e/2PACX–1vQvBv4FIrEEe1KmBQYVxJaol0DQBuTBtLGasAu8Hvs5hq4ziZXJq2eE6CUuHwGWEtQraPl8kD8f35bO/pubhtml?widget=true&amp;headers=false"></iframe>


You can adjust the value for height to whatever you want. The width will be the size of the HTML Snippet object on your Design Canvas.

Last edit 2 years ago

-------------------------------
Paul
EverWeb Developer


Post Reply
You must login or signup to post.