Đang Thực Hiện

Develop a scheduler to generate an Excel file and send file to another server

I am looking for a C# and SQL Server developer, which can design and develop an automatic process to schedule a weakly process to do the following steps:

Write a select query to fetch data and generate the output in an Excel file. ( will provide the query criteria to fetch data)

Save the file in a specific directory.

Call an API to send the Excel file from the windows server to the target server. (This API has been developed, just needs to be called and pass the right parameters. (will provide the information in a later stage)

A scheduler to do the above task on a specific date and time on a weekly basis. i.e, once a week at a specific date and time which needs to be configurable (the date and time, the file name and the path of the file).

Log activities, i.e, keep the history of the process (number of records generated, time and date of the file has been generated and sent.

The data resides in a SQL server DB, there are only 3 to 4 tables to generate the data from them. There are around 1000 records to be generated in the Excel file.

The generated Excel file needs to be sent to another server using a developed and ready API. There is only a need to call the API and pass the parameter with the right information to send the generated Excel file from server A to server B.

The post API is developed and it is working. Just need to be called and pass the correct parameter to the API.

Kĩ năng: Lập trình C#, Kiến trúc phần mềm, .NET, Microsoft SQL Server, Windows Server

Xem nhiều hơn: excel send file vba outlook, generate excel chart csv file, excel send email existing file, excel send file outlook, send text file server client tcp socket programming, net generate excel file pivot, client server send xml file java, generate excel file multiple worksheets jsp, java mobile application send data file server, send csv file form excel database, send xml file server delphi, send zip file client server wcf, vba excel send file, vb excel send file email, we are looking for experienced developer to develop android application with below features user login by email fb twitter gtalk, we are looking for experienced developer to develop android application with below features: user login (by email fb twitter gta, I need an android developer to develop a learning app for school children, how to generate excel from xml file, how to send text file from client to server in c#

Về Bên Thuê:
( 1 Nhận xét ) Salisbury, United Kingdom

ID dự án: #32222713

Được trao cho:


Hi, I’m a UK based expert in databases and c# applications with many years of experience. I can help you to extract the data from SQL server and to generate excel file. Im looking forward to work with you. Regards, Kam

£75 GBP trong 7 ngày
(2 Đánh Giá)

38 freelancer chào giá trung bình£181 cho công việc này

(411 Nhận xét)

Hi, I am C# developer and work with visual studio 2022 and dotnet6. After reading your requirements, I think we can do it for you in a simple web page. You most have some fixed queries with specified columns and some v Thêm

£200 GBP trong 7 ngày
(177 Nhận xét)

Hi, What about developing it as a command line tool which outputs the excel file to a certain directory and send it to the API and also output the log to a file. This way you can run it using windows scheduler at anyti Thêm

£250 GBP trong 4 ngày
(203 Nhận xét)
(1572 Nhận xét)

Hi Sir, I am skilled in SQL server, Excel and C#. I can automate all these tasks on the click of a button and get them scheduled on weekly/daily basis. Please invite for discussion and share more details. Thank you, Thêm

£200 GBP trong 3 ngày
(49 Nhận xét)
(78 Nhận xét)
(68 Nhận xét)

⭐⭐⭐⭐⭐ Hi there, I am java-python-C# developer with 7+ years of experience in web and desktop app and game development. I have strong expertise in front end, back end and database. I just read the details and looks an Thêm

£220 GBP trong 3 ngày
(65 Nhận xét)

Hello, I read the description of your project and I can develop the project with the details that you mention. Read Sql server tables, generate excel send it via api (already developed by the client) to a remote server Thêm

£60 GBP trong 4 ngày
(94 Nhận xét)

Hello sir, Im python expert, and software developer, i created many complex softwares before, i can make this software and provides code + executable, Dealing with apis and excels is something i do almost in every pro Thêm

£200 GBP trong 3 ngày
(21 Nhận xét)
(100 Nhận xét)
(20 Nhận xét)

Hi, I am interested in your offer as a developer with 10 years of experience. I wanna do my best for you with my experience and diligent efforts. For a cheap price, you'll get more than you want in a short period of Thêm

£200 GBP trong 7 ngày
(7 Nhận xét)
(27 Nhận xét)
(13 Nhận xét)

*Hello..., My Availability: 40+ hours/week. Ready to start work immediately. I read your requirement of #.NET and SQL server Developer to Write a select query to fetch data and generate the output in an Excel file. I Thêm

£200 GBP trong 7 ngày
(11 Nhận xét)

Hello Haydar, I have + 10 years of experience in programming development, in partiuclar, I am very familiar with C# and dot net. Until now I have completed lots of projects successfully, also I have always installed VC Thêm

£400 GBP trong 3 ngày
(1 Nhận xét)

Ready to develop the required software tool to schedule and perform the tasks you described Regards,

£200 GBP trong 5 ngày
(1 Nhận xét)

Hello! Ready to help you with your project. Let's discuss details in the chat. I am experienced C# developer, so don't worry about quality and timing.

£60 GBP trong 3 ngày
(13 Nhận xét)

Hello there! C# would be great to use to program a standard windows service, but... why not do it in python? The scheduling might be done both as a config txt file or just by programming the script to run as a windows Thêm

£175 GBP trong 7 ngày
(2 Nhận xét)