如何使用 C# Windows 应用程序将 byte[] 中的图像写入 MS WORD [英] How to write an image from byte[] into MS WORD using C# Windows application

查看:18
本文介绍了如何使用 C# Windows 应用程序将 byte[] 中的图像写入 MS WORD的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我尝试将 FileStreamStreamWriter 中的数据写入 word 文件.

I have tried to write data from FileStream, StreamWriter to a word file.

当数据为文本格式(使用StreamWriter)时它工作正常.但是,当我对 Binarywriter(用于将图像写入 Word 文档)进行相同尝试时,它写入的 Word 文档不正确.

It's working fine when the data is text format(using StreamWriter). But when I tried the same with Binarywriter (for writing image to word doc) it's writing incorrectly to the word document.

在下面的代码中,lstOrderedSpares[index].SparePicture 是包含图像数据的字节数组.

In below code lstOrderedSpares[index].SparePicture is the byte array containing the image data.

我需要一个没有 OPENXML 的解决方案.

I need a solution without OPENXML.

这是我迄今为止尝试过的:

This is what I have tried so far :

这是我的按钮单击,我将数据初始化为类和 List

Here is my button click where i am initializing the data to classes and List

 private void btnCreateQuotation_Click(object sender, EventArgs e)
    {
        try
        {
            Quotation aQuotation = new Quotation();
            aQuotation.QuotationId = quotationId;
            aQuotation.QuotationDate = lblQuotationDateValue.Text;

        //Reading from Datagridview and adding to List<Spare>

            List<Spare> lstOrderedSpares = new List<Spare>();
            if (dataGridView1.Rows.Count > 0)
            {
                foreach (DataGridViewRow dr in dataGridView1.Rows)
                {
                    Spare aSpare = new Spare();
                    aSpare.SapreSerialNumber = dr.Cells["SlNo"].Value.ToString();
                    aSpare.SparePartId = dr.Cells["SparePartID"].Value.ToString();
                    aSpare.SparePicture = (byte[])dr.Cells["SparePicture"].Value;
                    aSpare.SpareDescription = dr.Cells["SpareDescription"].Value.ToString();
                    aSpare.EURPrice = Convert.ToDouble(dr.Cells["EURPrice"].Value.ToString());
                    aSpare.Quantity = Convert.ToDouble(dr.Cells["Quantity"].Value.ToString());
                    aSpare.TotalPrice = Convert.ToDouble(dr.Cells["TotalPrice"].Value.ToString());
                    aSpare.DeliveryCharge = Convert.ToDouble(txtDeliveryCharge.Text.Trim());
                    aSpare.Vat = txtVAT.Text.Trim();
                    aSpare.INRPrice = Convert.ToDouble(dr.Cells["INRPrice"].Value.ToString());
                    lstOrderedSpares.Add(aSpare);
                }
            }

            Contact aContact = new Contact();
            aContact.CompanyName = txtCustomerName.Text.Trim();
            aContact.ContactName = cmbContactPersonName.Text;
            aContact.ContactId = Convert.ToInt32(lblContactPeronIdValue.Text);
            aContact.CompanyId = Convert.ToInt32(lblCustomerIDValue.Text);

            string fileName = "SparePart_" + aQuotation.QuotationId + "_";
            string fileNameWithPath = "C:\Quotations\SpareQuotations\" + fileName;
            if (isaddedtodb)
            {
                CreateDocument(aQuotation, aContact, lstOrderedSpares, fileNameWithPath);

                fileNameWithPath = fileNameWithPath + aContact.CompanyName.Trim() + ".doc";
                btnCreateQuotation.Visible = false;
                this.Hide();
                //start ms word to open the document 
                System.Diagnostics.Process.Start(fileNameWithPath);
            }
        }
        catch (Exception objEx)
        {

        }
    }

这里是将数据写入word文档的CreateDocument方法.

