Facing Issue when using smart markers object with column name contains dot.
Data is not lading to the excel for columns having dot symbol.
Sample Code below,
// Create a datatable
DataTable dt = new DataTable(“ExpenseDetails”);
dt.Columns.Add(“Name”);
dt.Columns.Add(“Expense Misc.”);// Effected Column - column name contais dot , apose not printing the data in to the excel(we have similar kind of scenarios with multiple columns which are genrated dynamically)
dt.Rows.Add(“Raj”, 100);
dt.Rows.Add(“Roy”,200);
// Instantiating a WorkbookDesigner object
WorkbookDesigner wd = new WorkbookDesigner();
// Open a designer spreadsheet containing smart markers
wd.Workbook = new Workbook("Template/Designer.xlsx");
wd.SetDataSource(dt);
// Process the smart markers to fill the data into the worksheets.
wd.Process();