Hi ,
I am using aspose.cells for my app development. In that i am merging the cells of 7 columns in a single row. at last applying autofitter option…
but i got an error like Index and length must refer to a location within the string.Parameter name: length
my code is :
Aspose.Cells.Style headerStyle = sheet.Cells[0, 0].GetStyle();
headerStyle.Font.IsBold = true;
headerStyle.Borders[Aspose.Cells.BorderType.BottomBorder].LineStyle = Aspose.Cells.CellBorderType.Thin;
headerStyle.Borders[Aspose.Cells.BorderType.TopBorder].LineStyle = Aspose.Cells.CellBorderType.Thin;
headerStyle.Borders[Aspose.Cells.BorderType.LeftBorder].LineStyle = Aspose.Cells.CellBorderType.Thin;
headerStyle.Borders[Aspose.Cells.BorderType.RightBorder].LineStyle = Aspose.Cells.CellBorderType.Thin;
Aspose.Cells.Style dataStyle = sheet.Cells[0, 0].GetStyle();
dataStyle.Borders[Aspose.Cells.BorderType.BottomBorder].LineStyle = Aspose.Cells.CellBorderType.Thin;
dataStyle.Borders[Aspose.Cells.BorderType.TopBorder].LineStyle = Aspose.Cells.CellBorderType.Thin;
dataStyle.Borders[Aspose.Cells.BorderType.LeftBorder].LineStyle = Aspose.Cells.CellBorderType.Thin;
dataStyle.Borders[Aspose.Cells.BorderType.RightBorder].LineStyle = Aspose.Cells.CellBorderType.Thin;
dataStyle.IsTextWrapped = true;
notationList.Count = 2;
notationList[0].notesId = 1;
notationList[1].notesId = 2;
notationList[0].notesDescription = “some text”;
notationList[1].notesDescription = “text2”;
rowCount = 15;
int offfset = 4;
if (notationList.Count != 0)
{
sheet.Cells[rowCount + offfset, 0].PutValue(“NoteId”);
headerStyle.HorizontalAlignment = TextAlignmentType.Left;
sheet.Cells[rowCount + offfset, 0].SetStyle(headerStyle);
sheet.Cells[rowCount + offfset, 1].PutValue(".NOTES_DESCRIPTION");
sheet.Cells[rowCount + offfset, 1].SetStyle(headerStyle);
var noOfColumnsToMerge = 8 ;
// create a Range for header and merge it
var headerRange = sheet.Cells.CreateRange(rowCount + offfset, 1, 1, noOfColumnsToMerge);
headerRange.Merge();
headerRange.SetStyle(headerStyle);
int indexValue = 5;
dataStyle.IsTextWrapped = true;
dataStyle.HorizontalAlignment = TextAlignmentType.Left;
//Adding Notes description table after controller specification table
foreach (NoteVO notation in notationList)
{
sheet.Cells[rowCount + indexValue, 0].PutValue(notation.notesId);
// sheet.Cells[rowCount + indexValue, 0].SetStyle(dataStyle);
sheet.Cells[rowCount + indexValue, 1].PutValue(notation.notesDescription);
// sheet.Cells[rowCount + indexValue, 1].SetStyle(dataStyle);
// create a Range for data and merge it
var range = sheet.Cells.CreateRange(rowCount + indexValue, 1, 1, noOfColumnsToMerge);
range.Merge();
for (int colNo = 0; colNo <= noOfColumnsToMerge; colNo++)
sheet.Cells[rowCount + indexValue, colNo].SetStyle(dataStyle);
sheet.AutoFitRow(rowCount + indexValue, 1, noOfColumnsToMerge);
indexValue++;
}
var options = new AutoFitterOptions { AutoFitMergedCells = true };
sheet.AutoFitRows(options); //here i m getting that error
}
please suggest me something