Excel to CSV Conversion with PowerShell Automation
Budget: $30 – $250 USD
I need a Macro script to automate the process of comparing two Excel spreadsheets and generating a CSV file. The script will also dump this CSV into our ERP system (EPICOR) using the DMT tool.
Requirements:
- Compare the two spreadsheets cell-by-cell.
- Highlight mismatches.
- Include all columns in the resulting CSV file.
Ideal Skills and Experience:
- Proficiency in PowerShell
- Experience with Excel and CSV manipulation
- Familiarity with EPICOR and DMT tool (Plus)
- Attention to detail and accuracy
Requirements:
- Compare the two spreadsheets cell-by-cell.
- Highlight mismatches.
- Include all columns in the resulting CSV file.
Ideal Skills and Experience:
- Proficiency in PowerShell
- Experience with Excel and CSV manipulation
- Familiarity with EPICOR and DMT tool (Plus)
- Attention to detail and accuracy
Related categories:
Visual Basic
Data Processing
Excel
ERP
Powershell
Scripting
Data Analysis
Data Integration
Automation
Data Management