Then it will put it just before the last child which for me was I was able to fix this problem completely by changing this segment: var imageNumber = dp.ImageParts.Count() Ĭhange ws.Append(drawing) to ws.InsertBefore(drawing, ws.Last) Hope this helps anyone else with a similar issue I'm just using this workbook = new XLWorkbook(filepath) Īfterwards it should open without a problem. Unfortunately I have the same problem but it's not related to the imageNumber being declared as 1Īfter you've inserted the images simply re-open the document using closed xml and save it again. I'm generating a spreadsheet using closed XML and then inserting images using Vincent's code. I'm doing literally the exact same thing.
#INSERT PICTURE IN HEADER EXCEL FOR MAC CRACKED#
Hahahaha this cracked me up when I saw it. InsertImage(workSheet, x, y, width, height, sImagePath) For each sheet, display the sheet information. Var worksheetPart = (WorksheetPart) (relationshipId)
Var relationshipId = sheets.First().Id.Value Var workbookPart = mySpreadsheet.WorkbookPart Using (var mySpreadsheet = SpreadsheetDocument.Open(stream, true)) Public static void InsertImage(MemoryStream stream, long x, long y, string sImagePath) or do something more interesting if you want Picture.NonVisualPictureProperties = nvpp PrstGeom.AdjustValueList = new AdjustValueList() PrstGeom.Preset = ShapeTypeValues.Rectangle Sp.BlackWhiteMode = BlackWhiteModeValues.Auto Stretch.FillRectangle = new FillRectangle() īlip.CompressionState = BlipCompressionValues.Print īlipFill.SourceRectangle = new SourceRectangle() Ĭonvert.ToInt64(Math.Truncate(Convert.ToSingle(914400)/bm.HorizontalResolution)) Ĭonvert.ToInt64(Math.Truncate(Convert.ToSingle(914400)/bm.VerticalResolution)) Nvpp.NonVisualPictureDrawingProperties = nvpdp Var nvpp = new NonVisualPictureProperties() Var nvpdp = new NonVisualPictureDrawingProperties() Nvdp.Name = "Picture " + imageNumber.ToString() Nvdp.Id = new UInt32Value(Convert.ToUInt32(1024 + imageNumber)) Var nvdp = new NonVisualDrawingProperties() Using (var fs = new FileStream(sImagePath, FileMode.Open)) Imgp = dp.AddImagePart(ipt, wsp.GetIdOfPart(dp)) - no drawing part exists, add a new one Switch (sImagePath.Substring(sImagePath.LastIndexOf('.') + 1).ToLower())īreak // TODO: might not be correct.
#INSERT PICTURE IN HEADER EXCEL FOR MAC CODE#
The code im using to insert the image is as follows: public static void InsertImage(this Worksheet ws, long x, long y, long? width, long? height, string sImagePath) One thing I notice is that they do not have a namespace (x) like the generated one does but I don't know if that is causing a problem or not.
I have also tried creating a blank excel document manually and adding an image and it looks pretty similar: Taking the section out seems to allow the file to validate correctly. I have used a small console app and found the error to be Error 1ĭescription: The element has unexpected child element ' I can generate the excel file correctly and it opens up fine however when I try inserting the image in and try to open it in excel It gives an error. I'm trying to add an image to an excel document that has been generated by closedxml using openxml after the spreadsheet has been generated (since closedxml has no way to insert images currently).
0 kommentar(er)
