Use below script
DECLARE @PATH VARCHAR(500)
DECLARE @Name Varchar(500)
DECLARE @SQL VARCHAR(500)
SET @Name = TableData.xls'
SET @PATH = '\\C:\'
SET @SQL = 'SELECT * FROM TableName'
DECLARE @cmd VARCHAR(800)
SET @Cmd = 'mkdir ' +@PATH
EXEC master..xp_cmdshell @cmd
DECLARE @FILENAME VARCHAR(200)
SET @FILENAME = @PATH + @Name
EXEC sp_makewebtask
@outputfile = @FILENAME,
@query = @SQL,
@nrowsperpage = 40000,
@lastupdated=0 ,
@resultstitle = ' '