Picture link

Aspose.Cells Product Family
1

With Aspose.Cells, is it possible to copy a range and paste it as a linked picture?

With Excel: `http://j-walk.com/ss/excel/usertips/tip039.htm`

In fact I want to copy 2-3 sheets on another sheet. But since the sheets are very different in styles, column width,... that was the best way I found to do that. If there is something else that does the same job, I can try it...

Thank you

Alexandre

2

This feature is not supported.

3

Do you have any plans to support it?

4

No. This is a complex feature and I don’t have any ideas about how to make it.

5

Hello:

I have a related question in another thread (252819). Is this feature supported now? It seems as though it it based on the answer that I got, but I still can't get the link to update. When I open the linked spreadsheet and save it under another name the pictures are there, but I cannot get the pictures to update with the latest data from the linked source.

So please let me know if this feature (linked picture) is supported or not. I need to get this working before purchasing.

Thanks very much.

Mark

6

Hi Mark,

Please post a sample file here, we will check it soon.<o:p></o:p>


Thank you.

7

Here is the code I am trying:

Workbook wbSrc = new Workbook("D:\\test\\shapes source.xlsx");Workbook

wb = new Workbook("D:\\test\\shapes dest.xlsx");

CellsHelper.StartupPath = "d:\\test\\";

wbSrc.CalculateFormula();

wb.CalculateFormula();

wb.UpdateLinkedDataSource(new Workbook[] {wbSrc});

wb.Save("D:\\test\\shapes dest.xlsx");

wb.Save("D:\\test\\shapes dest.pdf", FileFormatType.Pdf);

I am attaching the two spreadsheets. Thanks very much.

Mark

8

Hi,

Please try our latest version v5.1.2, it should work fine.

Kindly let us know if your still find any issue.

Thank you.