Hello,
I Have been generating my excel reports dynamically as above method. i have dictionary object in which i have data and then i write data to excel dynamically same as above described. To do that I have predefined template exists in my machine library. i take that template and write data into it. Now I loose my formatting of all the cells/worksheet when i write data into that template file dynamically. I clear the content of that worksheet before i write data into it. Following is my code.
Workbook workbook = new Workbook(ms);
Worksheet worksheet = workbook.worksheets[0];
if (worksheet.Cells.Count > 0)
{
worksheet.Cells.ClearContents(1, 0, worksheet.Cells.MaxDataRow, worksheet.Cells.MaxDataColumn);
}
int col = 0;
int row = 0;
foreach (KeyValuePair<string, List> entry in reportValues)
{
cell[row, col].PutValue(entry.Key);
foreach (var value in entry.Value)
{
row++;
if (ContainsHTML(Convert.ToString(value)))
cell[row, col].HtmlString = (Convert.ToString(value));
else if (value is DateTime)
{
cell[row, col].PutValue(Convert.ToDateTime(value));
Style style = cell[row, col].GetStyle();
style.Custom = “mm/dd/yyyy”;
cell[row, col].SetStyle(style);
worksheet.AutoFitColumn(col);
}
else if (value is int)
{
cell[row, col].PutValue(Convert.ToInt16(value));
worksheet.AutoFitColumn(col);
}
else if (value is double)
{
cell[row, col].PutValue(Convert.ToDouble(value));
worksheet.AutoFitColumn(col);
}
else if (value is string)
{
cell[row, col].PutValue(Convert.ToString(value));
worksheet.AutoFitColumn(col);
}
else if (value is Boolean)
{
cell[row, col].PutValue(Convert.ToBoolean(value));
worksheet.AutoFitColumn(col);
}
}
row = 0;
col++;
}
My requirement is to not loose the formatting even after clearing and writing data into it. Can someone help me how to maintain formatting of predefined template/worksheet after clearing and writing data into it.
Thanks & Regards
Ashish Rajguru