public static IEnumerable <SimpleTable> ToTex(this string xls)
{
FileStream stream = File.Open(xls, FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader = null;
if (Path.GetExtension(xls) == ".xls")
{
excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
}
else if (Path.GetExtension(xls) == ".xlsx")
{
excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
}
else
{
throw new ArgumentException("Not Support Format: ");
}
DataSet dataSet = excelReader.AsDataSet();
foreach (DataTable dataTable in dataSet.Tables)
{
var table = new SimpleTable {
Name = dataTable.TableName,
Value = dataTable.ToTex()
};
yield return(table);
}
excelReader.Close();
}
public static SimpleTable ToJson(this string xls, string sheet)
{
FileStream stream = File.Open(xls, FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader = null;
if (Path.GetExtension(xls) == ".xls")
{
excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
}
else if (Path.GetExtension(xls) == ".xlsx")
{
excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
}
else
{
throw new ArgumentException("Not Support Format: ");
}
DataSet dataSet = excelReader.AsDataSet();
DataTable dataTable = dataSet.Tables[sheet];
var table = new SimpleTable {
Name = dataTable.TableName,
Value = dataTable.ToJson()
};
excelReader.Close();
return(table);
}