Not directly in T-SQL. Normally export is handled using SSIS or similar tool.
XSLX follows the Office OpenXML specification and ultimately is a ZIP file. T-SQL can generate text files but it isn't going to be able to generate an OpenXML document.
Using tSQl is it possible to export to .xlsx format (Excel)... I'm looking to export from a table or view.
I have googled and read a few blogs on similar lines but they seam to work for .xls format only...
Any help or pointers will be highly appreciated.
Yes but it isn't trivial compared to SSIS. If you are going to be querying data then you'll definitely want the SQL Server cmdlets installed. Since you'll likely need to manipulate the Excel app you'll also need Office installed. If that isn't an option then you could probably get away with just using the Excel data source (that still needs to be installed) but you'll need that either way.
Ultimately you'll need to do something along these lines:
I should also mention that if you have R installed in SQL then it supposedly can do it as well but I haven't tried it. Here's a link to an article about it.