Re: C# EPPlus resize pictures to fit in the cell - C# Discussion Boards

C# EPPlus resize pictures to fit in the cell

5-Sep-21 14:21

There are some open-source WinForm gauge/meter controls available, as well as commercial controls.

CodeProject is your friend: [^], [^], [^], [^].

For WPF: [^]

«The mind is not a vessel to be filled but a fire to be kindled» Plutarch

Mou_kol3-Sep-21 23:40

3-Sep-21 23:40

I am trying to place a picture into B1 cell. picture is getting inserted but height is getting bigger than original image. how automatically height is getting stretched?

I am using EPPlus version 4.0.6.0 & .Net version 4.5.2. using VS IDE 2013.

Here is the output screenshot link. please have a look https://i.stack.imgur.com/acavj.png[^]

Here is desired output screenshot link please have a look.
https://i.stack.imgur.com/In3jl.png[^]

here is the code sample which i used to place picture into B1 cell.

imgCompanyLogo = Image.FromFile(@"C:\Users\tridip\Desktop\Test1\www_files\image002.png");
ws.Column(2).Width = Convert.ToDouble((45 + 0.11));
ws.Row(1).Height = Convert.ToDouble((46.5 + 0.11));
ExcelPicture pic = ws.Drawings.AddPicture("Logo", imgCompanyLogo);
pic.SetPosition(0, 0, 1, 0);
pic.SetSize(316, 60);

if i commented or not commented this line

pic.SetPosition(0, 0, 1, 0);

but always getting same output where picture is getting stretched.

see the original image how it looks like. link here https://ibb.co/PCxw3v0

please tell me what is mistake in my code. please suggest a fix by which i can get my desired output.
Thanks

Richard MacCutchan4-Sep-21 1:04

Richard MacCutchan

4-Sep-21 1:04

You need to maintain the aspect ratio of the picture by keeping the height to width the same when you resize it. See How do I get the barcode images to scale properly?[^].

Mou_kol4-Sep-21 2:10

4-Sep-21 2:10

why do i need to set the aspect ratio. my image size is fine. when i manually insert that image into B1 cell from excel then it looks fine. so i assume i do not have to set any size for my image. when i insert that image into cell using EPPlus then height getting bigger but reason is not clear to me.

please give me more suggestion to deal this situation. thanks

Richard Andrew x644-Sep-21 2:17

Richard Andrew x64

4-Sep-21 2:17

When you insert the image directly from Excel, Excel is retaining the aspect ratio of the image.

When you're resizing the image, you are NOT retaining the aspect ratio because your resize code is not correct.

The difficult we do right away...
...the impossible takes slightly longer.

BillWoodruff4-Sep-21 2:07

4-Sep-21 2:07

You are asking the same question on the support forum for EPPlus on StackOverFlow: why are you asking it here ?

«The mind is not a vessel to be filled but a fire to be kindled» Plutarch

Mou_kol4-Sep-21 2:11

4-Sep-21 2:11

I post there but no one answer it. thanks

BillWoodruff4-Sep-21 2:13

4-Sep-21 2:13

You did get responses, there.

«The mind is not a vessel to be filled but a fire to be kindled» Plutarch

Mou_kol4-Sep-21 2:29

Having an issue accessing a bitmap region from two different threads.

4-Sep-21 2:29

here is my post in SO for the same issue but still no reply.

image - C# EPPlus resize pictures to fit in the cell - Stack Overflow[^]

Herboren2-Sep-21 17:43

Herboren

2-Sep-21 17:43

I can't for the life of me figure out how to access the region from a tick thread which is calling a bgworker().

Here is the original code

private void t_processFrame_Tick(object sender, EventArgs e)
{
    if (!_bw_frameProcessor.IsBusy)
    {
        _bw_frameProcessor.RunWorkerAsync();
    }
}

private void _bw_frameProcessor_DoWork(object sender, DoWorkEventArgs e)
{
    try
    {
        GetImage = new Bitmap(screen.Bounds.Width, screen.Bounds.Height);
        g = Graphics.FromImage(GetImage);
        g.CopyFromScreen(screen.Bounds.X, 0, 0, 0, GetImage.Size);

        pbDesktopFeed.Image = (Bitmap)GetImage;                           
        motionDetector.ProcessFrame((Bitmap)pbDesktopFeed.Image);
    }
    catch (Exception ex) { }
}

Its kind of frustrating because I have been sitting here for 3 days (I have a high tolerance of trying different variations before I burn myself out) trying to figure out why it works fine in Timer_Tick but not when Timer) Tick is running the Backgroundworker. My guess is that it is because of the Threads between the both.

I have tried cloning the bitmap inside the background worker

GetImage = new Bitmap(screen.Bounds.Width, screen.Bounds.Height);
Bitmap clone = (Bitmap) GetImage.Clone()
g = Graphics.FromImage(clone);
g.CopyFromScreen(screen.Bounds.X, 0, 0, 0, clone.Size);
pbDesktopFeed.Image = (Bitmap)GetImage;
motionDetector.ProcessFrame((Bitmap)pbDesktopFeed.Image);

I have tried cloning the image using AForge:

GetImage = new Bitmap(screen.Bounds.Width, screen.Bounds.Height);
g = Graphics.FromImage(GetImage );
g.CopyFromScreen(screen.Bounds.X, 0, 0, 0, GetImage .Size);
pbDesktopFeed.Image = (Bitmap)GetImage;
motionDetector.ProcessFrame(AForge.Imaging.Image.Clone((Bitmap)pbDesktopFeed.Image));

This however, works fine when I drop it all into the Timer_Tick event.

private void t_processFrame_Tick(object sender, EventArgs e)
{
    try
    {
        GetImage = new Bitmap(screen.Bounds.Width, screen.Bounds.Height);
        g = Graphics.FromImage(GetImage);
        g.CopyFromScreen(screen.Bounds.X, 0, 0, 0, GetImage.Size);

        pbDesktopFeed.Image = (Bitmap)GetImage;
        motionDetector.ProcessFrame((Bitmap)pbDesktopFeed.Image);
    }
    catch (Exception ex) { }
}

Re: Having an issue accessing a bitmap region from two different threads.

OriginalGriff2-Sep-21 20:12

OriginalGriff

2-Sep-21 20:12

It's probably pretty simple: only code that is running on the main (UI) thread can access any control in any way: since you moved it to a BackgroundWorker it isn't running on that thread any more, so when you try to access the Image or similar it's failing with an exception. Start by adding a try...catch block with Debug.WriteLine statements to check that and consider either Invoking the relevant controls or moving the Control related code back to the UI thread via the Progress reporting mechanism of the BackgroundWorker.

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Re: Having an issue accessing a bitmap region from two different threads.

Herboren4-Sep-21 5:11

Herboren

4-Sep-21 5:11

Turns out it was as simple as creating a public void PreviewImageUpdate() outside of the bg worker

private void t_processFrame_Tick(object sender, EventArgs e) {
  // UpdateMotionDetectionPreviiw();
  if (!_bw_frameProcessor.IsBusy) {
    _bw_frameProcessor.RunWorkerAsync();
  }
}

private void _bw_frameProcessor_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) {
  _bw_frameProcessor.Dispose();
}

private void _bw_frameProcessor_DoWork(object sender, DoWorkEventArgs e) {
  UpdateMotionDetectionPreview();
}

public void UpdateMotionDetectionPreview() {
  try {
    GetImage = new Bitmap(screen.Bounds.Width, screen.Bounds.Height);
    g = Graphics.FromImage(GetImage);
    g.CopyFromScreen(screen.Bounds.X, 0, 0, 0, GetImage.Size);

    if (motionDetector.ProcessFrame(GetImage) > 1.02 f)
      pbDesktopFeed.Image = GetImage;
    else
      pbDesktopFeed.Image = GetImage;
  } catch (Exception ex) {}
}

However, I do plan to take consideration in using a ScreenCaptureScreen() to relay this image to AForge video player to improve the over performance of the framerate since the PB update is too slow.

Windows Service

DoxMan30-Aug-21 6:37

DoxMan

30-Aug-21 6:37

I have a C# solution with multiple projects in it:
- Project 1 = A Windows Service project (with an app.config file containing general settings, to be used by ALL projects; this project will be the "main" startup project of the solution)
- Project 2 = A class library containing classes and functions that will handle execution of business logic (and do some logging in the EventViewer)
Upon startup, the Windows Service should read contents of its app.config [THIS WORKS!!!]
- Project 3 = A WinForm Test application that I temporarily use to test the business logic execution and logging.
Ultimate goal is to "remove" Project 3 and have the Windows service handle the business logic/logging.
In the app.config, I enter the settings that will be used by both project 1 and 2. Is there a simple way to "share" the config settings across all projects in the entire solution (upon startup of the service)?
I can create a GeneralConfig class, and add some properties, but how can I make this object (with the current properties) common to all projects. Is there something like a "single-instance" object.

Dox Girl, where are you?

Re: Windows Service

