I have a business data-excel web access web part. I need help for below issue. How to resize webpart content (Excel sheet) without scrollbars in SharePoint 2013? Please assist.
- By using JavaScript to recalculate the width and height (and set the CSS with and height) until it fills the DIV without scrollbarsDanny '365CSI' Engelman– Danny '365CSI' Engelman2015-12-15 08:32:52 +00:00Commented Dec 15, 2015 at 8:32
- Hi Danny.. Can you please guide me?Yuges– Yuges2015-12-16 01:25:05 +00:00Commented Dec 16, 2015 at 1:25
- @DannyEngelman : Can you please guide me?Yuges– Yuges2015-12-16 05:17:12 +00:00Commented Dec 16, 2015 at 5:17
- From this and other replies I gather you are new to SharePoint. Start with learning the basics, Workflows, simple JavaScript and CSS changes. Then you continue with this more complex adaptations. I am sorry, but I can not coach you in a Formula-1 race if you have never driven a car/cart. Start with w3schools.comDanny '365CSI' Engelman– Danny '365CSI' Engelman2015-12-16 08:04:57 +00:00Commented Dec 16, 2015 at 8:04
2 Answers
I would solve this problem to add new site for this type of excel sheets and use it wide layout (change masterpage) for it which will be accurate for excel sheets
- 1A whole new SiteCollection? That is like saying, my drawer is full, lets built a new building. What about some simple CSS to hide the QuickLaunch OR use a different Page Template for displaying Excel files OR apply that wide Masterpage to just one site with Excel files,Danny '365CSI' Engelman– Danny '365CSI' Engelman2015-12-16 08:09:27 +00:00Commented Dec 16, 2015 at 8:09
- 1This what I was trying to say itMichał Dem– Michał Dem2015-12-17 13:55:23 +00:00Commented Dec 17, 2015 at 13:55
There is an out of the box setting in webpart properties. You can increase the width to your required limit and the excel will render. This of course will have scroll bar if your excel is bigger than the page itself in terms of height.
This property increases the height of the webpart but does not re size the tables and cells.