UiPath Documentation
activities
latest
false
Productivity activities

WriteRow

Write a row in a selected file.

Write a row in a selected file.

Namespace: UiPath.Gsuite.Activities.API

Assembly: UiPath.Gsuite.Activities.API (in UiPath.Gsuite.Activities.API.dll)

Overloads​

OverloadDescription
WriteRow(ISpreadsheet, IRange, IEnumerable, Boolean, RangeWriteMode, Int32)Write a row in a selected file using an Array Row.
WriteRow(ISpreadsheet, IRange, DataRow, Boolean, RangeWriteMode, Int32)Write a row in a selected file using a Data Row.

WriteRow(ISpreadsheet, IRange, IEnumerable, Boolean, RangeWriteMode, Int32)
void WriteRow(
	ISpreadsheet spreadsheet,
	IRange range,
	IEnumerable<Object> data,
	bool hasHeaders = true,
	RangeWriteMode writeMode = RangeWriteMode.Append,
	int insertRowPosition = 0
)
void WriteRow(
	ISpreadsheet spreadsheet,
	IRange range,
	IEnumerable<Object> data,
	bool hasHeaders = true,
	RangeWriteMode writeMode = RangeWriteMode.Append,
	int insertRowPosition = 0
)

spreadsheet ISpreadsheet: The Google spreadsheet file to use.

range IRange: The range to write in.

data IEnumerable<Object>: The data that will be written in the spreadsheet.

hasHeaders Boolean (Optional): If selected, the column headers are generated by reading the range header.

writeMode RangeWriteMode (Optional): Specifies how to add the data to the specified range.

insertRowPosition Int32 (Optional): The row index position where the activity inserts the data. Rows starts from 0.

WriteRow(ISpreadsheet, IRange, DataRow, Boolean, RangeWriteMode, Int32)​

void WriteRow(
	ISpreadsheet spreadsheet,
	IRange range,
	DataRow data,
	bool hasHeaders = true,
	RangeWriteMode writeMode = RangeWriteMode.Append,
	int insertRowPosition = 0
)
void WriteRow(
	ISpreadsheet spreadsheet,
	IRange range,
	DataRow data,
	bool hasHeaders = true,
	RangeWriteMode writeMode = RangeWriteMode.Append,
	int insertRowPosition = 0
)

spreadsheet ISpreadsheet: The Google spreadsheet file to use.

range IRange: The range to write in.

data DataRow: The DataRow data that will be written in the spreadsheet.

hasHeaders Boolean (Optional): If selected, the column headers are generated by reading the range header.

writeMode RangeWriteMode (Optional): Specifies how to add the data to the specified range.

insertRowPosition Int32 (Optional): The row index position where the activity inserts the data. Rows starts from 0.

​

Was this page helpful?

Connect

Need help? Support

Want to learn? UiPath Academy

Have questions? UiPath Forum

Stay updated