and here is the CreateDocument Method which writes data to the word document.

 private void CreateDocument(Quotation aQuotation, Contact aContact,
                                List<Spare> lstOrderedSpares, string fileNameWithPath)
    {
        try
        {
            _Application oWord = new Microsoft.Office.Interop.Word.Application();
            _Document oDoc = oWord.Documents.Add();
            oWord.Visible = true;


            //modify secondparameter to include customer name in file name 
            fileNameWithPath = fileNameWithPath + aContact.CompanyName.Trim() + ".doc";

            //Insert text
            Range rng = oDoc.Range();
            rng.Text = "TSV/" + aQuotation.EnquiredBy.ToString() + "/JS/" + aQuotation.QuotationId
                    + "/SPARES" + "	" + "	" + "	" + "	" + "	" + aQuotation.QuotationDate;
            //oWord.Selection.EndKey();
            //oWord.Selection.TypeParagraph();
            rng.InsertBreak();
            rng.Text = "To ,";
            rng.InsertBreak();
            rng.Text = "M/s. " + aContact.CompanyName + ",";
            rng.InsertBreak();
            rng.Text = aContact.AddressLine1 + ",";
            rng.InsertBreak();
            rng.Text = aContact.AddressLine2 + ",";
            rng.InsertBreak();
            rng.Text = aContact.City + "," + aContact.State + ",";
            rng.InsertBreak();
            rng.Text = aContact.Country + "-" + aContact.PinNo;
            rng.InsertBreak();
            rng.Text = "Phone : " + aContact.PhoneNo;
            rng.InsertBreak();
            rng.Text = "Mobile No : " + aContact.MobileNo;
            rng.InsertBreak();
            rng.InsertBreak();

            //Salutation and subject

            rng.Text = "	" + "	" + "Kind Attention : " + aContact.ContactName;
            rng.InsertBreak();
            rng.Text = "Dear Sir,";
            rng.InsertBreak();
            rng.Text = "Sub: " + aQuotation.Subject;
            rng.InsertBreak();
            rng.Text = "Ref: your email enquiry dt: " + aQuotation.EmailEnquiredDate;
            rng.InsertBreak();
            rng.Text = "We thank you for your valuable email enquiry dt. " + aQuotation.EmailEnquiredDate
                             + " for supply of spares for your .........Capacity,"
                             + " fabrik nos Sl. No :..................";
            rng.InsertBreak();
            rng.InsertBreak();
            int europeancount = 0;
            for (int index = 0; index < lstOrderedSpares.Count; index++)
            {
                if (lstOrderedSpares[index].INRPrice == 0.00)
                {
                    europeancount++;
                }
            }

            rng.Text = "A) We wish to inform you that the following " + europeancount +
                             " spares can be supplied directly by in Euros.";
            rng.InsertBreak();
            rng.InsertBreak();

            int tempslno1 = 0;
            for (int index = 0; index < lstOrderedSpares.Count; index++)
            {
                if (lstOrderedSpares[index].INRPrice == 0.00)
                {
                    tempslno1++;
                    rng.Text = tempslno1 + "." + lstOrderedSpares[index].SpareDescription.ToUpper() +
                                 " : ARTICLE NO: " + lstOrderedSpares[index].SparePartId + "	" +
                                 Math.Round(lstOrderedSpares[index].EURPrice) + lblEuroSymbol.Text + "(" +
                    new NumberToEnglish().changeCurrencyToWords(Math.Round(lstOrderedSpares[index].EURPrice)) + ")";

                    //To insert a picture from a byte array you need to use the Clipboard to paste it in
                    object endOfContent = oDoc.Content.End - 1;
                    Range rngPic = oDoc.Range(endOfContent);
                    //Here is the trick to convert the ByteArray into an image and paste it in the document
                    Image sparePicture = ByteArrayToImage(lstOrderedSpares[index].SparePicture);
                    Clipboard.SetDataObject(sparePicture);
                    rngPic.Paste();
                    rng.InsertBreak();
                }
            }
            rng.InsertBreak();
            rng.InsertBreak();
            rng.Text = "Price Quoted Ex-works .";
            rng.InsertBreak();
            rng.Text = "Freight/Courier,Insurance,duties,any and all other expenses extra to " +
                             "customers account.";
            rng.InsertBreak();
            rng.InsertBreak();
            rng.Text = "HOW TO ORDER :- Please register your order in favour of ....";
            rng.InsertBreak();
            rng.Text = "PAYMENT :- Full payment in advance against proforma invoice from ...." + " through their bankers ..... ";
            rng.InsertBreak();
            rng.InsertBreak();
            rng.Text = "Delivery / Dispatch: 2 Weeks from the date of receipt of payment.";
            rng.InsertBreak();
            rng.Text = "In case if you have account with ...then kindly mention the account number, " +
                             "since it will be economical if send via ....";
            rng.Text = "Please provide your 'IEC Code number'.";
            rng.InsertBreak();
            rng.InsertBreak();
            rng.Text = "B) We wish to inform you that the following spare can be supplied from ex-stock " + "our Office in INR";
            rng.InsertBreak();
            int tempslno2 = 0;
            for (int index = 0; index < lstOrderedSpares.Count; index++)
            {

                if (lstOrderedSpares[index].INRPrice != 0.00)
                {
                    tempslno2++;
                    rng.Text = tempslno2 + "." + lstOrderedSpares[index].SpareDescription.ToUpper() +
                                 " : ARTICLE NO: " + lstOrderedSpares[index].SparePartId + "	" +
                                 Math.Round(lstOrderedSpares[index].INRPrice) + " " + lblINRSymbol.Text + "(" +
                    new NumberToEnglish().changeNumericToWords(Math.Round(lstOrderedSpares[index].INRPrice)) + ")";

                    //To insert a picture from a byte array you need to use the Clipboard to paste it in
                    object endOfContent = oDoc.Content.End - 1;
                    Range rngPic = oDoc.Range(endOfContent);
                    //Here is the trick to convert the ByteArray into an image and paste it in the document
                    Image sparePicture = ByteArrayToImage(lstOrderedSpares[index].SparePicture);
                    Clipboard.SetDataObject(sparePicture);
                    rngPic.Paste();
                    rng.InsertBreak();
                }
            }

            rng.Text = "Price quoted ex-our office";
            rng.InsertBreak();
            rng.Text = "Taxes: VAT TNGST @ " + lstOrderedSpares[0].Vat + "% extra";
            rng.InsertBreak();
            rng.Text = "Delivery/Despatch: on receipt of order along with payment";
            rng.Text = "Delivery/Courier Charges - extra " + lstOrderedSpares[0].DeliveryCharge.ToString() +
                            "/-";                
            rng.InsertBreak();
            rng.Text = "The order & payment may please be released in favour of...";
            rng.InsertBreak();
            rng.InsertBreak();
            rng.Text = "Payment: Full payment in advance by way of Electronic Transfer as per following details :";
            rng.InsertBreak();
            rng.Text = "Current Account Number: ......";
            rng.InsertBreak();
            rng.Text = "IFSC Code: ..........";
            rng.InsertBreak();
            rng.Text = "Name of the account holder: .........";
            rng.InsertBreak();

            rng.Text = "	" + "	" + "	" + "OR";
            rng.InsertBreak();
            rng.Text = "By way of Demand Draft";
            rng.InsertBreak();
            rng.InsertBreak();
            rng.Text = "Offer validity 30 days";
            rng.InsertBreak();
            rng.Text = "Thanking you and awaiting your valuable instructions to fulfill your needs well in time.";
            rng.InsertBreak();
            rng.InsertBreak();
            rng.Text = "Yours sincerely";
            rng.InsertBreak();

            oWord.Selection.EndKey();
            oWord.Selection.TypeParagraph();

            oDoc.SaveAs(fileNameWithPath);  //If you're creating a document
            oDoc.Close();
            oWord.Quit();
        }
        catch (Exception objEx)
        {

        }
    }

    public Image ByteArrayToImage(byte[] byteArrayIn)
    {
        MemoryStream ms = new MemoryStream(byteArrayIn);
        Image returnImage = Image.FromStream(ms);
        returnImage = ResizeImage(returnImage, new Size(30, 30));
        return returnImage;
    }

    public static Image ResizeImage(Image imgToResize, Size size)
    {
        return (Image)(new Bitmap(imgToResize, size));
    }

推荐答案

当您创建一个文件,例如 C:TempMyWordDoc.doc 并向其中写入数据时使用 FileStream 和 StreamWriter,你实际上是在写信息到文本文件.

When you create a file, eg C:TempMyWordDoc.doc and write data to it using a FileStream and StreamWriter, you're actually writing information to a text file.

doc 或 docx 文件扩展名导致 Microsoft Word 打开文件,但它不是 Word 格式,它只是纯文本.

The doc or docx file extension causes Microsoft Word to open the file, but it is NOT in Word format, its just plain text.

您需要使用 MS Word 对象模型将图片添加到 Word 文档中. 为此,请参考您项目中的 Microsoft.Office.Interop.Word .Net DLL 并尝试以下代码:

You need to use the MS Word Object Model to add pictures into a word document. To do this reference the Microsoft.Office.Interop.Word .Net DLL in your project and try this code:

using Microsoft.Office.Interop.Word;
using System.IO;

private void btnCreateQuotation_Click(object sender, EventArgs e)
{
    var spareList = new List<Spare>();
    spareList.Add(new Spare{ SparePicture  = ImageToByteArray(Image.FromFile(@"C:	emp11.png"))});
    spareList.Add(new Spare { SparePicture = ImageToByteArray(Image.FromFile(@"C:	emp1.png")) });
    CreateDocument(@"C:TempMyWordDoc.docx", spareList);
}

