Loading

VSTO 2010: Write data into Excel file

SinYee Foo

13y2.3k

Hi, I am newbie for VSTO 2010. Now i am trying to generate the excel file with data from Sqlserver . I am using Linq to write the query...but, I stuck on that...
Please can anyone help me...?

this my code:

Excel.Worksheet DemoWorkSheet = Globals.ThisWorkbook.Application.ActiveSheet as Excel.Worksheet;

DemoVSTODataContext demo = new DemoVSTODataContext();

var login = from emplist in demo.Logins

select emplist;

so now..how i continue my coding...?
Thanks for helping...

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Santhosh Kumar Jayaraman13y ago
If you want to import data to excel from sql server table, then you can directly do it in SQL server.

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\testing.xls;',
'SELECT Name, Department FROM [Sheet1$]')
SELECT [Name], [Department] FROM employee
GO