I have not been able to create code that insert sheets. NET component in OpenEdge(see below), managed to create the xlsx-file but the file can not be openend in Excel. First use will be to use it in a p-file with a few input parameters including parameter containing path to a CSV file (containing data), as well as parameters containing path and name to the resulting Excel file, p-file returning status of operation. This is intended to end up as a procedure or class that will be used for several purposes. Append a new worksheet and associate it with the workbook. WorksheetPart.Worksheet = new Worksheet(new SheetData()) WorksheetPart worksheetPart = workbookpart.AddNewPart() Add a WorksheetPart to the WorkbookPart. WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart() SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(filepath, SpreadsheetDocumentType.Workbook) By default, AutoSave = true, Editable = true, and Type = xlsx. Create a spreadsheet document by supplying the filepath. Public static void CreateSpreadsheetWorkbook(string filepath) My problem is how to convert this code into OpenEdge syntax. I am currently working with a project where i plan to use the "Open XML SDK 2.0 for Microsoft Office" components in OpenEdge.įrom Microsoft example code i tested the method pasted below, and this works fine (using VS C# IDE).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |