Automation for cont. screen movementtimer with mouse movements Certainly! Below is the complete VBA code in a single module that will move the mouse every 10 seconds using Windows API functions, along with the other Excel tasks (like updating a cell). Full VBA Code (One Module) Open E...3 min read·patelnildip.hashnode.devDec 24, 2024
read excels and write in one excelThere is a faulty channel file, so not quite an update. There is a work around. 1. Boot Windows into Safe Mode or WRE, 2. Go to C:\Windows\System32\drivers\CrowdStrike 3. Locate and delete file matching "C-00000291*.sys" 4. Boot normally Test code im...5 min read·patelnildip.hashnode.devMay 31, 2024
Transformation valuestest import java.io.BufferedReader; import java.io.BufferedWriter; import java.io.File; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.nio.file.Files; import java.nio.file.Paths; import java.util.HashMap...3 min read·patelnildip.hashnode.devMay 22, 2024
find the values from CSV filestest test import org.apache.commons.csv.CSVFormat; import org.apache.commons.csv.CSVParser; import org.apache.commons.csv.CSVRecord; import java.io.FileReader; import java.io.IOException; import java.io.Reader; public class CSVHeaderFinder { p...2 min read·patelnildip.hashnode.devApr 19, 2024
read excel file using python panda libimport pandas as pd import os def read_excel_files(directory): # Initialize an empty list to store data frames dfs = [] # Loop through all files in the directory for filename in os.listdir(directory): if filename.endswith("....1 min read·patelnildip.hashnode.devApr 5, 2024