Function applyCompanyStyle

Formatting.js:13–49

()

}  
  
  function applyCompanyStyle() {
  // Get the active spreadsheet and sheet
  const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = spreadsheet.getActiveSheet();

  // Get the last row and column to dynamically select the data range
  const lastRow = sheet.getLastRow();
  const lastColumn = sheet.getLastColumn();

  // Define the header range (assuming headers are in the first row)
  const headerRange = sheet.getRange(1, 1, 1, lastColumn);

  // Apply header formatting
  headerRange.setBackground('#e0e0e0'); // Light gray background
  headerRange.setFontWeight('bold');
  headerRange.setFontFamily('Roboto');
  headerRange.setFontColor('#333333'); // Dark gray text
  headerRange.setHorizontalAlignment('left');

  // Define the data range (excluding headers)
  const dataRange = sheet.getRange(2, 1, lastRow - 1, lastColumn);

  // Apply data formatting
  dataRange.setFontFamily('Roboto');
  dataRange.setFontColor('#555555'); // Medium gray text
  dataRange.setBackground('white');

  // Example of formatting a specific column (e.g., Sales column)
  const salesColumnIndex = 5; // Assuming "Sales" is the 3rd column
  const salesColumnRange = sheet.getRange(2, salesColumnIndex, lastRow - 1, 1);
  salesColumnRange.setNumberFormat('$#,##0.0'); // Currency format

  // Auto-resize columns for better readability
  sheet.autoResizeColumns(1, lastColumn);

  Logger.log('Google style formatting applied!');
}

  function applyMcDonaldsStyle() {
  // Get the active spreadsheet and sheet