public static void Main(string[] args)
{
string x = ImportTemplate.GetExportTemplate(false, Guid.Empty, Guid.Empty);
Console.WriteLine(x);
Console.ReadLine();
}
static void Main(string[] args)
{
string x = ImportTemplate.GetExportTemplate(false, Guid.Empty, Guid.Empty);
using (Stream fileStream = File.OpenRead(x))
{
MemoryStream stream = new MemoryStream();
fileStream.CopyTo(stream);
stream.Seek(0, SeekOrigin.Begin);
using (ExcelEngine engine = new ExcelEngine())
{
IWorkbook workbook = engine.Excel.Workbooks.Open(stream);
IWorksheet sheet = workbook.Worksheets[0];
if (!ImportProduct.CheckFile(sheet))
{
sheet.Range[1, 19].Text = @"Шаблон отличается";
}
else
{
for (int j = 1; j < sheet.Rows.Length; j++)
{
ImportProduct.ParseProduct(sheet.Rows[j], sheet);
}
}
sheet.Range[1, 19].AutofitRows();
workbook.SaveAs(@"C:\Users\Василий\Desktop\dasdasd2.xls");
workbook.Close();
engine.Dispose();
}
}
}
