c# – ‘文件已损坏,无法打开’OpenXML

概述我从Open XML sdk获得了代码而不是SpreadsheetDocument.Create,我使用了SpreadsheetDocument.Open 在添加到文件中的图像之后,此代码正在运行并在.xlsx中添加图像.我打开显示的文件 – > The file is corrupt and cannot be opened 如果您想了解更多细节请！让我知道. 参考网址 – > https:// 我从Open XML sdk获得了代码而不是Spreadsheetdocument.Create,我使用了Spreadsheetdocument.Open

在添加到文件中的图像之后,此代码正在运行并在.xlsx中添加图像.我打开显示的文件 – >

The file is corrupt and cannot be opened

如果您想了解更多细节请！让我知道.

参考网址 – > https://code.msdn.microsoft.com/office/How-to-insert-image-into-93964561

谢谢您的帮助！

/// <summary>    /// add sheet in xlsx then add image into it.    /// </summary>    /// <param name="sfile"></param>    /// <param name="imagefilename"></param>    public voID InsertimginExcel(string sfile,string imagefilename)    {        try        {            // Create a spreadsheet document by supplying the filepath.             using (Spreadsheetdocument spreadsheetdocument = Spreadsheetdocument.                Open(sfile,true))            {                // Add a WorkbookPart to the document.                 //WorkbookPart workbookpart = spreadsheetdocument.AdDWorkbookPart();                //workbookpart.Workbook = new Workbook();                // Add a WorksheetPart to the WorkbookPart.                 WorksheetPart worksheetPart = spreadsheetdocument.WorkbookPart.AddNewPart<WorksheetPart>();                worksheetPart.Worksheet = new Worksheet(new SheetData());                // Add Sheets to the Workbook.                 Sheets sheets = spreadsheetdocument.WorkbookPart.Workbook.                    AppendChild<Sheets>(new Sheets());                // Append a new worksheet and associate it with the workbook.                 Sheet sheet = new Sheet()                {                    ID = spreadsheetdocument.WorkbookPart.GetIDOfPart(worksheetPart),SheetID = 1,name = "mySheet"                };                sheets.Append(sheet);                var drawingsPart = worksheetPart.AddNewPart<DrawingsPart>();                if (!worksheetPart.Worksheet.ChildElements.OfType<documentFormat.OpenXml.Spreadsheet.Drawing>().Any())                {                    worksheetPart.Worksheet.Append(new documentFormat.OpenXml.Spreadsheet.Drawing { ID = worksheetPart.GetIDOfPart(drawingsPart) });                }                if (drawingsPart.WorksheetDrawing == null)                {                    drawingsPart.WorksheetDrawing = new WorksheetDrawing();                }                var worksheetDrawing = drawingsPart.WorksheetDrawing;                var imagePart = drawingsPart.AddImagePart(ImagePartType.Jpeg);                using (var stream = new fileStream(imagefilename,fileMode.Open))                {                    imagePart.FeedData(stream);                }                Bitmap bm = new Bitmap(imagefilename);                documentFormat.OpenXml.Drawing.Extents extents = new documentFormat.OpenXml.Drawing.Extents();                var extentsCx = (long)bm.WIDth * (long)((float)914400 / bm.HorizontalResolution);                var extentsCy = (long)bm.Height * (long)((float)914400 / bm.VerticalResolution);                bm.dispose();                var colOffset = 0;                var rowOffset = 0;                int colNumber = 5;                int rowNumber = 10;                var nvps = worksheetDrawing.Descendants<Xdr.NonVisualDrawingPropertIEs>();                var nvpID = nvps.Count() > 0 ?                    (UInt32Value)worksheetDrawing.Descendants<Xdr.NonVisualDrawingPropertIEs>().Max(p => p.ID.Value) + 1 :                    1U;                var oneCellAnchor = new Xdr.OneCellAnchor(                    new Xdr.FromMarker                    {                        ColumnID = new Xdr.ColumnID((colNumber - 1).ToString()),RowID = new Xdr.RowID((rowNumber - 1).ToString()),ColumnOffset = new Xdr.ColumnOffset(colOffset.ToString()),RowOffset = new Xdr.RowOffset(rowOffset.ToString())                    },new Xdr.Extent { Cx = extentsCx,Cy = extentsCy },new Xdr.Picture(                        new Xdr.NonVisualPicturePropertIEs(                            new Xdr.NonVisualDrawingPropertIEs { ID = nvpID,name = "Picture " + nvpID,Description = imagefilename },new Xdr.NonVisualPictureDrawingPropertIEs(new A.PictureLocks { NoChangeAspect = true })                        ),new Xdr.BlipFill(                            new A.Blip { Embed = drawingsPart.GetIDOfPart(imagePart),CompressionState = A.BlipCompressionValues.Print },new A.Stretch(new A.FillRectangle())                        ),new Xdr.ShapePropertIEs(                            new A.transform2D(                                new A.Offset { X = 0,Y = 0 },new A.Extents { Cx = extentsCx,Cy = extentsCy }                            ),new A.PresetGeometry { Preset = A.ShapeTypeValues.Rectangle }                        )                    ),new Xdr.ClIEntData()                );                worksheetDrawing.Append(oneCellAnchor);                //workbookpart.Workbook.Save();                // Close the document.                 spreadsheetdocument.Close();            }        }        catch (Exception ex)        {            Console.Writeline(ex.Message);            //log.Error("error occur while creating sheet and adding image --> " + ex.Message.ToString());        }    }

解决方法 不确定xlsx文件可以处理多少个工作簿部分和工作表部分,以及SheetID是否必须是所有表单的文档唯一.尝试将ID更改为例如5如果没有帮助：不要为工作表创建新的工作簿部分,如果可能的话,使用existig. 总结

以上是内存溢出为你收集整理的c# – ‘文件已损坏,无法打开’OpenXML全部内容，希望文章能够帮你解决c# – ‘文件已损坏,无法打开’OpenXML所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。