5

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 scrollbars – Danny '365CSI' Engelman Dec 15 '15 at 8:32
  • Hi Danny.. Can you please guide me? – Yuges Dec 16 '15 at 1:25
  • @DannyEngelman : Can you please guide me? – Yuges Dec 16 '15 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.com – Danny '365CSI' Engelman Dec 16 '15 at 8:04
2

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

  • 1
    A 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 Dec 16 '15 at 8:09
  • 1
    This what I was trying to say it – Michał Dem Dec 17 '15 at 13:55
0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.