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(); } } }