Python code to unprotect the excel sheet with a valid password

import msoffcrypto
import pathlib
# pip install msoffcrypto-tool'

url = pathlib.Path(r'D:\Source')
excel_files = list(url.glob('*.xlsx'))
def unlock(filename, passwd, output_folder):
    temp = open(filename, 'rb')
    excel = msoffcrypto.OfficeFile(temp)
    excel.load_key(passwd)
    out_path = pathlib.Path(output_folder)
    if not out_path.exists():
        out_path.mkdir()

    with open(str(out_path/filename.name), 'wb') as f:
        excel.decrypt(f)
    temp.close()
for i in excel_files:
    unlock(i, 'Password', r'D:\Destination')



------------------------------

# Replace "C:\Your\Directory\Path" with the actual path to the directory you want to search in.
$directoryPath = "D:\Testing"
# Replace "2023-06-30" with the date you want to check in "YYYY-MM-DD" format.
$targetDate = "2023-06-30"

# Get all the *.txt files in the specified directory that match the target date.
$matchingFiles = Get-ChildItem -Path $directoryPath -Filter "*.txt" | Where-Object { $_.LastWriteTime.Date -eq (Get-Date $targetDate).Date }

# Display the count of matching files.
Write-Host "Number of *.txt files for $targetDate $($matchingFiles.Count)"


Comments

Post a Comment

Popular posts from this blog

host

DECLARE @InsertStatement NVARCHAR(MAX); SELECT @InsertStatement =      'INSERT INTO SalesEmployees (Id, Name, Age) ' +     'SELECT ' +     STRING_AGG('''' + CAST(Id AS NVARCHAR(MAX)) + '''', ', ') +     ' FROM Employees WHERE Department = ''Sales'';' FROM Employees WHERE Department = 'Sales'; PRINT @InsertStatement;
Read more

Steps to create SSH key from git bash

Generating an SSH key in OpenSSH involves a few simple steps. Here’s how you can do it: 1. Open a Terminal If you're on Linux or macOS, you can use the built-in terminal. On Windows, you can use the Command Prompt, PowerShell, or Git Bash if you have Git installed. 2. Generate the SSH Key Pair Run the following command: bash Copy code ssh-keygen -t rsa -b 4096 -C "your_email@example.com" Here’s what each option means: -t rsa : Specifies the type of key to create, in this case, RSA. -b 4096 : Specifies the number of bits in the key, 4096 bits is a good choice for strong encryption. -C "your_email@example.com" : Adds a label to the key, usually your email address. 3. Choose a File Location After running the above command, you'll be prompted to choose a location to save the key. By default, it will be saved in ~/.ssh/id_rsa (on Linux or macOS) or in C:\Users\YourUserName\.ssh\id_rsa (on Windows). Press Enter to accept the default location, or specify a diff...
Read more

test

.. https://ubiquis.co.uk/loading-csv-files-with-pdi-metadata-injection-2/ -- Create a temporary table to demonstrate the solution CREATE TABLE YourTable ( ID INT, YourColumn VARCHAR(100) ); -- Insert sample data INSERT INTO YourTable (ID, YourColumn) VALUES (1, '1234_4567_abc'), (2, '789_012_def'), (3, 'xyz'); -- Declare variables for storing results DECLARE @firstPart VARCHAR(100), @secondPart VARCHAR(100); -- Iterate over rows in the table DECLARE @currentID INT = 1; DECLARE @rowCount INT = (SELECT COUNT(*) FROM YourTable); WHILE @currentID <= @rowCount BEGIN -- Retrieve input string from the table DECLARE @inputString VARCHAR(100); SELECT @inputString = YourColumn FROM YourTable WHERE ID = @currentID; -- Check if the delimiter exists in the input string IF CHARINDEX('_', @inputString) > 0 BEGIN -- Find the position of the first occurrence of the delimiter in the input string DECLARE @delimiter...
Read more