One of the tasks I need to be able toaccomplish is that of selecting an Excel range, complete with formatting, and inserting it into a Word document as a table.
Well, I am afraid, there is no direct way to convert your Excel documents into Word documents. You can take images of your worksheet and add them in your word document using Aspose.Words APIs.
Please see the following document how to convert your worksheet into image.
Alternatively, there is another approach, you can convert your Excel documents into PDF using Aspose.Cells and then convert the output PDF into Word document using Aspose.Pdf APIs. Please see the following documentation articles for your reference.
Unfortunately, an image won't work as that won't give me an editable table.
It is rather a shame. I was hoping that seeing as the two products 'Cells' and 'Words' were both from the same company there would have been some degree of interoperbility available. For me, 90% of my report generation requires this type of operation.
Whilst searching, I did see many reference to a forum post suggesting looking at the ExCell2Word demo.
Well, Aspose.Words team developed a converter (utility) using Aspose.Words and Aspose.Cells APIs. I have attached the utility project here, we suggest you to try it. Also, it is not 100% reliable and there is no warranty that it will insert data/table or spreadsheet contents with maximum accuracy regarding formattings. If you still find any issue while working/ using the utility, you may post a query into Aspose.Words forum, they will check and help you if required.
It is good to know that your issue is resolved now. Let us know if you encounter any other issue, we will be glad to look into it and help you further.