/// <summary>
/// Sets the row data.
/// </summary>
/// <param name="worksheet">The sheet</param>
/// <param name="rowData">The row data</param>
/// <param name="sheetRowIndex">Index of the sheet row</param>
/// <param name="columnIndex">Index of the column</param>
/// <param name="columnCount">The column count</param>
/// <param name="area">The area</param>
/// <param name="opt">The opt</param>
static void SetRowData(Worksheet worksheet, List <string> rowData, int sheetRowIndex, int columnIndex, int columnCount, SheetArea area, ImportExportOptions opt)
{
int num = 0;
for (int i = columnIndex; num < rowData.Count; i++)
{
if ((columnCount > 0) && (i < worksheet.GetColumnCount(area)))
{
SetCellData(worksheet, area, sheetRowIndex, i, rowData[num], opt);
}
num++;
}
}
/// <summary>
/// Gets the part data.
/// </summary>
/// <param name="worksheet">The sheet</param>
/// <param name="rowStartIndex">Start index of the row</param>
/// <param name="rowEndIndex">End index of the row</param>
/// <param name="columnStartIndex">Start index of the column</param>
/// <param name="columnEndIndex">End index of the column</param>
/// <param name="area">The area</param>
/// <param name="opt">The opt</param>
/// <returns></returns>
static List <List <object> > GetPartData(Worksheet worksheet, int rowStartIndex, int rowEndIndex, int columnStartIndex, int columnEndIndex, SheetArea area, ImportExportOptions opt)
{
if (!opt.IncludeSheetArea(area))
{
return(null);
}
List <List <object> > list = new List <List <object> >();
bool actualVisible = true;
for (int i = rowStartIndex; i <= rowEndIndex; i++)
{
if (area == SheetArea.ColumnHeader)
{
actualVisible = worksheet.ColumnHeader.Rows[i].ActualVisible;
}
else
{
actualVisible = worksheet.Rows[i].ActualVisible;
}
if (actualVisible || !opt.AsViewed)
{
List <object> list2 = new List <object>();
if (opt.RowHeader && (area == SheetArea.Cells))
{
for (int k = 0; k < worksheet.GetColumnCount(SheetArea.CornerHeader | SheetArea.RowHeader); k++)
{
if (worksheet.GetActualColumnVisible(k, SheetArea.CornerHeader | SheetArea.RowHeader) || !opt.AsViewed)
{
list2.Add(GetCellData(worksheet, SheetArea.CornerHeader | SheetArea.RowHeader, i, k, opt));
}
}
}
for (int j = columnStartIndex; j <= columnEndIndex; j++)
{
if (worksheet.GetActualColumnVisible(j, SheetArea.Cells) || !opt.AsViewed)
{
list2.Add(GetCellData(worksheet, area, i, j, opt));
}
}
list.Add(list2);
}
}
return(list);
}