title: Google Sheets - Google app scripts - way to get full sheet data plus styling
body: <p>Is there a way to get all sheet values, functions and stylings etc in one call to Google?</p>
  
  <p>The only way I have found to do it is to call each style separately for the active range.</p>
  
  <p>If possible i'd like to get all data/formulas/styling etc for the sheet in one go.</p>
  
  <pre><code>var sheet = SpreadsheetApp.getActiveSheet();
  var activeRange = sheet.getActiveRange();
  var backgrounds = activeRange.getBackgrounds();
  var fontSizes = activeRange.getFontSizes();
  var colours = activeRange.getFontColors();
  var alignments = activeRange.getHorizontalAlignments();  
  var values = activeRange.getValues();
  var formulas = activeRange.getFormulas();
  var vAlignments = activeRange.getVerticalAlignments();
  </code></pre>