NPNildip Patelinpatelnildip.hashnode.dev·Dec 24, 2024 · 3 min readAutomation 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...00
NPNildip Patelinpatelnildip.hashnode.dev·May 31, 2024 · 5 min readread 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...00
NPNildip Patelinpatelnildip.hashnode.dev·May 22, 2024 · 3 min readTransformation 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...00
NPNildip Patelinpatelnildip.hashnode.dev·Apr 19, 2024 · 2 min readfind 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...00
NPNildip Patelinpatelnildip.hashnode.dev·Apr 5, 2024 · 1 min readread 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("....00
