Function: writeDataFrameToSheet()¶
writeDataFrameToSheet(
df,sheet,row?,col?,options?):Range
Write DataFrame to Google Sheets Sheet.
Parameters¶
df¶
DataFrame to write
sheet¶
Sheet
Target Sheet object
row?¶
number = 1
Starting row (1-indexed)
col?¶
number = 1
Starting column (1-indexed)
options?¶
Write options
Returns¶
Range
Modified Range object
Example¶
TypeScript
const sheet = SpreadsheetApp.getActiveSheet();
writeDataFrameToSheet(df, sheet, 1, 1, { header: true });
Deprecated¶
Will be deprecated in a future version.