pds | 派单管理系统demo - 核心框架：Spring Boot | Security Framework library

I had similar question, that I posted over 1y ago, and it was basically solved but... Here is the link for more infos:

VBA CopySheetsFromClosedWorkbook but overwrite (update) existing sheets with new values

Recently I bumped on some issue where I am facing WBs with different Sheet names but with the same content. Every time I am having this issue I need to tweak a code a bit, to adjust it for right Sheet names. is there any function or additional array that I can include in the code so that it recognises if the Sheet1 had name XYZ and now ZYX to still proceed with code and get me the data?

In my case, also you can see in the code, it is only matter of two different names with numbering. Original Sheet name is "CH_or_Recipe_1 to 8", but sometimes I will have cases with "Chamber 1 to 8". I would like to have defined those Sheet names within my code so that I dont need to adjust it manually every time I wanna copy the data.

And last additional question or favor is, to export the exact WB but without .xlsm (without macro) in .xlsx with all the data. So Macro WB would be like an intermediar to gather the data and export them...

This is coding part:

I have a class to get the metrics of my connection pool:

There is a table I want to join with different columns in different tables.

This is how so far I did this

I have a table with about 18 million records. I have to read the whole table in one query because all of the records were created on one date. So, firstly I defined an index on four columns that I have a query on them using the below command:

I am trying to group an array of objects from a parentId that each element of the array brings, there can always be an indeterminate number of levels, the result I expect is the one I have in the output.

I have done the first level and it creates the first subgroup of chlds well, but I don't know how generate the following ones.

INPUT

I want to convert the following Pine script to python to calculate the value for vwap1 variable without plotting the results, I just want to calculate the value for vwap1:

Compile fails with this error. I have looked through all the posts with similar titles and not found anything helpful yet. Angular 7. I was trying to update some dependencies to resolve prod vulnerabilities, the change list for this was moving angular-devkit/build-angular to dev dependencies, removing abandoned and unused packages, adding ngx-toastr 10, upgrading jasmine-core from 3.3 to 3.8.

I have deleted, cleared cache, and reinstalled all node packages and then tried specifically doing that to angular/cli (7.1.1) and webpack (4.12.0). Edited+saved a random ts file. Added app/app.module.ts specifically to tsconfig.app.json's files param and include param. Added strictMetadataEmit:false to tsconfig.json and tsconfig.app.json compilerOptions (unknown compiler param error).

tsconfig.json

I need to load a huge table (6 gb) from an older postgres db that contains some bad values that I need to delete on load. So I wrote a loop that tries to load bigger chunks for performance reasons, but reduces step by step to isolate and discard the bad values. Generally this works, but after more or less 500 k records the performance decreases rapidly.

I have already found that it is not advisable to process larger datasets with pandas. That's why I tried to use numpy. But that didn't change anything. Then I tried to use list comprehensions, but failed because of the exceptions I have to use to try to iterate in smaller chunks.

From my point of view numpy vectorisation looks like a good idea, but I have no idea how to make it work.

https://towardsdatascience.com/how-to-make-your-pandas-loop-71-803-times-faster-805030df4f06

In general this part I'd like to speed up massivley.

I am trying to assert on an element to see if the checkbox is checked or not. Please find the image below:

Now, this is the dom structure to target this element: