Public Microsoft Excel Online Connector API

The public API procedures may call the internal procedures which should not be called directly as they can be changed without any explicit notification in the newer versions of the connector. The internal procedures can be recognized by the internal_ prefix in their names. The public API procedures do not contain this prefix in their names.

AllExcelFiles

All Excel files on the drive
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<only_folders> (optional): Show files from the list of the folders separated by | (example: Docs|Docs/Folder) only (When it is NULL all files from root folder will be shown)
<exclude_folders> (optional): Exclude list of folders separated by | (example: Exclude|Docs/Exclude)
<target_table> (optional): Table name to save the data to

Example

CREATE VIEW excel_online_examples.example_AllExcelFiles AS 
	SELECT * 
	FROM (
		CALL excel_online.AllExcelFiles ()
	) AS x

AllExcelTables

All tables from all excel files on the drive
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<target_table> (optional): Table name to save the data to

Example

CREATE VIEW excel_online_examples.example_AllExcelTables AS 
	SELECT * 
	FROM (
		CALL excel_online.AllExcelTables ()
	) AS x

AllExcelWorksheets

All worksheets of all Excel files on the drive
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<target_table> (optional): Table name to save the data to

Example

CREATE VIEW excel_online_examples.example_AllExcelWorksheets AS 
	SELECT * 
	FROM (
		CALL excel_online.AllExcelWorksheets ()
	) AS x

Cell

Single cell based on row and column numbers
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<item_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (required): Worksheet id or name
<row> (required): Row number of the cell to be retrieved (zero-indexed)
<column> (required): Column number of the cell to be retrieved (zero-indexed)
<filter> (optional): Filter criteria for which entities will be returned
<preview> (optional): Preview only, don't write into table

Example

CREATE VIEW excel_online_examples.example_Cell AS 
	SELECT * 
	FROM (
		CALL excel_online.Cell (drive_url => (CALL excel_online.HelperUrlDrive ()), item_id => 'B5C4279BC2029D1C!110', worksheet_id_or_name => 'Sheet1', "row" => 1, "column" => 2)
	) AS x

Cell_clear

Clear cell
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (required): Worksheet id or name
<row> (required): Row number of the cell to be retrieved (zero-indexed)
<column> (required): Column number of the cell to be retrieved (zero-indexed)
<applyTo> (required): Determines the type of clear action. Possible values are: All, Formats, Contents

Cell_delete

Deletes the cell
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (required): Worksheet id or name
<row> (required): Row number of the cell to be retrieved (zero-indexed)
<column> (required): Column number of the cell to be retrieved (zero-indexed)
<shift> (required): Specifies which way to shift the cells. The possible values are: Up, Left

Cell_insert

Inserts a cell
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (required): Worksheet id or name
<row> (required): Row number of the cell to be retrieved (zero-indexed)
<column> (required): Column number of the cell to be retrieved (zero-indexed)
<shift> (required): Specifies which way to shift the cells. The possible values are: Down, Right

Chart_setData

Resets the source data for the chart
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (required): Worksheet id or name
<chart_name> (optional): Chart name
<seriesBy> (required): Specifies the way columns or rows are used as data series on the chart. Can be one of the following: Auto (default), Rows, Columns. The possible values are: Auto, Columns, Rows
<sourceData> (optional): The Range object corresponding to the source data

Example

CREATE VIEW excel_online_examples.example_Chart_setData AS 
	SELECT * 
	FROM (
		CALL excel_online.Chart_setData (
			drive_url => (CALL excel_online.HelperUrlDrive ()),
			file_id => 'B5C4279BC2029D1C!110',
			worksheet_id_or_name => '{00000000-0001-0000-0000-000000000000}',
			chart_name => '{69A5599A-E185-45E3-B878-8CEA29EA6A13}',
			seriesBy => 'Auto',
			sourceData => 'A1:B14'
		)
	) AS x

Chart_setPosition

Positions the chart relative to cells on the worksheet
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (required): Worksheet id or name
<chart_name> (optional): Chart name
<startCell> (required): The start cell. This is where the chart will be moved to. The start cell is the top-left or top-right cell, depending on the user's right-to-left display settings
<endCell> (required): The end cell. If specified, the chart's width and height will be set to fully cover up this cell/range

Example

CREATE VIEW excel_online_examples.example_Chart_setPosition AS 
	SELECT * 
	FROM (
		CALL excel_online.Chart_setPosition (
			drive_url => (CALL excel_online.HelperUrlDrive ()),
			file_id => 'B5C4279BC2029D1C!110',
			worksheet_id_or_name => '{00000000-0001-0000-0000-000000000000}',
			chart_name => '{69A5599A-E185-45E3-B878-8CEA29EA6A13}',
			startCell => 'C1',
			endCell => 'G10'
		)
	) AS x

Charts

List of chart objects
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<item_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (required): Worksheet id or name
<chart_name> (optional): Chart name
<filter> (optional): Filter criteria for which entities will be returned
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to

Charts_add

Creates a new chart
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (required): Worksheet id or name
<chart_name> (optional): Chart name
<seriesBy> (optional): Specifies the way columns or rows are used as data series on the chart. The possible values are: Auto, Columns, Rows
<sourceData> (optional): The Range object corresponding to the source data
<type> (required): Represents the type of a chart. The possible values are: ColumnClustered, ColumnStacked, ColumnStacked100, BarClustered, BarStacked, BarStacked100, LineStacked, LineStacked100, LineMarkers, LineMarkersStacked, LineMarkersStacked100, PieOfPie, etc..

Drives

Drive resources available for a target User, Group, or Site
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<filter> (optional): Filter criteria for which entities will be returned
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to

Example

CREATE VIEW excel_online_examples.example_Drives AS 
	SELECT * 
	FROM (
		CALL excel_online.Drives ()
	) AS x

File_copy

Copy file"
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<item_id> (required): File id"
<parentReference_driveId> (optional): Reference to the parent item the copy will be created in. Unique identifier of the drive instance that contains the item
<parentReference_id> (optional): Reference to the parent item the copy will be created in. Unique identifier of the item in the drive
<name> (optional): The new name for the copy. If this isn't provided, the same name will be used as the original

Files

The driveItem resources represents a file, folder, or other item stored in a drive
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<files_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlFiles"
<filter> (optional): Filter criteria for which entities will be returned
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to

Files_createLink

Create a new sharing link if the specified link type doesn't already exist for the calling application. If a sharing link of the specified type already exists for the app, the existing sharing link will be returned
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<files_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlFiles"
<scope> (optional): The scope of link to create. Either anonymous or organization
<type> (required): The type of sharing link to create. Either view, edit, or embed

Folder_new

Create new folder
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<files_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlFiles"
<folder_name> (required): New folder name

HelperUrlDrive

Part of URL defining drive assembled from parameters
Parameter
<drive_id> (optional): Get OneDrive by Id
<id_or_user_principal_name> (optional): The identifier for the user object who owns the OneDrive
<group_id> (optional): The identifier for the group which owns the document library
<site_id> (optional): The identifier for the site that contains the document library
<many_drives> (optional): Return the part of URL with "drive" or "drives"

HelperUrlFiles

Part of URL defining files assembled from parameters
Parameter
<directory_item_id> (optional): Directory Id
<directory_path> (optional): Directory full path relative to root
<file_item_id> (optional): File Id
<file_path_and_name> (optional): Full name of the file with path relative to root
<show_shared_files> (optional): Show shared files

NamedItems

List of nameditem objects
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<item_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<name> (optional): Name of namrd item
<filter> (optional): Filter criteria for which entities will be returned
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to

Example

CREATE VIEW excel_online_examples.example_NamedItems AS 
	SELECT * 
	FROM (
		CALL excel_online.NamedItems (drive_url => (CALL excel_online.HelperUrlDrive ()), item_id => 'B5C4279BC2029D1C!110')
	) AS x

NamedItems_add

Adds a new name to the collection of the given scope using the user's locale for the formula
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<comment> (optional): The comment associated with the named item
<reference> (optional): The formula or the range that the name will refer to
<name> (optional): The name of the named item

NamedItems_addFormulaLocal

Adds a new name to the collection of the given scope using the user's locale for the formula
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<comment> (optional): The comment associated with the named item
<formula> (optional): The formula or the range that the name will refer to
<name> (optional): The name of the named item

TableColumns

List of tablecolumn objects
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<item_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<table_id_or_name> (required): Table id or name
<filter> (optional): Filter criteria for which entities will be returned
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to

TableColumns_add

Create new column
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<table_id_or_name> (required): Table id or name
<name> (optional): Name of the new column
<values> (optional): Array of unformatted values
<index> (optional): Index of the new column

TableData

Show XML data as table
Parameter
<data> (required): Data to show

TableRows

List of tablerow objects
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<item_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<table_id_or_name> (required): Table id or name
<filter> (optional): Filter criteria for which entities will be returned
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to

TableRows_add

Adds rows to the end of the table
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<table_id_or_name> (required): Table id or name
<values> (optional): A 2-dimensional array of unformatted values of the table rows (boolean or string or number)
<index> (optional): Specifies the relative position of the new row. If null, the addition happens at the end. Any rows below the inserted row are shifted downwards. Zero-indexed

Table_clearFilters

Clears all the filters currently applied on the table
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<table_id_or_name> (optional): Table id or name

Table_convertToRange

Converts the table into a normal range of cells. All data is preserved
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<table_id_or_name> (optional): Table id or name

Table_reapplyFilters

Reapplies all the filters currently on the table
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<table_id_or_name> (optional): Table id or name

Tables

List of table objects
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<item_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<table_id_or_name> (optional): Table id or name
<filter> (optional): Filter criteria for which entities will be returned
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to

Example

CREATE VIEW excel_online_examples.example_Tables AS 
	SELECT * 
	FROM (
		CALL excel_online.Tables (drive_url => (CALL excel_online.HelperUrlDrive ()), path_relative_to_root => 'Docs/Book1.xlsx')
	) AS x

Tables_add

Create a new table
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<hasHeaders> (required): Boolean value that indicates whether the data being imported has column labels. If the source does not contain headers (i.e,. when this property set to false), Excel will automatically generate header shifting the data down by one row
<address> (optional): Address or name of the range object representing the data source. If the address does not contain a sheet name, the currently-active sheet is used

UploadToWorksheet

Append data to worksheet
Parameter
<source_object> (required): Name of the procedure or table
<exclude_columns> (optional): CSV list of columns to exclude
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<file_path> (optional): Workbook file name with path relative from root
<worksheet_id> (optional): Id of the existing worksheet
<worksheet_name> (optional): Name of the new or existing Worksheet name
<clean_worksheet> (optional): Clean old data before writing new data, otherwise append at the bottom of existing data

UsedRange

Used range is the smallest range that encompasses any cells that have a value or formatting assigned to them. If the worksheet is blank, this function will return the top left cell
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<item_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (required): Worksheet id or name
<max_lines> (optional): How many lines to read (when NULL - all lines)
<filter> (optional): Filter criteria for which entities will be returned
<preview> (optional): Preview only, don't write into table

CREATE VIEW excel_online_examples.example_UsedRange AS 
	SELECT * 
	FROM (
		CALL excel_online.UsedRange (drive_url => (CALL excel_online.HelperUrlDrive ()), path_relative_to_root => 'Docs/Book1.xlsx', worksheet_id_or_name => 'Sheet1')
	) AS x

UsedRange_clear

Clear the range
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (required): Worksheet id or name
<applyTo> (required): Determines the type of clear action. Possible values are: All, Formats, Contents

UsedRange_delete

Deletes the cells associated with the range
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (required): Worksheet id or name
<shift> (required): Specifies which way to shift the cells. The possible values are: Up, Left

UsedRange_insert

Inserts a range of cells into the worksheet in place of this range, and shifts the other cells to make space
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (required): Worksheet id or name
<shift> (required): Specifies which way to shift the cells. The possible values are: Down, Right

WorksheetRange

Range of the entire table
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<item_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<address> (optional): The address or the name of the range. If not specified, the entire worksheet range is returned
<filter> (optional): Filter criteria for which entities will be returned
<preview> (optional): Preview only, don't write into table

Example

CREATE VIEW excel_online_examples.example_WorksheetRange AS 
	SELECT * 
	FROM (
		CALL excel_online.WorksheetRange (drive_url => (CALL excel_online.HelperUrlDrive ()), path_relative_to_root => 'Docs/Book1.xlsx', worksheet_id_or_name => 'Sheet1')
	) AS x

WorksheetRange_clear

Clear table range
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<address> (optional): The address or the name of the range. If not specified, the entire worksheet range is returned
<applyTo> (required): Determines the type of clear action. Possible values are: All, Formats, Contents

WorksheetRange_delete

Deletes the cells associated with the table range
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<address> (optional): The address or the name of the range. If not specified, the entire worksheet range is returned
<shift> (required): Specifies which way to shift the cells. The possible values are: Up, Left

WorksheetRange_insert

Inserts a range of cells into the worksheet in place of this range, and shifts the other cells to make space
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<address> (optional): The address or the name of the range. If not specified, the entire worksheet range is returned
<shift> (required): Specifies which way to shift the cells. The possible values are: Down, Right

WorksheetRange_merge

Merge the range cells into one region in the worksheet
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<address> (optional): The address or the name of the range. If not specified, the entire worksheet range is returned
<across> (required): Set true to merge cells in each row of the specified range as separate merged cells. The default value is false

WorksheetRange_unmerge

Unmerge the range cells into separate cells
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<address> (optional): The address or the name of the range. If not specified, the entire worksheet range is returned

WorksheetRange_update

Update a range of cells on the worksheet
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<address> (optional): The address or the name of the range. If not specified, the entire worksheet range is returned
<values> (required): A 2-dimensional array of unformatted values of the table rows (boolean or string or number), example: ["Hello", "100","1/1/2016", null]
<formulas> (optional): A 2-dimensional array of formulas in A1-style notation, example: [null, null, null, "=B1*2"]
<formulasLocal> (optional): A 2-dimensional array of formulas in A1-style notation, in the user's language and number-formatting locale
<formulasR1C1> (optional): A 2-dimensional array of formulas in R1C1-style notation
<numberFormat> (optional): A 2-dimensional array of number format codes, example: [null,null, "m-ddd", null]
<columnHidden> (optional): Represents if all columns of the current range are hidden
<rowHidden> (optional): Represents if all rows of the current range are hidden

Worksheets

List of worksheet objects
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<item_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<worksheet_id_or_name> (optional): Worksheet id or name
<filter> (optional): Filter criteria for which entities will be returned
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to

Example

CREATE VIEW excel_online_examples.example_Worksheets AS 
	SELECT * 
	FROM (
		CALL excel_online.Worksheets (drive_url => (CALL excel_online.HelperUrlDrive ()), path_relative_to_root => 'Docs/Book1.xlsx')
	) AS x

Worksheets_add

Adds a new worksheet to the workbook. The worksheet will be added at the end of existing worksheets
Parameter
<drive_url> (required): Url of the endpoint assembled by "excel_online.HelperUrlDrive"
<file_id> (optional): File Id of a workbook
<path_relative_to_root> (optional): Workbook file name with path relative from root
<name> (required): The name of the worksheet to be added. If specified, name should be unqiue. If not specified, Excel determines the name of the new worksheet