How Do I Insert Jpg Image From File Stream

Question

0.00/5 (No votes)

See more:

C#

var sd = new ExcelLibrary.SpreadSheet.Picture();

sd.Image = ExcelLibrary.SpreadSheet.Image.FromFile("c:\\images\\a.jpg");
ws.AddPicture(sd);

is not working, it gives unsupported format error.

how do i do it from file and byte[]??

Posted 4-Jul-14 6:37am

scorpzonex

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 4-Jul-14 13:28pm

What is ws?

scorpzonex 4-Jul-14 15:05pm

worksheet
ExcelLibrary.SpreadSheet.Worksheet

ridoy 4-Jul-14 15:50pm

Do you check it? http://www.codeproject.com/Questions/84487/How-to-insert-a-picture-image-in-XML-spreadsheet

scorpzonex 4-Jul-14 18:06pm

for.png works but .jpg fails and how to it from a memorystream (variable)?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sankarsan parida · Accepted Answer · 2014-07-06T07:10:00

Do code
Code to Export to Excel using ExcelLite.

WriteableBitmap bitmap = new WriteableBitmap(640,300);
 
//pass the chart control to convert it into Bitmap
 bitmap.Render(chart1, null);
 bitmap.Invalidate();
 
// open file dialog for selecting export file
 SaveFileDialog sDialog = new SaveFileDialog();
 sDialog.Filter = "Excel Files(*.xls)|*.xls";
 
if (sDialog.ShowDialog() == true)
 {
 // create a workbook object
 Workbook workbook = new Workbook();
 //Create a worksheet object
 Worksheet worksheet1 = new Worksheet("SheetWithImage");
 
// creat a spreadsheet picture object
 Lite.ExcelLibrary.SpreadSheet.Picture pic = new Lite.ExcelLibrary.SpreadSheet.Picture();
 //set its image property from silverlight image control
 // image formates 0xF01E=png,0xF01D=jpeg
 //ImageTranslator.TranslateImageToBytes translate an image control to byte array
 // that will be used by excel picture object to plot picture in excel file.
 System.Windows.Controls.Image image = new System.Windows.Controls.Image();
 image.Source = bitmap;
 image.Name = "imgExport";
 image.Width = 640;
 image.Height = 300;
 image.Stretch = Stretch.Fill;
 pic.Image = new Lite.ExcelLibrary.SpreadSheet.Image(ImageTranslator.TranslateImageToBytes(image), 0xF01E);
 
 //set picture size
 pic.TopLeftCorner = new CellAnchor(1, 1, 10, 10);
 pic.BottomRightCorner = new CellAnchor(8, 5, 10, 10);
 // add picture to spreadsheet
 worksheet1.AddPicture(pic);
 /// add worksheet to workbook
 workbook.Worksheets.Add(worksheet1);
 // get the stream of selected file
 Stream sFile = sDialog.OpenFile();
 // save excel file
 workbook.Save(sFile);
 }