Php photo gallery TWG | JFUploader | TWG Flash upload | WFU | Forum
https://www.tinywebgallery.com/forum/

Removing scroll bars - MS Excel .html pages
https://www.tinywebgallery.com/forum/viewtopic.php?f=21&t=6144
Page 1 of 1

Author:  DavidLeitch [ 13. May 2019, 06:07 ]
Post subject:  Removing scroll bars - MS Excel .html pages

Hi

Thank you for developing the plug in which in due course I will pay for. I am a novice at html programming, so I apologise if my question is wrong.

My use case is a bit unusual. I publish Excel "publish objects" either ranges, sheets or charts to amazon s3 and then use advanced iframe to embed the MS Excel generated .html page into a word press site hosted on siteground. This allows for frequent updating of the data. S3 allows me to mount my bucket as a network drive using a 3rd party utility.

by and large the system works well but I would like to improve the appearance to the end user by removing the scroll bars within the iframe. Is there a way to do this without having to add the "workaround" code to each excel .html page? That is virtually impossible in my case.

Author:  TinyWebGallery [ 13. May 2019, 22:17 ]
Post subject:  Re: Removing scroll bars - MS Excel .html pages

are they on the same domain? because the height cannot be guessed.
How "complicated" ate this pages?

Best, Michael

Author:  DavidLeitch [ 13. May 2019, 23:31 ]
Post subject:  Re: Removing scroll bars - MS Excel .html pages

Separate domains. The wordpress site is hosted by Siteground. The MS Excel generated .html pages are stored on Amazon S3 with a completely different domain. The excel page is regenerated every time the worksheet is saved. Perhaps I can write some Excel VBA to put the required script up the top. A wordpress page for this use case is very simple just some text and then the shortcode to pull in the chart or table that is in the Excel.VBA. Example of the Excel html is:


--------------

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 15">
<link rel=File-List href="FuturesChart_files/filelist.xml">
</head>

<body>
<!--[if !excel]>&nbsp;&nbsp;<![endif]-->
<!--The following information was generated by Microsoft Excel's Publish as Web
Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->

<div id="baseload futures_29649" align=center x:publishsource="Excel"><img
src="FuturesChart_files/baseload%20futures_29649_image001.png" alt=Chart2></div>


<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>

</html>

Author:  TinyWebGallery [ 14. May 2019, 00:46 ]
Post subject:  Re: Removing scroll bars - MS Excel .html pages

I have actually had a project wit ha local proxy. Means I have downloaded the whole page with a script and modified it.

To be honest. what is your budget? I spend the last time a lot of time to solve this. I would assume I still net 1-2 days to solve this if possible.

I still have the option. If is does not work you pay nothing... But creating a software proxy is not easy and only possible for simple pages..

Best, Michael

Page 1 of 1 All times are UTC + 1 hour [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/