Auto Fill Dates

SpreadJS allows users to automatically fill dates in the worksheet by using the drag fill option.

You can simply drag the fill handle in an upward or downward direction to fill days, weekdays, months and years across the entire column in the worksheet. Also, you can quickly carry out other custom date filling operations like filling the first day of the month, filling the same day of the month, filling the last day of the month etc. as shown in the example shared below.

Using Code

Refer to the following example code in order to automatically fill the first day of the month and the last day of the month.

JavaScript	Copy Code
// Initializing Spread var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'), { sheetCount: 1 }); // Drag Fill Dates var sheet1 = spread.getSheet(0); sheet1.name("Date DragFill"); sheet1.setValue(0, 0, 'Please drag up or down'); sheet1.setValue(1, 0, 'First day of month to dragfill'); sheet1.setColumnWidth(0, 80); sheet1.setValue(6, 0, new Date(2018, 3, 1)); sheet1.setValue(7, 0, new Date(2018, 4, 1)); sheet1.getRange(6, 0, 2, 1).formatter('m/d/yyyy'); sheet1.setColumnWidth(1, 80); sheet1.setValue(6, 1, new Date(2017, 11, 1)); sheet1.setValue(7, 1, new Date(2018, 0, 1)); sheet1.getRange(6, 1, 2, 1).formatter('m/d/yyyy'); sheet1.setValue(1, 3, 'Last day of month to dragfill'); sheet1.setColumnWidth(3, 80); sheet1.setValue(6, 3, new Date(2018, 2, 31)); sheet1.setValue(7, 3, new Date(2018, 3, 30)); sheet1.getRange(6, 3, 2, 1).formatter('m/d/yyyy'); sheet1.setColumnWidth(4, 80); sheet1.setValue(6, 4, new Date(2017, 11, 31)); sheet1.setValue(7, 4, new Date(2018, 0, 31)); sheet1.getRange(6, 4, 2, 1).formatter('m/d/yyyy');

JavaScript

Copy Code

// Initializing Spread
var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'), { sheetCount: 1 });

// Drag Fill Dates
var sheet1 = spread.getSheet(0);
sheet1.name("Date DragFill");
sheet1.setValue(0, 0, 'Please drag up or down');
sheet1.setValue(1, 0, 'First day of month to dragfill');

sheet1.setColumnWidth(0, 80);
sheet1.setValue(6, 0, new Date(2018, 3, 1));
sheet1.setValue(7, 0, new Date(2018, 4, 1));
sheet1.getRange(6, 0, 2, 1).formatter('m/d/yyyy');
sheet1.setColumnWidth(1, 80);
sheet1.setValue(6, 1, new Date(2017, 11, 1));
sheet1.setValue(7, 1, new Date(2018, 0, 1));
sheet1.getRange(6, 1, 2, 1).formatter('m/d/yyyy');

sheet1.setValue(1, 3, 'Last day of month to dragfill');
sheet1.setColumnWidth(3, 80);
sheet1.setValue(6, 3, new Date(2018, 2, 31));
sheet1.setValue(7, 3, new Date(2018, 3, 30));
sheet1.getRange(6, 3, 2, 1).formatter('m/d/yyyy');
sheet1.setColumnWidth(4, 80);
sheet1.setValue(6, 4, new Date(2017, 11, 31));
sheet1.setValue(7, 4, new Date(2018, 0, 31));
sheet1.getRange(6, 4, 2, 1).formatter('m/d/yyyy');