I’m trying to use smart markers to fill excel file from DataTable. If DataTable’s column name contains “%” symbol aspose cannot resolve this column
worksheet.Cells[1, i].PutValue("&=[" + dataTable.TableName + “].[” + dataTable.Columns[i].ColumnName + “]”);
Is there exists escape characters for column names, or something else for this purpose.
I attached related project with source files and output file test20_54.xlsx.
As you can see all values in Sheet1 replaced correctly, but in Sheet2 the marker &=[table2].[(%)col22] in second column left unchanged.
We have fixed this issue. Please download Aspose.Cells for .NET (Latest Version) .
Thank you. With provided version of aspose this problem does not appears.