ImportExcel | PowerShell module to import/export Excel spreadsheets, without Excel | Command Line Interface library

I have a requirement to select the first X rows for each unique agent ID. My method below works, but it runs into performance issues when the spreadsheet has over about 5k results to consider. I am hopeful that you very smart people can help me optimise the approach to require less processing.

I am using ImportExcel to import the spreadsheet of call records, then I filter out uninteresting rows and I'm left with $UsableCalls as my pool of calls to be evaluated. Sometimes, this pool has only 2k rows. Sometimes it has 16k. It's possible that it might have even more. Unfortunately, it seems like the max this method can support is around 5k-ish results. Anything over that and the process hangs. So if I have 5k rows, then I can really only handle getting the first 1 call per agent. If I have 2k, then I can get the first 2 calls per agent. The number of calls per agent is selectable, and I'd like to have the option to get up to the first 5 calls per agent, but that simply won't work with the way it processes right now.

Ultimately, the goal is to select the first X# calls (rows) for each agent. I then export that as a second spreadsheet. This is the only method I could come up with, but I am certainly open to suggestion.

Here is what I have, how can I improve it?

I have a pipeline I've used to get info taken from an excel spreadsheet for other device models, but for this device model, the value is hex, and hex is unusual, in that 0x10 = 0x00010, so I need to compare those values in the pipeline.

This is my pipeline I've used for non-hex values after the spreadsheet content is returned:

I have a CSV that has 3 pieces of information (Name, Metric, Metric Data) for each server

I'm trying to add an image to an excel worksheet with powershell 5. and VSCode.

I get these errors:

C:\CC_SnapViews\EndToEnd_view\path is correct\file.bmp does not exist (but it's there)

Multiple ambiguous overloads found for "AddPicture" and the argument count: "2"

When I search the internet, this error isn't coming up in the search. I was following these examples:

addPicture

addPicture github

This is my code:

I'm using FromFile to get the image out of files, and it has the following error for the png's on the FromFile line:

Exception calling "FromFile" with "1" argument(s): "The given path's format is not supported."

So, I'm trying to convert the bmp's to jpg, (see convert line above FromFile below) but all the examples I see (that seem usable) are saving the file. I don't want to save the file in the dir. All I need is the image format, so FromFile can use it like this example. I saw ConvertTo-Jpeg, but I don't think this is a standard powershell module, or don't see how to install it.

I saw this link, but I don't think that would leave the image in the format needed by FromFile.

This is my code:

i have a class

i'm using maatwebsite laravel excel to import some data from excel to database. But i want to add some custom ID with incremental value for each row of data. For now, i'm able to import data with some input value form together.

DataImport file

how to make my program can follow resolution my screen, or any idea to make my program make better. I guess my bootstrap is problem because program display is not fit screen, I hope it can fit on my screen.

and here is my index.blade.php

I was doing good other page, but for this have problem and I was tried and still not find.

ImportTransaksi_Controller