PowerShell Excel Parsing Script

$30-250 USD

Opravljeno

Objavljeno

pred več kot 5 leti

$30-250 USD

Plačilo ob dostavi

Need a PowerShell script that can parse a library of commonly formatted spreadsheets and extract the data into a series of pipe delimited files. I will provide a sample spreadsheet and indicate which sections need to be extracted in which files. Col A of Every CSV Row written must be the xls file name ('Sample Freelancer [login to view URL]' in the example provided). All green values are csv column names (fields) and the grey cells are their corresponding values. Ignore 'Dropdown Lists' tab. Every time the PS Script is run, it should append to the existing csv files specified. PS Script will need to read a folder that has numerous xls files (with this same format ) that need to be parsed. The following files will need to be updated from each xls that is processed by the PS script. [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL]

Excel

Powershell

ID projekta: 18523919

Več o projektu

20 ponudb

Projekt na daljavo

Aktivno pred 5 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@markelof

Hello, I have a question, can it be written in C# as a custom software with friendly user interface instead of Powershell script? If yes then I can create such a tool for you.

$155 USD v 3 dneh

5,0

(23 ocen)

4,6

20 freelancerjev je oddalo ponudbo s povprečno vrednostjo $149 USD za to delo

@schoudhary1553

Hello, I have gone through your job PowerShell Excel Parsing Script and i am sure i can deliver you the quality job. Please see my profile i have deliver almost 430 projects with 100% client satisfaction. I have the good knowledge of Excel, Powershell. Please ping me for further discussion.

$180 USD v 3 dneh

4,9

(299 ocen)

7,8

@zekovicm

Hi there,I am scripting expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

$200 USD v 2 dneh

4,9

(98 ocen)

7,0

@vlayausa

Hello, I have a lot of experience with PowerShell and this script sounds like something I could do. I would love to help you with it. I really believe I could finish it very quick. Please contact me for more information.

$108 USD v 3 dneh

4,9

(130 ocen)

5,8

@lightingdavid

Hello. Nice to meet you. I have read your project description carefully and i can make PS script for this. I have some questions following: 1. Do you want to make PS script to parse all excel files in folder? 2. In a Folder, there are only excel files?(no Folder) 3. All excel files have same green color and grey color? I hope to contact with you. Thanks.

$140 USD v 3 dneh

4,8

(73 ocen)

5,6

@lkhelladi

Hello, I'd be glad to develop the excel parsing tool for you. Looking forward to chat with you soon for more details. Best regards,

$77 USD v 0 dnevu

5,0

(7 ocen)

4,5

@dany3j

Hi there! Dear colleague. I can help you with this Powershell project. I would like to know more about it. Contact me by Chat to get more information. My Best Regards

$100 USD v 5 dneh

4,9

(10 ocen)

3,8

@DebasisB

HI there, I am interested in the project. I can provide the script exactly as per your requirement. Thank you.

$155 USD v 2 dneh

5,0

(4 ocen)

3,4

@AhmadSameer

Hey there I'm a System Engineer with coding skills. I had developed tons of scripts using Powershell. I'm downloading the attached file to check. I can help. Regards.

$155 USD v 3 dneh

5,0

(7 ocen)

3,5

@goodwork20k

I am good in powershell and perl along with devops, i used to work with data conversion project and id did similar projects Please let me know if you are good to award this project to me

$211 USD v 7 dneh

4,9

(6 ocen)

3,4

@kostiapl

How are you? I am interested in your project and would like to work on it. Can start without any prepayments to show my skills. I am planning to use COM OLE to work with Excel files and add some additional features like logging to simplify debugging if it will be needed. Feel free to ask any questions.

$88 USD v 3 dneh

5,0

(5 ocen)

2,5

@AdrianCJ

this looks pretty straightforward. As an admin I am pulling monthly xsl&csv reports all with powershell. I also done *.csv data manipulation on this website so please hyave a look and make a decision!

$130 USD v 3 dneh

5,0

(5 ocen)

2,3

@MaxFinley

I am a freelance writer who is well-versed in the English language. Whether its grammar, punctuation or sentence construction I have worked hard to get myself up to native level proficiency. I am very dedicated to my profession and find myself contented with what I do. I love to work with new people and try to nurture pleasant long-term relationships which mutually benefit us. I can assure you that I time and prioritize myself well hence I will definitely not miss any deadlines. I will treat the project as mine and will deliver the best quality I can deliver in the given time. Expecting to hear from you, thanks!

$111 USD v 3 dneh

0,0

(0 ocen)

0,0

@cbuky

Am a computer scientist,a Microsoft certified professional with Microsoft Dynamic CRM , very fluent and proficient with Microsoft Office suite and Office 365

$240 USD v 3 dneh

0,0

(0 ocen)

0,0

@DataSoolutions

Hi There...Having quite an experience in powershell, I am very much confident enough to finish the task within 2 days at a reasonable price. Please do ping me to discuss further. Thanks and Regards, DataSoolutions

$60 USD v 2 dneh

0,0

(0 ocen)

0,0

@SajidYousuf

A dynamic and diversified individual with results driven approach with over 7 years of proven leadership experience and 14+ Years of extensive International & Local working experience in reputed IT / Business Oriented Organizations. Change agent & Problem-solver with a passion for transformation, technology, conceptualization, developing and implementing solutions and having vast business domain exposure.

$222 USD v 5 dneh

0,0

(0 ocen)

0,0

@DevStar925

Zastava LAO PEOPLE'S DEMOCRATIC REPUBLIC

Hi, Dear Employer! I am really interested in your project. I have enough experience in PowerShell, Python, C/C++, C#, java programming. I am 100% sure I can satisfy your requirements perfectly. Clear Algorithm Will Encourage Your Project. I want a long-term relationship with you. Thank you and best regards!

$200 USD v 3 dneh

0,0

(0 ocen)

2,0

@prj102

I will work with you to completely understand your requirements and will work to create a powershell script that will pull the required data from files from a directory and export the data required in a csv format. Requirements -Sample files for testing -Script would need to be run on a system with excel installed Thank you for the opportunity and look forward to working together if selected.

$138 USD v 3 dneh