Dave Kreskowiak30-Aug-21 7:41

Dave Kreskowiak

30-Aug-21 7:41

Take a look at TopShelf[^] and you won't need the separate Test application project.

It's a console "wrapper" around your service, allowing you to run the app either as a console application or as a service, in a single executable.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

Re: Windows Service

mverbeke31-Aug-21 3:40

mverbeke

31-Aug-21 3:40

A very simple way to eliminate Project 3 while debugging is to alter the Main function in the Program.cs file.

An example is:
private static void Main(string[] args)
{
if (!Environment.UserInteractive)
{
ServiceBase[] ServicesToRun;
ServicesToRun = new ServiceBase[]
{
new ControlLoop()
};
ServiceBase.Run(ServicesToRun);
}
else
{
// Establish the foreground run...
MainThread objMainThread = new MainThread(false);
MainThread.Run(objMainThread);
}
}

In this case, MainThread is the name of your top level service class that contains your Run function. This is generally called from the ControlLoop.Onstart event...

using Rect, Vertex, Point in windowsbase.dll: better performance compared to the usual ?

BillWoodruff25-Aug-21 15:34

C# and Excel don't work in a computer without Visual Studio

25-Aug-21 15:34

I have been studying, and experimenting (in WinForms), with the newer structures (.NET 5.0) Vector, Rect, and Point in System.Windows (requires WindowsBase.dll). They offer some useful extended functionality compared to the Point/PointF and Rectangle/RectangleF structures in System.Drawing. They're Double based, so they will play nicely with the result of Math operators like Sin, Cos, Pow.

I intend to rewrite the 2d geometry library I am developing using those structures, and, when ready, publish it here; if you have used these structures, how have you found memory use and performance ?

thanks !

«The mind is not a vessel to be filled but a fire to be kindled» Plutarch

Ismael Oliveira 202124-Aug-21 12:57

Re: C# and Excel don't work in a computer without Visual Studio

24-Aug-21 12:57

Hello.
I have a forms application in C# and Visual Studio. Tis app interacts with Excel and is workin fine.
I installed the executable and the configuration file in another computer and whe the app calls excel I received a message stating that a library was not registered. The error message says that it's not possible to convert a COM object type 'System.___ComObjet' into the interface 'Microsoft.Office.Interop.ExcelApplication'.
Does anyone know what to do to correct it? Which DLL should be copied too?to correct it? Which DLL should be copied too?

RedDk24-Aug-21 13:56

RedDk

24-Aug-21 13:56

Perhaps you're suggesting that in order to run your app on a computer that does not have VS installed, copy the C:\Program Files\Microsoft Visual Studio #.0 (your version)\VC\redist content to that computer. Just a thought. If the app runs then ytou can start worrying about whether this is legal or not.

Lookup MSVCR and where to download it from Microsoft. That should do it.

[EDIT POST 16pt hit]
You mention a library ... what library?
[/EDIT]

modified 26-Aug-21 12:16pm.

Re: C# and Excel don't work in a computer without Visual Studio

Richard MacCutchan24-Aug-21 21:43

Richard MacCutchan

24-Aug-21 21:43

It means that the system does not have the Interop.Excel libraries installed. As far as I am aware you can only get these by installing a legal version of Excel on the system.

Re: C# and Excel don't work in a computer without Visual Studio

Ismael Oliveira 202125-Aug-21 12:20

Re: C# and Excel don't work in a computer without Visual Studio

25-Aug-21 12:20

Hi, Richard. The excel is legal. So, what should I do? Which files should I copy?

Richard MacCutchan25-Aug-21 21:58

Richard MacCutchan

25-Aug-21 21:58

The interop libraries should be installed automatically with Excel. On my system I have the following:

Microsoft.Office.Core: C:\WINDOWS\assembly\GAC_MSIL\Office\15.0.0.0__71e9bce111e9429c\Office.dll
Microsoft.Office.Interop.Excel: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.Office.Interop.Excel\15.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Excel.dll

The versions on your system may be different, but the dll files should still be there.

It would also appear that Microsoft make them available for download at Download Microsoft Office 2010: Primary Interop Assemblies Redistributable from Official Microsoft Download Center[^].

Re: C# and Excel don't work in a computer without Visual Studio

Ismael Oliveira 202126-Aug-21 4:03

Re: C# and Excel don't work in a computer without Visual Studio

26-Aug-21 4:03

Richard.
Ok, I found these files in my computer. Now I will see if they are in the other computer.
Thanks.

Ismael Oliveira 202126-Aug-21 4:51