1

I trimmed out quite a bit so if there is context missing sorry, I'll edit.

I'm not getting any errors and the Picture does seems to get added to the workbook object...

I've also tried just inserting into a new cell(), but when I get to saving to the stream it get an Invalid Cell value.

I'm using this link as a reference: https://excellibrary.googlecode.com/svn-history/r51/trunk/src/ExcelLibrary.WinForm/Form1.cs

Workbook wBook = new Workbook();
Worksheet wSheet = new Worksheet();
//getting my file
var path = context.Server.MapPath("~/data/default/content/logo.bmp");
pic.Image = ExcelLibrary.SpreadSheet.Image.FromFile(path);
pic.TopLeftCorner = new CellAnchor(5, 1, 0, 0);
pic.BottomRightCorner = new CellAnchor(7, 5, 592, 243);

wSheet.AddPicture(pic);
wSheet.Cells[rows, 0] = new Cell("some text");
wBook.Worksheets.Add(wSheet);

context.Response.AddHeader("Content-Disposition","Attachment;Filename=PlattShoppingCart.xls");
context.Response.ContentType = "application/vnd.ms-excel";
MemoryStream stream = new MemoryStream();
wBook.SaveToStream(stream);
context.Response.BinaryWrite(stream.ToArray());
user1040975
  • 420
  • 5
  • 16

2 Answers2

1

This question and answer uses Microsoft.Interop Excel, but it accomplishes the same task. Probably not the answer you need, but I got it to work just fine. Of course, I was already using the interop stuff, just needed to modify the code a little to get it work.

I wonder if you forgot to add the ExcelLibrary equivalent of 

pic.Placement = // Can be any of Excel.XlPlacement.XYZ value
Community
  • 1
  • 1
Owen Ivory
  • 244
  • 1
  • 9
  • still giving you a point since it was seeing that the different methods were using different file types that inspired me try what ended up working. – user1040975 Oct 01 '15 at 16:29
0

I don't know if it was just me or it's actually not anywhere in the documentation, but *.bmp, *.jpeg, *.gif', are not supported and it worked by simply turning it into a .png....

Thanks for the link though as it was an experience to compare it to other methods. Here are some other links if you find yourself getting this far and you still have issues:

http://www.codeproject.com/Questions/793324/How-Do-I-Insert-Jpg-Image-From-File-Stream

http://www.codeproject.com/Questions/84487/How-to-insert-a-picture-image-in-XML-spreadsheet

How Do I Create a System.Windows.Media.ImageSource From a Byte Array?

Community
  • 1
  • 1
user1040975
  • 420
  • 5
  • 16