parsování dat z CSV do XLS - v Powershellu

@MMG2019

Hi Vladimír , I can develop a customized tool (standalone app for desktop) ore Excel vba for reading this kind of CSV file with different headers. I am a programmer skilled in Visual Basic, MS ACCESS, MS EXCEL and VBA. Providing many ideas and suggestions IF NEEDED. Best regards, Michael

@TheSecondSource

Hey! As a seasoned specialist in full-stack development and data processing, I can help you with parsing data from CSV to XLSX using PowerShell. Here's how I can help: - Create a PowerShell script that parses the CSV data, processes the headers, and organizes the data into individual sheets in an XLSX file. - Ensure that each sheet is named according to the first string in the header row, following the structure you’ve outlined. - Format the data in each sheet according to the type (numbers, dates, etc.), including proper column widths and graphical adjustments. - Provide a single, non-compiled PowerShell script that can be run to complete the task automatically. With over 12 years of experience as a full-stack developer and expertise in data processing, I can ensure this is done efficiently and accurately. You can check my profile and portfolio here: [https://www.freelancer.com/u/TheSecondSource](https://www.freelancer.com/u/TheSecondSource), where you'll find confidence in my work. Questions to clarify: - Could you confirm the exact structure of the CSV and how the headers are divided? - Are there any specific formatting requirements for the Excel file aside from column widths and graphical adjustments? - Is there a preferred method for handling sensitive data? I am ready to provide the most satisfying result, let's discuss further in chat.

@wasikeonesmus980

I am excited to assist you in creating a PowerShell script to parse your CSV data into a well-structured XLSX file. With expertise in data processing, PowerShell, and Excel automation, I will deliver a script that accurately extracts headers and data, dynamically creates sheets, and formats content (numbers, dates, widths, etc.) professionally. The script will be precise, efficient, and meet your confidentiality requirements. I’ll ensure the XLSX output matches your specifications and provide clear documentation for ease of use. I’m available 24/7 for consultations and will deliver within the agreed timeline. Looking forward to working with you!