Export NSImage to Excel Sheet

Question

How can export an NSImage in excel Sheet?

When i try doing the below, The Microsoft Excel Application is unable to read the content.

NSBitmapImageRep *imageRep = [self.displayView bitmapImageRepForCachingDisplayInRect:[self.displayView bounds]];
[imageRep setSize:self.displayView.frame.size];
                [self.displayView cacheDisplayInRect:[self.displayView bounds] toBitmapImageRep:imageRep];
NSImage *image1 = [[NSImage alloc] initWithSize:NSMakeSize(imageRep.pixelsWide, imageRep.pixelsHigh)];
[image1 addRepresentation:imageRep]; 
[[image1 TIFFRepresentation]
 writeToFile:@"AbsolutePath/ExportImageTest.xlsx"atomically:YES];

Can any one Suggest me how can i export a view converted to NSImage in excel sheet?

A TIFF is not an Excel spreadsheet. Why do you believe writing a TIFF with an .xlsx will turn it into one? — Brad Larson, Oct 09 '14 at 14:49
Yep you are right Brad, But can you help me in getting this done using NSImage on excel sheet, Is there a way to do this? — Abdul Naveed, Oct 10 '14 at 09:36

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

1

When you call writeToFile:automatically: it saves tiff at that path, does not add it to xlsx. You need to know what is the xlsx format and then decide how to write the file into it.

This may help:

Creating Excel (.xlsx) files in Cocoa

edited May 23 '17 at 12:11

Community

1
1

answered Oct 09 '14 at 11:40

Krzysztof

1,441
11
22

The Link you shared shows up the way to put the tag where the actual image should be present out side the excel sheet. I want an actual image to be in excel sheet. – Abdul Naveed Oct 10 '14 at 09:38
can you use base64 in that img tag ? – Krzysztof Oct 10 '14 at 09:56

Export NSImage to Excel Sheet

1 Answers1