Smart Markers - Support Rich Text Format Value

Aspose.Cells Product Family
,
1

Hi Team,

Please provide the solution to handle the rich format text data while rendering it into excel file using smart marker in set data source feature.

Attached the sample test files hereSmartMarker_HTML.zip (7.4 KB)

Thanks & Regards,
Shyamala

2

@Shyamu,
We have observed the scenario and logged it in our database for further analysis. We will write back here once any update is available for sharing.

3

@Shyamu,
You may try to use the attached input file and share your feedback. Here is the link to the document for more information on using HTML property of SmartMarkers.
Input_Excel_File.xlsx.zip (7.4 KB)
Output_Excel_File.xlsx.zip (8.0 KB)

4

Thanks for you solution Ahsaniq !!

I was successfully handled a HTML text in excel using smart marker.

5

Hi Team,

Could you please help me to achieve the column iteration depends on input request size (eg: some times no of column is 2, sometimes no of column is 6, so on) using smart marker set data source?

I have attached the expected output excel and input request for column iteration along with row iteration.

Please check it and share the solution to achieve it.

Thanks in Advance !!SmartMarker_Column_Iteration.zip (8.3 KB)

6

@Shyamu,
You may please try the following sample code which may help you in generating the desired output. Please note that it is not possible to generate output dynamically in two directions simultaneously as data can be populated either horizontally or vertically.

// Instantiate a new Workbook designer.
WorkbookDesigner report = new WorkbookDesigner();

// Get the first worksheet of the workbook.
Worksheet w = report.Workbook.Worksheets[0];

// Set the Variable Array marker to a cell.
// You may also place this Smart Marker into a template file manually in Ms Excel and then open this file via Workbook.
w.Cells["A1"].PutValue("&=$VariableArray1(horizontal)");

// Set the DataSource for the marker(s).
report.SetDataSource("VariableArray1", new string[] { "English", "Arabic", "Hindi", "Urdu", "French" });


// Set the Variable Array marker to a cell.
// You may also place this Smart Marker into a template file manually in Ms Excel and then open this file via Workbook.
w.Cells["A4"].PutValue("&=$VariableArray2(horizontal)");

// Set the DataSource for the marker(s).
report.SetDataSource("VariableArray2", new string[] { "English", "Arabic", "Hindi"});

// Process the markers.
report.Process(false);

// Save the Excel file.
report.Workbook.Save("output.xlsx");
7

Hi Team,

I need a solution to render serial number into excel first column along with other data while iterating a list of data using Excel Smart Marker in SetDataSource Method.

Please refer the attached sample test file

Thanks & Regards,
Shyamala BSmartMarker_Excel_WithSerialNo.zip (14.5 KB)

8

@Shyamu,

Since your serial number column does not come from your source and exists outside of Smart Markers, so you cannot evaluate auto-numbers in the data source or in smart markers. You have to insert/merge those serial numbers manually after your markers are processed and data is filled into the cells. For example, you may count the number of records/rows in your custom list, so you may insert counter (serial numbers) into the cells of the first column via Cell.putValue() method. You may simply use some loop to be iterated upto number of records in the list to specify the (variable) counter (e.g. cnt++) to be inserted into the cells of the column accordingly.