C++ read and write Excel files - repost
€30-40 EUR
Paid on delivery
I need a program that will read a simple table from an excel file (only numbers).
The program should import this into a bidimensional array, do some simple calculations on it, then export this to another excel file that will look like the first file imported but with different values.
When exporting the bidimensional array to excel file, the program must check if values are above a known value and if they are higher it should mark the corresponding cells with red color.
The program doesn't need an interface, a console app is ok.
It must be coded in C++11 and it must be able to import/export XLS and XLSX files.
The program should be very simple and rock solid, that means MS Excel should never report any error when opening the file exported by the program.
I will provide 2 excel files, one will be imported by the program and the other one should be an example of what the program should export.
All you have to do is code this simple program and provide a working EXE file and the source file that will compile successfully in a program like Dev-C++ with MinGW compiler in order to be able to correct any bugs in the future.
Also this will be running on 32bit Windows machines (XP, Vista, 7, 8).
I say ROCK SOLID because the program needs to do very simple task, always the same task. It should be simple.
Just to clarify, it MUST be standard C++, NOT Visual C++, NO .net dependency, NO Visual Studio.
The program must be able to work even if Excel is not installed on the system (this is obvious)...
I'm attaching Excel example files.
If the program finds in its folder a file called Data.xls it will process it and create a new file Export.xls.
If it finds Data.xlsx it will export XLSX.
Processing consists of reading all cells and multiply every cell value by 0.023437
If resulting value is greater than 15 it will mark the cell with red color.
Data.xls or Data.xlsx will have more columns and rows than example files!
Project ID: #4341636
About the project
22 freelancers are bidding on average €51 for this job
I am very proficient in c, c++. I have 15 years c++ developing experience now, and I have worked for 5 years, please let expert help you.
Hi I am an expert in C++ and the C++11 standard. I can surely do this task for you. Send me example files please.
4years experience. ready to work. I'll complete your task as you said. Waiting your reply.
hi this is devtechsol and i am ready to start please have a look on the work i did Kind Regards Devtechsol
I'd like to do such a simple task as I used to do similar things dealing with various data files using C++.