What do you want to save?
Add Code snippet
New code examples
-
Other 2021-11-16 15:39:20
app scrip sheet cell boarder
var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var cell = sheet.getRange("B2"); // Sets borders on the top and bottom, but leaves the left and right unchanged // Also sets the color to "red", and the bo... Add solution -
Python 2021-11-13 16:17:15
pip google sheet
>>> sheet = spreadsheet.get_worksheet('tkZQWzwHEjKTWFFCAgw', 'od7') >>> rows = sheet.get_rows() >>> len(rows) 18 >>> row_to_update = rows[0] >>> row_to_update['name'] = 'New Name' >>> sheet.update_row(... Add solution -
Go 2021-11-13 14:02:25
google forms
Google Forms is a survey administration software that is included in the Google Docs Editors software suite along with Google Docs, Google Sheets, and Google Slides. It allows collecting information from users through surveys. The collected information ... Add solution -
Other 2021-11-12 19:50:17
create dropdown in spreadsheet
1. Open a spreadsheet in Google Sheets. 2. Select the cell or cells where you want to create a drop-down list. 1. Click Data and then Data validation. 2. Next to "Criteria," choose an option: 3. List from a range: Choose the cells that will be... Add solution -
Other 2021-11-06 14:23:14
phpspreadsheet
<?php require 'vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $sheet->setCellValue('A1', 'Hello World !'); $... Add solution
Best helpers
Ranking is empty