We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

XlsIO - MSSQL T-SQL - interaction

Thread ID:

Created:

Updated:

Platform:

Replies:

143514 Mar 22,2019 04:01 PM UTC Mar 25,2019 12:18 PM UTC WinForms 1
loading
Tags: XlsIO
Ricardo
Asked On March 22, 2019 04:01 PM UTC

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 [Syncfusion]
Replied On March 25, 2019 12:18 PM UTC

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. 
 
 
Please let us know if you have any queries. 

Regards, 
Dilli babu. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon