1.You may use WebCells.Export method to export sheet data to a DataTable object. After that you may build a SqlDataAdapter object to save the DataTable to SqlServer.
2.The WebCells.MaxRow property indicates the max row number of the cells.
In the database, create table with an ID (ID int)field and an Image field (FStream Image). Create a stored proc to save the file as an image ("sp_AddReport"). Make it fancy by coming up with some scheme to get a Report ID...
In aspx.cs....
using Microsoft.ApplicationBlocks.Data;
...
//TO SAVE THE FILE:
int ReportID = 1; try { MemoryStream mstream = new MemoryStream(); GridWeb1.WebWorksheets.SaveToExcelFile(mstream);
//buffer to hold Document Contents byte[] Docbuffer = mstream.GetBuffer();
//sql string- create a stored proc to handle the two parameters string sql = "sp_AddReport";
//parameters SqlParameter[] myParams = new SqlParameter[2]; myParams[0] = new SqlParameter("@Report", Docbuffer); myParams[1] = new SqlParameter("@ReportID", ReportID);