public virtual void AddSheet(string sheetName, byte[] bytes)
{
SpreadSheetCsvParser parser = new SpreadSheetCsvParser(true);
Row[] rows = parser.Parse(bytes, encoding).ToArray();
Sheet s = new Sheet(sheetName, rows);
sheets.Add(s);
}
public virtual void AddSheet(string sheetName, string content)
{
SpreadSheetCsvParser parser = new SpreadSheetCsvParser(true);
Row[] rows = parser.Parse(content).ToArray();
Sheet s = new Sheet(sheetName, rows);
sheets.Add(s);
}
public SpreadSheet(byte[] bytes, Encoding encoding, SpreadSheetSourceType srcType = SpreadSheetSourceType.CSV)
{
SpreadSheetParser parser = null;
if (srcType == SpreadSheetSourceType.CSV)
{
parser = new SpreadSheetCsvParser(true);
}
else if (srcType == SpreadSheetSourceType.XML)
{
parser = new SpreadSheetXMLParser();
}
this.encoding = encoding;
parser.preprocessor = preprocessor;
sheets.AddRange(parser.ParseSheet(bytes, encoding));
SetSheet(0);
}
