I already do have an excel template, I want to insert the data as per users requirement in particular sheets and cells. (If data exists) in dataset.
I already tried to do this and was very close to success, but excel was not closing instance on server side at the end.
Is your Aspose product will get rid of all these problems and Can I use my template in Aspose and manipulate the data through coding in particular cells.
Earlier reply will be highly obliged
Thanks
This message was posted using Email2Forum by ShL77.
Yes, Aspose.Cells provide the feature to import the data from different datasources to worksheets includeing DataTable,DataView etc. Please see the following sample code which will load the data from a database using simple ADO.NET functions and Import the data to the worksheet.
Sample Code:
Dim con As OleDbConnection = New OleDbConnection("provider=microsoft.jet.oledb.4.0;
data source=d:\test\Northwind1.mdb")
con.Open()
Dim cmd As OleDbCommand = New OleDbCommand("Select * from employees", con)
Dim da As OleDbDataAdapter = New OleDbDataAdapter()
da.SelectCommand = cmd
Dim ds As DataSet = New DataSet()
da.Fill(ds, "Employees")
Dim workbook As Workbook = New Workbook()
workbook.Worksheets(0).Cells.ImportDataTable(ds.Tables(0), True, 0, 0)
workbook.Save("d:\test\importtest.xls")
Please see the following link which provides the details about different import processes.