Edit existing excel document embedded into word doc...

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Edit existing excel document embedded into word doc...

Postby rbrynteson » Tue Jun 26, 2012 4:08 am

Not sure it's possible, I've been looking at the examples, so if anyone has any suggestions that would be great. So here is what I have:

I have a word document that I use as a template for a report. I am using Spire.doc to modify the existing document and update some items. Inside this document, I have a few embedded excel spreadsheets. They have two tabs, tab 1 is a graph and tab 2 is the back-end data. The template has no data, so what I'm hoping to do is insert data into the workbook and generate the graph.

So, the questions are:

1. Is it possible to access an excel document, that is embedded in a word document.

2. Any other suggestions.

Thanks,

Richard
rbrynteson
 
Posts: 11
Joined: Wed Jun 20, 2012 3:58 am

Re: Edit existing excel document embedded into word doc...

Postby Suvi.Wu » Tue Jun 26, 2012 8:07 am

Hi Richard,

Thanks for evaluating Spire.Doc.

I am sorry for that Spire.Doc can't edit the embedded excel object at this stage. But it can load a word file including embedded object and embed an object into a word file. So we recommend you generate your data spreadsheet and graph first and then embed them into word file.

By the way, Spire.xls can generate spreadsheet and graph, if you have interest, this page http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html maybe helpful for you.

Have a nice day.

Best wishes.
Suvi
e-iceblue support
User avatar
Suvi.Wu
 
Posts: 156
Joined: Thu Oct 20, 2011 2:53 am

Re: Edit existing excel document embedded into word doc...

Postby rbrynteson » Mon Jul 02, 2012 11:32 pm

Suvi,

Is there a good example of embedding an Excel document into Word? I was looking for one and didn't see one.

Thanks,

Richard
rbrynteson
 
Posts: 11
Joined: Wed Jun 20, 2012 3:58 am

Re: Edit existing excel document embedded into word doc...

Postby nancy » Tue Jul 03, 2012 8:20 am

Hi Richard,

About your problem, I have writed a demo for you in the attachment. You can refer to it. In the codes, you need load a picture to initial the embeded object using two ways:
The first one, you may load a picture whose context is excel context using Spire.XLS product or Spire.Office product.
The second one, you may load other picture what you need.

In the attachment, I use the second method. I suggest that you use the first method because it can offer a good visual effect.
Attachments
SALESSUPPORT-552.7z
demo
(2.81 KiB) Downloaded 196 times
Nancy
e-iceblue support team
contact: nancy.wang@e-iceblue.com
User avatar
nancy
 
Posts: 51
Joined: Wed May 30, 2012 2:02 am

Re: Edit existing excel document embedded into word doc...

Postby rbrynteson » Wed Jul 04, 2012 1:55 am

Nancy,

A very good example. What I'm wondering is if there is a way to grab the chart from the XLS and insert/embed that into the Word document. This just seems to grab the cells/worksheet information.

Thanks,

Richard
rbrynteson
 
Posts: 11
Joined: Wed Jun 20, 2012 3:58 am

Re: Edit existing excel document embedded into word doc...

Postby nancy » Wed Jul 04, 2012 3:19 am

Hi rbrynteson,

I'm sorry that we have no such way of grabing the chart from the XLS and insert/embed that into the Word document. Thank you for your cooperation and understanding.
Nancy
e-iceblue support team
contact: nancy.wang@e-iceblue.com
User avatar
nancy
 
Posts: 51
Joined: Wed May 30, 2012 2:02 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests