How can I export data from Excel to png?

Question

I have a set of Excel spreadsheets with multiple tabs which contains each one table that I need to export as pictures in an automated process (I have dozens of such files to process).

While I could "manually" select the table, copy and paste them as image in another software, I need to industrialize this process to save time.

What would be the best approach using .Net or any builtin Excel feature?

Thanks

duplicate of http://stackoverflow.com/questions/1287879/programmatically-c-convert-excel-to-an-image — General Grey, Jun 14 '12 at 13:19

score 1 · Accepted Answer · edited May 23 '17 at 12:03

1

Check this question. Programmatically (C#) convert Excel to an image

It looks like they're doing what you need?

edited May 23 '17 at 12:03

Community

1
1

answered Jun 14 '12 at 11:14

NeilD

2,278
3
24
28

score 0 · Answer 2 · answered Jun 14 '12 at 13:07

Think I would use a small C# apop to do it - that assumes that you have a one off task and don't want to mess about with Excel templates or global excel macros and opening each spreadsheets etc.

I would do it like this:

dump all my excel docs in a single folder.
open up each doc in the folder in C# app
iterate each tab
If data capture data for all used ranges (from A1 to the whatever the bottom right cell is) - for any embedded charts pull them off as well
If chart pull it off
dump each to the folder as an image prefixed with the excel doc name and some iterative suffix like _chat01 _data01

How to rwead it ina and convert to image? See here => http://csharp.net-informations.com/excel/csharp-excel-chart-picturebox.htm

score 0 · Answer 3 · answered Oct 27 '15 at 02:11

0

Copy all desired cells
Open MS-Paint
Paste
Save as PNG.

answered Oct 27 '15 at 02:11

Sayeed S. Alam

445
2
6

How can I export data from Excel to png?

3 Answers3