- Code: Select all
var workbook = new Workbook();
var sheet = workbook.Worksheets[0];
sheet.Name = sheetName;
var imgWtrmrk = Image.FromFile(Application.StartupPath + "\\limit.jpg");
sheet.PageSetup.BackgoundImage = (Bitmap)imgWtrmrk;
sheet.InsertDataTable(TableName, true, 1, 1);
workbook.SaveToFile(FileName, ExcelVersion.Version97to2003);
workbook.Dispose();
when i open