Batch file to convert xlsx to csv and remove '0' entries on Windows Server

Completed Posted Jun 18, 2015 Paid on delivery
Completed Paid on delivery

I have a an xlsx file which updates dynamically on the server based on other excel sheets. I need to copy the values from the xlsx sheet and create a new CSV file from the entries, then at the end of the xlsx sheet there are entries which are '0'. These need to be removed and not copied into the csv file.

I need this program to execute every hour in order to update the csv file to the latest information once per hour. The CSV must be overwritten every time the program executes so that the csv file is always the latest update.

Excel Windows Server

Project ID: #7886826

About the project

11 proposals Remote project Active Jun 19, 2015

Awarded to:

Fenixs

Hi, I can create simple console application useable on Windows (.exe file) for loading excel file every hour and exporting .CSV file with proper format. It's hard to tell something more without samples what excatly More

£33 GBP in 2 days
(9 Reviews)
3.7

11 freelancers are bidding on average £96 for this job

mrbrave

HI..I have a questions....Will it be ok, if you copy file from the server and then run macro on your local computer? or you want to run macro get data with file remained on server?... Also please send me sample of file More

£55 GBP in 1 day
(144 Reviews)
6.0
muzammil21

Hello sir you will only pay here when get done 100% work ,NO advanced or upfront payment please reply for chat Thanks

£100 GBP in 1 day
(17 Reviews)
5.0
jbyuna158

Good day! I would like to express my interest on your job post. I am proficient in using Microsoft Office Application specially in Using Microsoft Excel and Microsoft Word. I am an experienced person in terms of Dat More

£150 GBP in 3 days
(0 Reviews)
0.0
wismy

A proposal has not yet been provided

£150 GBP in 1 day
(0 Reviews)
0.0
njeripat

I am 20 years old. I type fast and I am a fast learner. I can deliver within 2 days. Please consider my request. Thankyou

£150 GBP in 3 days
(0 Reviews)
0.0
ATCInfo

Fully dedicated to client project with a keen eye for detail, Time conscious in meeting the demand of the client, Conscious in safeguarding the privacy of the contents in the documents. We handle and trust and accuracy More

£150 GBP in 3 days
(0 Reviews)
0.0
aikenesc

Hi! I am proficient in MS Excel and I know about CSV and XLSX. I can help you with the job and will provide you the accurate update every hour. I have more than 5years working as an Office Staff which work evolves in M More

£150 GBP in 3 days
(0 Reviews)
0.0
bobycom

Hello, I have rich experience with AutoHotKey scripts and tasks automation. I can do what you need by creating an AHK script. It can be compiled as an .exe file and can be run with parameters. Also I can make it trigg More

£55 GBP in 1 day
(0 Reviews)
0.0