
Change coloumns in excel sheets
4626
£100(approx. $134)
- Posted:
- Proposals: 18
- Remote
- #342291
- Archived
ASP.Net, C#, ASP, PHP, AngularJs, EF, LINQ, HTML, Javascript, VBScript, SQL server, Oracle, JQuery
Experienced Software Professional - Web and Application Development - PHP, Microsoft Dot Net and Database Technologies
524549304132534715128912438948474770212966878225350064874635708550666
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
To Create a system where I can import an excel file with a range of column headers in row 1 and then export the same file and data with the column headers in a different order.
For example in the address we currently have Address line 1 postcode, unique ID and we want uniquieID, Address 1, address 2, address 3 and then postcode.
The excel files will need to be exported in .xlsx
EG: I have a file with the headers A, B,C,D,E and I want to import that and export it in the order C,F,D,A,C,E,Z,X,Y . Where the row 1 headers are not in the sheet to begging with the header is placed and the row data is blank.
All the data is in sheet 1 and the file name must be changeable in this conversion process.
There is more work on similar projects if this is done well and we are looking at getting this done quickly.
We have about 50 excel sheets and they have a fair number of initial column orders.
The headers of the output files and input files are changing and that is why I need a system of being able to match up one with the other, There is no unified Schema.
For example in the address we currently have Address line 1 postcode, unique ID and we want uniquieID, Address 1, address 2, address 3 and then postcode.
The excel files will need to be exported in .xlsx
EG: I have a file with the headers A, B,C,D,E and I want to import that and export it in the order C,F,D,A,C,E,Z,X,Y . Where the row 1 headers are not in the sheet to begging with the header is placed and the row data is blank.
All the data is in sheet 1 and the file name must be changeable in this conversion process.
There is more work on similar projects if this is done well and we are looking at getting this done quickly.
We have about 50 excel sheets and they have a fair number of initial column orders.
The headers of the output files and input files are changing and that is why I need a system of being able to match up one with the other, There is no unified Schema.
Thomas B.
100% (9)Projects Completed
22
Freelancers worked with
19
Projects awarded
37%
Last project
16 Oct 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies