byte array excel table convert to word doc table

[Tamil6593]

hi,
I want to bind the byte array excel table in word document based on a bookmark.
can you plz share the link for reference.

Thanks
Tamilselvan S

[rachel.lei]

Hi Tamilselvan,

Thanks for your inquiry.
Our Spire.Doc supports inserting OLE object in word document. You can first convert the byte array to Excel file, then embed the Excel file into the Word file by inserting the ole object. Please download the latest Spire.Office Platinum Version:5.4.2 for testing.

Code: Select all

    //If your byte array data is an Excel file
    public void ByteToExcel1(byte[] byteArray, string outputPath)
    {
        MemoryStream ms = new MemoryStream(byteArray);
        Workbook wb = new Workbook();
        wb.LoadFromStream(ms);
        wb.SaveToFile(outputPath, ExcelVersion.Version2013);
    }

    //If it is just some data in the form of byte array
    public void ByteToExcel2(byte[] byteArray, string outputPath)
    {
        Workbook workbook = new Workbook();
        Worksheet sheet = workbook.Worksheets[0];
        //Insert the data in worksheet
        sheet.InsertArray<byte>(byteArray, 1, 1, true);
        workbook.SaveToFile(outputPath, ExcelVersion.Version2013);
    }

If this is not what you want, to help us better understand your requirement, please provide your input files as well as the output file you expect, so that we could provide you with the corresponding solution.

Sincerely,
Rachel
E-iceblue support team

[rachel.lei]

Hello,

Hope you are doing well.
Did my code help you? Any feedback would be greatly appreciated!

Sincerely,
Rachel
E-iceblue support team