I'm investigating the use of Aspose. My question is:
Can aspose.cell can handle Word objects linked & embedded into an Excel file? Also, would you have to use a combination of aspose.cells and aspose.words in order to do this?
Thanks, Dirk
This message was posted using Aspose.Live 2 Forum
Hi,
Yes, Aspose.Cells can embed a word document as an ole object, you may use the relevant api.
See the document for your reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/managing-ole-objects.html
Sample code:
//Instantiate a new Workbook.
Workbook workbook = new Workbook();
//Get the first worksheet.
Worksheet sheet = workbook.Worksheets[0];
//Define a string variable to store the image path.
string ImageUrl = @“e:\test\doc.jpg”;
//Get the picture into the streams.
FileStream fs = File.OpenRead(ImageUrl);
//Define a byte array.
byte[] imageData = new Byte[fs.Length];
//Obtain the picture into the array of bytes from streams.
fs.Read(imageData, 0, imageData.Length);
//Close the stream.
fs.Close();
//Get an doc file path in a variable.
string path = @“e:\test\MyDocFile.doc”;
//Get the file into the streams.
fs = File.OpenRead(path);
//Define an array of bytes.
byte[] objectData = new Byte[fs.Length];
//Store the file from streams.
fs.Read(objectData, 0, objectData.Length);
//Close the stream.
fs.Close();
sheet.OleObjects.Add(14, 3, 200, 220, imageData);
//Set embedded ole object data.
sheet.OleObjects[0].ObjectData = objectData;
sheet.OleObjects[0].FileType = OleFileType.Doc;
//Save the excel file
workbook.Save(@“e:\test\MyFile.xls”);
Thank you.