Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
We are using Aspose.cells for .NET to export data to excel.
This is the method[ sheet.Cells.ImportDataTable(dt, true, "A3"); ] used to import data table to excel.
I want to do the following formatting.
1. Want to set the header row style
2. In a decimal field type I want to check for a particular value say -99999 and set ‘N/A’ in place of that value. I can’t directly put ‘N/A’ in data table and import because data table column type is decimal, that’s why once data is imported to excel I want to change -99999 to ‘N/A’.
For header row style I tried a couple of methods like ApplyStyle , ApplyRowStyle, but whatever style I am trying to apply on a header cell or header row ,it applies to entire table, I can’t set only header row style.
Below is sample code given.
Aspose.Cells.Style style1 = cells["A4"].GetStyle();
style1.Font.IsBold = true;
style1.Font.Color = Color.Red;
Row row = workbook.Worksheets.Cells.Rows;
//Apply the style to it.
Any Help appreciated.