PowerShell Script for excel/CSV file apply the filter on data


I have a data in excel file and which contain data(Columns) like user name, county, Date, Primary Clicked(True/False), Acknowledgement(T/P) Reported (T/P), Business Units, Upload date(Based on location wise), Template name.

Form this, we have to apply the filets based our requirement.

As of now i am doing filters manually and it takes around 2 hr to complete the process by applying filters manual.

I am looking some automation with the help of power shell script to read the data (around 10K rows) and provide the values.


Beceriler: Powershell, Excel

Daha fazlasını gör: script import csv file database, script modify csv file, php script upload csv file mysql, powershell script to read csv file and write output, powershell import-csv select row, powershell import-csv select column, powershell import-csv | where, powershell import-csv foreach, powershell script to read and write csv file, powershell sort csv by multiple columns, powershell output to csv columns, perl script insert csv file data mysql, start excel csv file, csv file specification inventory data, asp script insert csv file, bash script parse csv file, excel csv file format, read excel csv file plsql, java script reads csv file, script upload csv file server web http

İşveren Hakkında:
( 0 değerlendirme ) Kalamazoo, United States

Proje NO: #27861691



HI, i read ur description. I have done such kind of large data handling in past. We can go via this approach but it is advisable to use python for this. the solution will be clean and simple. I am fine with both the me Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 1050%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)

Bu iş için 9 freelancer ortalamada ₹1178 teklif veriyor


Hello, I am a powershell and csv expert and i can help you make script quickly Kindly ping me for further discussion Thanks

₹1500 INR in 7 gün içinde
(61 Değerlendirme)

Hi. I have written many automation PowerShell scripts also apps for formatting files including Excel, CSV. Can format any Excel, CSV templates. Ready to write your project. Will complete within 1 day

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(68 Değerlendirme)

Hi there, I can make a software /app to filter Excel /csv file data. Any non technical person can easily run this app by double click. I have some questions regarding project please let me know when are you avail Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(15 Değerlendirme)

Hi, I work doing automations with powershell. I would like to participate in your project. Send me to chat to share details Regards

₹1200 INR in 7 gün içinde
(7 Değerlendirme)

Hey, i am multitasking person, i am good on these fields (Excel, word,Data Entry, Software Development) and i do value of time. so, i do complete my work on time with better quality.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)

I understood the requirement of the assignment. i can convert the fields and data filterable format. The requirement is tailor made for me and would be comfortable in completing the job as per the requirement. Do sha Daha Fazla

₹1050 INR in 7 gün içinde
(0 Değerlendirme)

Hello I have several years of professional experience in PowerShell and have completed several projects that involve scripting tasks in Excel. I would be happy to assist with your project.

₹950 INR in 7 gün içinde
(0 Değerlendirme)

I've been a professional system engineer for the past 8 years and I'm using powershell daily, I can easily and quickly help you with this. What do you mean with filters? If there is x value in column b then something Daha Fazla

₹1500 INR in 2 gün içinde
(0 Değerlendirme)