public void CreateDocument(string docFilePath, List<Spare> lstOrderedSpares)
{
    Microsoft.Office.Interop.Word._Application oWord = new Microsoft.Office.Interop.Word.Application();
    Microsoft.Office.Interop.Word._Document oDoc = oWord.Documents.Add(); //If you're creating a document
    //Microsoft.Office.Interop.Word._Document oDoc = oWord.Documents.Open(docFilePath, ReadOnly: false, Visible: true); //If you're opening a document

    //To see whats going on while populating the word document set Visible = true
    oWord.Visible = true;

    //Insert text
    Object oMissing = System.Reflection.Missing.Value;
    var oPara1 = oDoc.Content.Paragraphs.Add(ref oMissing);
    oPara1.Range.Text = "First Text";
    oPara1.Range.InsertParagraphAfter();

    //Here is the trick to insert a picture from a byte array into MS Word you need to 
    //convert the ByteArray into an Image and using the Clipboard paste it into the document
    Image sparePicture = ByteArrayToImage(lstOrderedSpares[0].SparePicture);
    Clipboard.SetDataObject(sparePicture);
    var oPara2 = oDoc.Content.Paragraphs.Add(ref oMissing);
    oPara2.Range.Paste();
    oPara2.Range.InsertParagraphAfter();

    //Insert some more text
    var oPara3 = oDoc.Content.Paragraphs.Add(ref oMissing);
    oPara3.Range.Text = "Second Text" + Environment.NewLine;
    oPara3.Range.InsertParagraphAfter();

    sparePicture = ByteArrayToImage(lstOrderedSpares[1].SparePicture);
    Clipboard.SetDataObject(sparePicture);
    var oPara4 = oDoc.Content.Paragraphs.Add(ref oMissing);
    oPara4.Range.Paste();
    oPara4.Range.InsertParagraphAfter();

    oDoc.SaveAs(docFilePath); //If you're creating a document
    //oDoc.Save();  //If you're opening a document
    oDoc.Close();
    oWord.Quit();
}

public Image ByteArrayToImage(byte[] byteArrayIn)
{
    using (MemoryStream ms = new MemoryStream(byteArrayIn))
    {
      Image returnImage = Image.FromStream(ms);
      return returnImage;
    }
}

//Method I use to test loading images from disk into byte[]'s and inserting them into word
public byte[] ImageToByteArray(System.Drawing.Image imageIn)
{
    byte[] result = null;
    using (MemoryStream ms = new MemoryStream())
    {
        imageIn.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
        result = ms.ToArray();
    }
    return result;
}

结果如下:

这篇关于如何使用 C# Windows 应用程序将 byte[] 中的图像写入 MS WORD的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