Snapshots of a sheet

Apr 4, 2011 at 9:16 AM
Edited Apr 4, 2011 at 10:59 AM

Hello All

I am using this control and is extremely easy and professional. You have done fantastic work mdeleon so far

 

1. I don't know if it is possible to create an image screenshot of the range or sheet of the workbook ?

example :

If you are using Excel 2007, follow these very different steps, instead:

  1. Select the cells or other object you want a picture of. (If you select cells, they must be contiguous.)
  2. Display the Home tab of the ribbon.
  3. Click the down arrow under the Paste tool in the Clipboard group. Excel displays a list of options.
  4. Click As Picture to display a submenu.
  5. Click Copy as Picture. Excel displays the Copy Picture dialog box.
  6. In the top part of the dialog box, specify what you want in the picture.
  7. In the bottom part of the dialog box, specify how you want the graphic saved.
  8. Click OK.

http://excel.tips.net/Pages/T003523_Taking_a_Picture.html

 

2. Also,

DocumentFormat.OpenXml is not only for excel right ?

can you give me some directions (if you know) how to use the DocumentFormat.OpenXml for powerpoint. My purpose is create some slides that will contain snapshots of the sheet that i will try create or some ranges of the sheet.

Coordinator
Apr 5, 2011 at 4:26 AM

Well, I'm not going to give you false hopes, chances of implementing #1 are next to zero. The reason is that it depends on how the Excel application renders the files. Here I'm just saving information to files which will be interpreted and rendered by Excel. For example, at no point do I need to know how to render a cell with a bold text. I just save a file saying "there's a cell and it's going to be bold".

As for PowerPoint, I have very little exposure to OpenXML outside spreadsheets but I'm sure the guys at Microsoft forums will be happy to help you (http://social.msdn.microsoft.com/Forums/en-US/oxmlsdk/threads)

-Manuel