copy a named range from excel to word with calcualted values and formating

I want to take an excel named range and copy it with calculated values and formatting to a word document with XLSIO and DOCIO.  What is the best way to do this with existing xlsx and docx documents.

3 Replies

SY Sethumanikkam Yogendran Syncfusion Team October 19, 2017 01:59 PM UTC

Hi Eric,

Thank you for contacting Syncfusion support.

We have prepared a sample to copy named range from the Excel along with its formatting to the Word document. Please find the sample from below link and let us know if this helps you.

Sample link:
http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample-1774166472.zip

If we misunderstood any of your requirement, then kindly provide us sample or modified sample of above along with input templates used at your end and screenshot/output Word document of the expected result which will helpful to provide you the appropriate solution at the earliest.

Please let us know if you have any other questions.

Regards,
Sethumanikkam.Y



PG Pon Geetha A J Syncfusion Team October 20, 2017 03:47 AM UTC

Please see attached.  I would like to copy the named range Table1 to a new table inside the cell of another table as seen in the Sample.docx. 
 
Thanks, 
Eric  



MJ Mohanaselvam Jothi Syncfusion Team October 23, 2017 02:23 PM UTC

Hi Eric,

Thank you for your update.

We have prepared a sample to copy the named range in a Worksheet to a Table in Word document with help of XlsIO and DocIO libraries.

Please find the sample link from below: http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample50327257.zip


Please let us know if you have any other questions.

Regards,
Mohanaselvam J.
 


Loader.
Up arrow icon