Text SQL table data to populate in excel, then read back to prepare xml
€30-250 EUR
Đã hoàn thành
Đã đăng vào hơn 6 năm trước
€30-250 EUR
Thanh toán khi bàn giao
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.
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 trong 22 ngày
4,8 (6 nhận xét)
3,0
3,0
14 freelancer chào giá trung bình €165 EUR cho công việc này
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 in Ms Excel/VB.
Really all my projects here I've developed for Ms Access/Excel/VB
projects.
I'll do your current project very professionally and on time.
Here is my introduction:
I’m a ms Access/Excel/VB programmer, a mathematician and a full time
developer with a strong background developing a wide range of accounting,
economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO,
SQL , including projects for start-up companies and small businesses.
For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for
coding and guarantee that all of developing is 100% original.
I highly value professionalism and hold myself strictly accountable to represent my client’s
brand.
I aim to form a long-term working relationship.
Please, let me know what is needed to secure this bid!
Thank you for your consideration.
Zura
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 SEO ,SMM, web design & web development .i give all of clients unlimited revision for projects. Please choose for project cause I'm great for this.