Hi,
Thanks for considering Aspose.
Do I have events like for example, the Repeater server control (onItemBound??)
Aspose.Cells don't support events.
Do I have the flexibility to manipulate the text as it gets bound to the cells?
Yes you can manipulate text in the cells when the cells are filled with data from the data source.
Here is a sample coding example which manipulate the text in A4 cell. It actually make "1" as superscript text retaining the existing data in the cell. The template file smarker has a few markers like "&=Customers.CustomerID" etc.
OleDbConnection con = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=d:\\Northwind.mdb");
con.Open();
OleDbCommand cmd = new OleDbCommand("Select * from customers",con);
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds,"Customers");
WorkbookDesigner wd = new WorkbookDesigner();
wd.Open("d:\\smarker.xls");
wd.SetDataSource(ds.Tables["Customers"]);
wd.Process(false);
Cell cell = wd.Workbook.Worksheets[0].Cells["A4"];
string txt = Convert.ToString(cell.Value);
int len = txt.Length;
txt = txt + "1";
cell.PutValue(txt);
cell.Characters(len,1).Font.IsSuperscript = true;
wd.Save("d:\\smarker1.xls");
These days, we are in the process of enhancing Smart Markers
Regards
Amjad Sahi
Aspose Nanjing Team