WorksheetCellUpdate

Updates a cell in a Worksheet of an Excel Workbook

  • Stored Procedure
  • SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

EXEC SQLHTTP.net.WorksheetCellUpdate @WorkbookPath, @SheetName, @Cell, @Value

Arguments:

Name Type Description
@WorkbookPath nvarchar(4000) The path to a Microsoft Excel Workbook
@SheetName nvarchar(4000) Name of Worksheet to be added to the above Workbook
@Cell nvarchar(4000) Cell to be updated in a format such as B5, or BC298
@Value nvarchar(4000) Value as a string

Remarks:

SQL Server 64 Bit Instances: This function requires the “Microsoft Access Database Engine 2010 Redistributable.” Please see the following for more information: https://www.microsoft.com/en-us/download/details.aspx?id=13255

Sample Usage:

See Also: