hi,

I need to workwith the smart markers. but the wrokbook designer is not opening properly. and i tried Workbookdesigner.workbook.open and this one also not came for me

Could you send me an sample, so that i can move with my process.

Thanks,

Sridhar.S

Hi Sridhar,

Thanks for your inquiry.

I will paste the sample code here for your reference: I use a workbook which has three markers (you already know how to specify smart markers):

Sample code:

  DataTable dt = new DataTable("Parties");
            dt.Columns.Add("AboveTheLine");
            dt.Columns.Add("BelowTheLine");
         

            dt.Rows.Add(new object[] {"Acknolwedged by XYZ Corporation:", "John Smith, Vice President"});
            dt.Rows.Add(new object[] { "Acknolwedged by ABC Corporation:", "Angela Methews, Director"});
            dt.Rows.Add(new object[] { "Acknolwedged by DEF Corporation:", "Randy Maxwell, President"});
            dt.Rows.Add(new object[] { "Acknolwedged by WWW Corporation:", "Philip Dean, General Secretary"});
          


            Aspose.Cells.WorkbookDesigner designer = new Aspose.Cells.WorkbookDesigner();
            designer.Workbook = new Workbook("e:\\test\\Book1.xlsx");
            designer.SetDataSource(dt);
            designer.Process();
            designer.Workbook.Save("e:\\test\\Result1.xlsx", SaveFormat.Xlsx);


Please see the document for your complete reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/smart-markers.html

Note: Some of the lines of code in some example there need to be updated in accordance with the latest versions of the product. I will do it soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us