EasyXLS
http://forum.easyxls.com/

Spreadsheet
http://forum.easyxls.com/viewtopic.php?f=5&t=22
Page 1 of 1

Author:  Agapetos [ Tue Jun 20, 2006 6:17 pm ]
Post subject:  Spreadsheet

i want to display excel spreadsheet ( easyxls ) within vbnet form

Author:  exari [ Wed Jun 21, 2006 11:09 am ]
Post subject:  DataGrid

At the moment, we don't provide a visual grid to display the spreadsheet.
You can load the data from the excel spreadsheet using EasyXLS and display it in the .NET DataGrid (System.Web.UI.WebControls.DataGrid) or any other grid.

Here is some sample code:
----------------------------------
'Create an instance of the object that generates Excel files
Dim xls As New ExcelDocument
' Reading the content of the Excel File as DataSet
dataGrid.DataSource = xls.easy_ReadSheet_AsDataSet("SourceData.xls", "Sheet1", sLicense, sLicenseKey)
' Data binding
dataGrid.DataBind()
'Dispose memory
xls.Dispose()
----------------------------------

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/