XlsIO - MSSQL T-SQL - interaction

[Ricardo]

Hi!

Is there any way to interact with XlsIO using MSSQL T-SQL? 

What I am trying to do is dump data from a database to an Excel file that already has a format in certain cells (different numeric data formats, dates).

Do you have any example, let's say with CLR?

Thanks!

[Dilli Babu Nandha Gopal]

Hi Ricardo, 

 

Thank you for contacting Syncfusion support. 

 

Yes. It is possible to use MSSQL with XlsIO to import data into an Excel document. Please refer the UG documentation from the below link. 

 

UG link : https://help.syncfusion.com/file-formats/xlsio/working-with-tables#create-a-table-from-external-connection  

 

Please let us know if you have any queries. 

Regards, 

Dilli babu.