public static List <Row> rows_Raw(this OpenXml_SpreadSheet_WorkSheet worksheet)
{
var id = worksheet.ID;
return((from Row row in worksheet.WorksheetPart.Worksheet.GetFirstChild <SheetData>()
select row).toList());
}
public static List <List <string> > rowsData(this OpenXml_SpreadSheet_WorkSheet workSheet)
{
var rowsData = new List <List <string> >();
var rows = workSheet.rows();
foreach (var row in rows)
{
var cells = new List <string>(); // create clone so that we don't affect the source
cells.AddRange(row.Cells);
rowsData.Add(cells);
}
return(rowsData);
}
public static OpenXml_SpreadSheet add_Sheet(this OpenXml_SpreadSheet spreadSheet, Sheet sheet)
{
var workSheet = new OpenXml_SpreadSheet_WorkSheet(spreadSheet);
workSheet.Sheet = sheet;
workSheet.ID = sheet.Id.Value;
workSheet.Name = sheet.Name.Value;
workSheet.WorksheetPart = (WorksheetPart)spreadSheet.SpreadSheetDocument.WorkbookPart.GetPartById(workSheet.ID);
var sharedStrings = workSheet.OpenXml_SpreadSheet.sharedStrings();
foreach (var row in workSheet.rows_Raw())
{
workSheet.Rows.Add(new OpenXml_SpreadSheet_Row(row.rowData(sharedStrings)));
}
spreadSheet.WorkSheets.Add(workSheet);
return(spreadSheet);
}
public static List <OpenXml_SpreadSheet_Row> rows(this OpenXml_SpreadSheet_WorkSheet workSheet)
{
return(workSheet.Rows);
}
