blocks|key|517316|text|当你将示例39作为像素传递时，它会在内部将它作为像素实例的点，所以你认为你要将row的高度设置为39像素，但实际上它将row的高度设置为39点。所以根据下面的公式，你的行高将变成52像素。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|517317|如果你想将行的高度设置为39px，意味着你必须通过29.25点(根据公式)的39。|517318|points+=+pixels+*+72+/+96|code-block|syntax|javascript|517319|试试这个吧。|517320|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

when you are passing say example 39 as pixel it will take it as point insted of pixel internally, so you think that you are going to set row's height to 39 pixel but actually it is setting row's height to 39 point. so according to following formula your row height will became 52 pixel.

If you want to set row's height to 39px, mean you have to pass 29.25 Point(according to formula) insted of 39.

<pre><code>points = pixels * 72 / 96
</code></pre>

Try this one.

blocks|key|300383|text|尝尝这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|300384|Image+logo+=+Image.FromFile(path);
ExcelPackage+package+=+new+ExcelPackage(info);
var+ws+=+package.Workbook.Worksheets.Add("Test+Page");
for(int+a+=+0;+a+<+5;+a%2B%2B)
{
++++ws.Row(a*5).Height+=+39.00D;
++++var+picture+=+ws.Drawings.AddPicture(a.ToString(),+logo);
++++//+xlMove+disables+the+auto+resizing
++++picture.Placement+=+xlMove;+//XLPlacement+:+xlMoveAndSize,xlMove,xlFreeFloating
++++picture.SetPosition(a*5,+0,+2,+0);
}|code-block|syntax|javascript|300385|或|300386|Image+logo+=+Image.FromFile(path);
ExcelPackage+package+=+new+ExcelPackage(info);
var+ws+=+package.Workbook.Worksheets.Add("Test+Page");
for(int+a+=+0;+a+<+5;+a%2B%2B)
{
++++ws.Row(a*5).Height+=+39.00D;
++++var+picture+=+ws.Drawings.AddPicture(a.ToString(),+logo);
++++picture.From.Column+=+0;
++++picture.From.Row+=+a;
++++picture.SetSize(120,+150);
}|300387|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

try this

<pre><code>Image logo = Image.FromFile(path);
ExcelPackage package = new ExcelPackage(info);
var ws = package.Workbook.Worksheets.Add("Test Page");
for(int a = 0; a &lt; 5; a++)
{
 ws.Row(a*5).Height = 39.00D;
 var picture = ws.Drawings.AddPicture(a.ToString(), logo);
 // xlMove disables the auto resizing
 picture.Placement = xlMove; //XLPlacement : xlMoveAndSize,xlMove,xlFreeFloating
 picture.SetPosition(a*5, 0, 2, 0);
}
</code></pre>

or

<pre><code>Image logo = Image.FromFile(path);
ExcelPackage package = new ExcelPackage(info);
var ws = package.Workbook.Worksheets.Add("Test Page");
for(int a = 0; a &lt; 5; a++)
{
 ws.Row(a*5).Height = 39.00D;
 var picture = ws.Drawings.AddPicture(a.ToString(), logo);
 picture.From.Column = 0;
 picture.From.Row = a;
 picture.SetSize(120, 150);
}
</code></pre>

blocks|key|517442|text|我不确定这是不是最好的解决方案，但绝对是你的问题的变通办法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|517443|下面是我所做的：|517444|ExcelPackage+package+=+new+ExcelPackage();
var+ws+=+package.Workbook.Worksheets.Add("Test+Page");

for+(int+a+=+0;+a+<+5;+a%2B%2B)
{
++++ws.Row(a+*+5).Height+=+39.00D;
}

for+(int+a+=+0;+a+<+5;+a%2B%2B)
{
++++var+picture+=+ws.Drawings.AddPicture(a.ToString(),+logo);
++++picture.SetPosition(a+*+5,+0,+2,+0);
}|code-block|syntax|javascript|517445|这是它看起来的样子。|517446|​|517447|📷|atomic|offset|length|517448|517449|由于某些原因，当我们设置行高时，它会干扰图片高度。|517450|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/1706e1db0e005c91cf2ee0ddcd8ccd76.png|imageAlt^0|0|0|0|0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|15|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|16|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|17|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|18|8|@]|9|@$P|19|Q|1A|1|1B]]|A|$]]|$1|R|3|L|5|6|7|1C|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1D|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11|12|-4]]]]

I'm not sure if this is the best solution but definetly a workaround for your problem.

Here's what I did: 

<pre><code>ExcelPackage package = new ExcelPackage();
var ws = package.Workbook.Worksheets.Add("Test Page");

for (int a = 0; a &lt; 5; a++)
{
 ws.Row(a * 5).Height = 39.00D;
}

for (int a = 0; a &lt; 5; a++)
{
 var picture = ws.Drawings.AddPicture(a.ToString(), logo);
 picture.SetPosition(a * 5, 0, 2, 0);
}
</code></pre>

Here is how it looks.

<img src="https://i.stack.imgur.com/iC92B.png" alt="enter image description here">

For some reason when we have the row height set, its interfering with the picture height.

blocks|key|517483|text|在保存文档之前添加以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|517484|foreach+(ExcelPicture+drawing+in+ws.Drawings)
+++drawing.SetSize(100);|code-block|syntax|javascript|517485|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Add the following right before you save the document:

<pre><code>foreach (ExcelPicture drawing in ws.Drawings)
 drawing.SetSize(100);
</code></pre>

blocks|key|300610|text|使用以下代码调整excel单元格中的图像：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|300611|++++++++Image+logo+=+Image.FromFile(path);
++++++++ExcelPackage+package+=+new+ExcelPackage(info);
++++++++var+ws+=+package.Workbook.Worksheets.Add("Test+Page");
++++++++for(int+a+=+0;+a+<+5;+a%2B%2B)
++++++++{
+++++++++++ws.Row(a*5).Height+=+39.00D;
+++++++++++var+picture+=+ws.Drawings.AddPicture(a.ToString(),+logo);
+++++++++++picture.From.Column+=+0;
+++++++++++picture.From.Row+=+a;
+++++++++++picture.To.Column=0;//end+cell+value
+++++++++++picture.To.Row=a;//end+cell+value
+++++++++++picture.SetSize(120,+150);
++++++++}|code-block|syntax|javascript|300612|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

use the below code to adjust the image in an excel cell:

<pre><code> Image logo = Image.FromFile(path);
 ExcelPackage package = new ExcelPackage(info);
 var ws = package.Workbook.Worksheets.Add("Test Page");
 for(int a = 0; a &lt; 5; a++)
 {
 ws.Row(a*5).Height = 39.00D;
 var picture = ws.Drawings.AddPicture(a.ToString(), logo);
 picture.From.Column = 0;
 picture.From.Row = a;
 picture.To.Column=0;//end cell value
 picture.To.Row=a;//end cell value
 picture.SetSize(120, 150);
 }
</code></pre>

blocks|key|517631|text|这是一种可以在C#中应用的解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|517632|private+void+AddImage(ExcelWorksheet+oSheet,+int+rowIndex,+int+colIndex,+string+imagePath)
{
++++Bitmap+image+=+new+Bitmap(imagePath);
++++ExcelPicture+excelImage+=+null;
++++if+(image+!=+null)
++++{
++++++++excelImage+=+oSheet.Drawings.AddPicture("Debopam+Pal",+image);
++++++++excelImage.From.Column+=+colIndex;
++++++++excelImage.From.Row+=+rowIndex;
++++++++excelImage.SetSize(100,+100);
++++++++//+2x2+px+space+for+better+alignment
++++++++excelImage.From.ColumnOff+=+Pixel2MTU(2);
++++++++excelImage.From.RowOff+=+Pixel2MTU(2);
++++}
}

public+int+Pixel2MTU(int+pixels)
{
++++int+mtus+=+pixels+*+9525;
++++return+mtus;
}|code-block|syntax|javascript|517633|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This is one solution that you can apply in C#. 

<pre><code>private void AddImage(ExcelWorksheet oSheet, int rowIndex, int colIndex, string imagePath)
{
 Bitmap image = new Bitmap(imagePath);
 ExcelPicture excelImage = null;
 if (image != null)
 {
 excelImage = oSheet.Drawings.AddPicture("Debopam Pal", image);
 excelImage.From.Column = colIndex;
 excelImage.From.Row = rowIndex;
 excelImage.SetSize(100, 100);
 // 2x2 px space for better alignment
 excelImage.From.ColumnOff = Pixel2MTU(2);
 excelImage.From.RowOff = Pixel2MTU(2);
 }
}

public int Pixel2MTU(int pixels)
{
 int mtus = pixels * 9525;
 return mtus;
}
</code></pre>

I am trying to add the same image multiple times into an excel file using EPPlus. I am using the following code to do so:

<pre><code>Image logo = Image.FromFile(path);
ExcelPackage package = new ExcelPackage(info);
var ws = package.Workbook.Worksheets.Add("Test Page");
for(int a = 0; a &lt; 5; a++)
{
 ws.Row(a*5).Height = 39.00D;
 var picture = ws.Drawings.AddPicture(a.ToString(), logo);
 picture.SetPosition(a*5, 0, 2, 0);
}
</code></pre>

Everything works perfectly and all the images are correctly added but they are stretched downwards. Here is what one of the pictures should look like:

<img src="https://i.imgur.com/UHCh9.png" alt="enter image description here">

But it looks like this in excel:

<img src="https://i.stack.imgur.com/NsFd8.png" alt="enter image description here">

I have to resize each row of the start of each picture but I dont think that would be affecting it. Would there be a way to add the pictures/do what I am trying to do or would I have to copy-paste the images in manually? (I am using the picture as an example)

Thanks.

Adding images into Excel using EPPlus

我正在尝试使用EPPlus多次将同一图像添加到excel文件中。我使用以下代码来完成此操作：Image logo = Image.FromFile(path);ExcelPackage package = new ExcelPackage(info);var ws = package.Workbook.Workshee...

问使用EPPlus将图像添加到Excel中
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用EPPlus将图像添加到Excel中EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用EPPlus将图像添加到Excel中
EN