In Progress

Text SQL table data to populate in excel, then read back to prepare xml

I need someone to do this project for me.

Data will be available as sql table, excel, text or csv, comma delimited files Total count of columns are less than 10, so very easy to handle data tables.

System will read the data, filter it as required, open a pre-designed excel sheet, start populating the data as per the filter in rows and columns. Excel sheet will have several named ranges, and same type of data may have multiple occurrences based on the currency and country data. Named range for currency and country to be added dynamically in the excel sheets.

Once the provided data is populated in the excel sheets, excel will calculate it in multiple columns in each row and and there will be sub grouping of total on rows.

All formulas will be provided in excel (=formula) format.

After the data is populated and verified by the user, a button will read data including all source rows , calculated rows, by keeping all attributes into a text, csv or sql table and save it.

The saved data then will prepare xml files in a special but very simple format.

A small web page which initially will run from the localhost. Later, on I will book a domain to use it. It must be developed using ASP.Net, SQL and Excel (all latest versions).

As later on I will be including in my existing project, I will require complete source code with explanation notes.

All above work is being done manually, so actually it is automation of the process. There are almost 20 different sheet format but source data table is 98% the same.

Once this is done, then we can go for other automation tasks.

If you have ASP.Net and Excel knowledge, it is for you. Give your price and we can further discuss it on this weekend.

All sample data and process will be provided after discussion.

Skills: ASP.NET, Data Processing, Excel, Visual Basic, XML

See more: sync excel data sql table, table data bootstrap mvc read, sync sql table data excel, update excel data sql table, data table data analysis excel, read data table pdf file excel macro, vbscript read data source excel pivot table, simple vbscript display table data sql server, vbnet read sql table xml, acces table data populate html table, import text file sql table, import excel sql table, adonet sql large data excel export, read data website excel, php sorting data sql table

About the Employer:
( 1 review ) Brussels, Belgium

Project ID: #15857693

Awarded to:

RaghavendravDesh

Hello, As spoken to you I have created 3 milestones. I will ensure the good quality of work and I work with desired efficiency. Thanks for considering me.

€150 EUR in 22 days
(5 Reviews)
2.2

17 freelancers are bidding on average €173 for this job

€155 EUR in 3 days
(1 Review)
5.3
zu02

p.s. I think Ms access app will be best fit here. I've coded several similar projects with Access/Exce/xml automations. Hi, there I hope all's well with you. I see you'r looking for a developer proficient More

€250 EUR in 5 days
(27 Reviews)
5.6
bestit4u

Hello sir. I 've read your post and so very interested in your job. I 'm working in part of coding and software developing for over 6 years. I have much experiences in developing software and programming. http://ww More

€166 EUR in 3 days
(10 Reviews)
4.5
€155 EUR in 3 days
(2 Reviews)
2.7
€155 EUR in 3 days
(1 Review)
0.8
vashist246

Hello, i have understood your task i would like to connect with you on weekend kindly connect with me and drop me a message i have an expertise in Software Development specializing in Asp.Net with c# programming a More

€155 EUR in 3 days
(0 Reviews)
0.0
MouStudio

Sir, I'm Mou .I've got experience of SEO,SMM,website design & development .I read about your project I've experience about your project .If you got any doubt please take my interview. I've got many year experience More

€111 EUR in 10 days
(0 Reviews)
0.0
€222 EUR in 3 days
(0 Reviews)
0.0
€155 EUR in 3 days
(0 Reviews)
0.0
yongyong2014

I just read your post very carefully and I think that I'm a suitable person for you. Because I'm an expert in SQL Server / .net technologies, and have developed and published over 20 wonderful websites and Web servi More

€222 EUR in 3 days
(0 Reviews)
0.0
omarpac2

A proposal has not yet been provided

€155 EUR in 3 days
(0 Reviews)
0.0
omprakashpaliwal

A proposal has not yet been provided

€111 EUR in 2 days
(0 Reviews)
0.0
€277 EUR in 10 days
(0 Reviews)
0.0
sanjai1985

A proposal has not yet been provided

€111 EUR in 2 days
(0 Reviews)
0.0
fahadzaheervw

A proposal has not yet been provided

€194 EUR in 10 days
(0 Reviews)
0.0
€205 EUR in 3 days
(0 Reviews)
0.0