Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LPDExcelExport conf;
- LPDExcelSheetParameter param;
- LPDExcelSheet sheet;
- List<RWSSchemaDevice> firstPreset = new List<RWSSchemaDevice>();
- List<RWSSchemaDevice> secondPreset = new List<RWSSchemaDevice>();
- List<LPDExcelExport> confList;
- try
- {
- confList = new List<LPDExcelExport>();
- conf = new LPDExcelExport("xd.xlsx");
- param = new LPDExcelSheetParameter("SCHEMA", this.Items.ToList());
- sheet = new LPDExcelSheet("RWSSchemaDeviceComparer");
- sheet.Parameters.Add(param);
- conf.AddSheet(sheet);
- confList.Add(conf);
- foreach(var item in Items)
- {
- firstPreset.Add(item);
- secondPreset.Add(item.SecondPreset);
- }
- // conf = new LPDExcelExport("compareSchema.xlsx");
- // param = new LPDExcelSheetParameter("Dress1", firstPreset);
- // sheet = new LPDExcelSheet("Dress1");
- // sheet.Parameters.Add(param);
- // conf.AddSheet(sheet);
- // confList.Add(conf);
- conf = new LPDExcelExport("xd.xlsx");
- param = new LPDExcelSheetParameter("firstSchema", secondPreset.ToList());
- sheet = new LPDExcelSheet("firstSchema");
- sheet.Parameters.Add(param);
- conf.AddSheet(sheet);
- confList.Add(conf);
- LPDHlpExcelTemplatePrintHelper.PrintToExcel(confList);
- Helper.Dialog.ShowInfoMessage(RWSResourceKeys.RWSPrintSuccesful);
- }
- catch (Exception ex)
- {
- this.HandleError(ex);
- Helper.Dialog.ShowErrorMessage(RWSResourceKeys.RWSPrintFailed, ex.Message);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement