Hi
I am evaluating ASPOSE.Cell and I am testing it using the trial version. What I try to accomplish is to open workbook from stream, rename the worksheets and save the workbook to http response.
However, I noticed the revised excel 's style is totally changed. Attached is my code. Keeping the original style is very important for us. Any help would be appreciated.
protected void Page_Load(object sender, EventArgs e)
{
Workbook workbook = new Workbook();
using (FileStream fstream = new FileStream("C:\\result.xls", FileMode.Open))
{
workbook.Open(fstream);
int index = 0;
foreach (Worksheet workSheet in workbook.Worksheets)
{
workSheet.Name = "test" + index;
index++;
}
}
workbook.Save("Report.xls", FileFormatType.Default, SaveType.OpenInExcel, Response);
}