Retrieve values from a .xml file into Excel (or google Spreadsheets)

€8-30 EUR

Terminado

Publicado

hace casi 7 años

€8-30 EUR

Pagado a la entrega

I have an export of a file. I want to extract a limited number of values in Excel. So basically I just want the data between the "" and after the = . Example: There is this line in the xml file: name="Cuvdfdelier" In Excel I want just this word in a cell: Cuvdfdelier Offcourse each xml file will have different data between the "" but the structure will remain the same. In attachment the xml file and an xlsx file with the data on the right place. From the first line in the xml file I want to have: 1. name 2. street 3. postalcode 4. town <ns2:project xmlns:ns2="urn:peb:bcca" name="Cuvdfdelier" applicationVersion="8.0.4" energyPerformanceFileNumber="33040-G-2014_0101" requestDateVL="2016-09-01T00:00:00.000+02:00" street="Klerkenstraat" postalCode="8920" town="Langemark-Poelkapelle" referenceCadastral="1-c-341f" subdivsionName="" lotNumber="" hasSharedVentilators="false"> Then from each ventilation zone I want: 1. name <ventilationZone name="vz4" pebIdentifer="6" fullUnsetAttributesCount="0"> Under each ventilation zone I want: 1. valueLabel <VENTILATION_TYPE valueAttribute="VENTILATION_DOUBLE" valueLabel="D - Mechanische toevoer, mechanische afvoer" 2. HAS_ON_DEMAND_VENTILATION <parameter name="HAS_ON_DEMAND_VENTILATION" valueAttribute="false" 3. annualResult valueAttribute= --> I want the number 417 <calculation name="HYGIENIC_VENTILATION_SUPPLY_NEW" unit="m³/h" label="Totaal debiet verse lucht"><annualResult valueAttribute="417,00"/> 4. annualResult valueAttribute= --> I want the number 233.33 <calculation name="HYGIENIC_VENTILATION_EXTRACT_MIN" unit="m³/h" label="Afvoer min."><annualResult valueAttribute="233,33"/> Then I want also each room (in this file there are about 10 rooms): 5. space name <space name="Berging (wasplaats)" pebIdentifer="18" fullUnsetAttributesCount="0"> After each space name I want the surface: 6. valueAttribute= --> I want the number 16,20 <parameter name="USAGE_SURFACE" valueAttribute="16,20" After each space name I also want the folowing six parameters: 7a. annualResult valueAttribute after HYGIENIC_VENTILATION_SUPPLY_MIN_SPACE --> I want the number 0,00 7b. annualResult valueAttribute after HYGIENIC_VENTILATION_SUPPLY_SPACE --> I want the number 0,00 7c. annualResult valueAttribute after HYGIENIC_VENTILATION_SUPPLY_MAX_SPACE --> I want the number 0,00 7d. annualResult valueAttribute after HYGIENIC_VENTILATION_TRANSFER_MIN_SPACE--> I want the number 25,00 7e. annualResult valueAttribute after HYGIENIC_VENTILATION_TRANSFER_SPACE--> I want the number 25,20 7f. annualResult valueAttribute after HYGIENIC_VENTILATION_EXTRACT_MIN_SPACE--> I want the number 58,33 7g. annualResult valueAttribute after HYGIENIC_VENTILATION_EXTRACT_SPACE--> I want the number 59

Visual Basic for Apps

ID del proyecto: 14637401

Información sobre el proyecto

33 propuestas

Proyecto remoto

Activo hace 7 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@liviuconcioiu

Hello, I'm ready to export the values from XML to XLS. I'm available right now. Let's talk over chat. Thank you, Liviu P.S.: I DO NOT subcontract projects like many other freelancers here do.

€15 EUR en 1 día

5,0

(29 comentarios)

4,4

33 freelancers están ofertando un promedio de €31 EUR por este trabajo

@schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply ============

€70 EUR en 1 día

4,9

(410 comentarios)

8,2

@KulfiSoftwares

ZERO ERROR GUARANTEED!! Please read my 230+ reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied with the work until you are. Please read some of my customer reviews then contact me immediately. Thanks.

€33 EUR en 0 día

4,9

(308 comentarios)

7,6

@hatemfreelance4

“Budget and project period are flexible to meet to your requirement” I’m an Electrical Engineer. I am very interested in Web search and data input task and also i have a good experience in this field. I am responsible and hardworking person. I want to spend my time, 40hrs per week working as a freelancer. My goal here is to serve and share my talents to others providing customer satisfaction. My field of expertise includes: Electrical Engineering Leads generation Data Entry Data Processing Web Searching Web Scarping Transcription (Arabic, French and English) Data Mining Database Uploading Product Uploading (wordpress, prestashop, magento …) Excel , Word, PowerPoint, Ms office tools … video & image Processing English-French-Arabic translation and creative writing. *Thank You*

€14 EUR en 0 día

5,0

(134 comentarios)

6,8

@younus15

Hello. I have extensive experience in Excel, Convert Xml to Excel and Data processing.I can do your project in less than 2 Days according to your description with full delivery and without error. I would also complete your project with the highest precision and quality.

€39 EUR en 2 días

4,9

(145 comentarios)

6,3

@sourabhg98

Hello, Greetings for the day! This is Sourabh Gupta from New Delhi, India. I am an advanced Excel VBA programmer currently at the post of Forum Expert at www.excelforum.com. I read the description of your project and would like to offer my services for the same. The macro will be fully automated. It will first ask you to select the file, then it will automatically process and give you all the details as mentioned for each ventilator. I haven't read each parameter yet, but the requirements seem pretty clear! Looking forward to a positive response from your side :) Best Sourabh

€34 EUR en 1 día

5,0

(148 comentarios)

6,1

@dgapscom

Dear Employer, I am Faisal professional SEO friendly web designer & developer. Please come in private chat to discuss more in detail about your project and I am ready to start your project right now. I have 6+ years of experience with more than 800 successful projects. I would give you multiple revisions and you will love my high Quality work. We can discuss the budget

€53 EUR en 1 día

5,0

(9 comentarios)

6,1

@vano101

Hello, there are few questions: what is target OS? What is preferred programming language? Thanks.

€16 EUR en 2 días

4,9

(133 comentarios)

5,7

@SidhuDN

I can read your job carefully and I can do Data Entry work professionally.I will do very easy to work this one and I can follow instructions really well. So you can expect me to the job exactly as you want me to do. My profile "New come in this marketplace but Top rated seller in Fiverr" Guaranteed: I will 100 % satisfy my service. Please order to create our new business relationship. I wait for your reply. Please reply me then we discuss more details of this project. Hope you response me soon. Thank you Sidhudeb

€23 EUR en 1 día

4,9

(16 comentarios)

5,3

@dghq123

Hi there.. I have read your project details completely and willing to do it for you... Check my recent reviews for our quality work on on time delivery Please inbox and we can discuss about project...

€150 EUR en 3 días

4,9

(20 comentarios)

5,4

@rakshitdadhich

Greetings! I am an expert in Microsoft excel/ Data entry. I would love to have the opportunity to discuss your project with you. I feel I am best fit to complete your project. I have 10 years of experience of particular field. I have recently complete similar project. Thank you for your time and consideration Ram Dadhich

€23 EUR en 1 día

5,0

(19 comentarios)

5,0

@testotorko

Hi, I read carefully your project, and I wanna do it for you. If you wanna work together, send me a message to discuss details. I am an experienced Web Developer and Web Designer, and have worked with wide variety of skills like PHP, MySQl, jQuery / Prototype, Javascript, HTML, CSS and more for many years. I also have worked over many Wordpress projects. Have good communication skills and great responsibility.

€20 EUR en 2 días

5,0

(41 comentarios)

4,9

@muradeltaher

I like to work on your project Your welcome to have a look at my profile Most of my employers are satisfied with my work Because of my English and always communicating with them My regards Murad Eltaher

€20 EUR en 2 días

4,6

(70 comentarios)

5,0

@furqanahmed55

Hello, I graduated from Boston University USA. I have a lot of experience with excel. I never miss work and always deliver on time. My personal qualities are: - Detail Oriented, as handled many sensitive contracts in past. - Trustworthy and honest team player - Very Fast Learner. Thank you Best Regards

€100 EUR en 1 día

4,5

(8 comentarios)

5,0

@abbalove

Hey, I can create the scripts for you. I am experienced with things like this. Rocky .

€24 EUR en 1 día

5,0

(14 comentarios)

4,5

@naseefo

Hi there! I can quickly executive this work right away! I have experience in MS Excel and use of VBA to extract xml files. Please click "Chat" to discuss in detail.

€14 EUR en 0 día

5,0

(6 comentarios)

3,4

@kmkhsujon

Dear Client, I love excel works. According to your job description, you need a fast worker for your project.I would be an ideal worker to accomplish your requirements.I can assure you that I will be able to submit your task on time with quality work. I am able to start right now.I am waiting to be hired on this project to show my skills. Thank you in advance for your time and consideration. Regards Kamal

€29 EUR en 1 día

4,9

(18 comentarios)

3,6

@mehulvariya7

Hello Sir, I fully understood what you want. you want specific data from xml. I am a Fresher in freelancer but i have a more then 3 years of experience in excel and data-entry. i am a best for your project because i know all functionality in excel like VBA macro, shorting, filter, pivot table, chart, formatting etc. also i know all functions like V-lookup, H-lookup or other string, mathematical functions etc... and i will done your within your time period. with best quality. i have already worked for client for data-entry, inventory,product uploading on overstock, ebay, 11main, shopify, houzz etc.. I assure you that you will be happy and satisfied with my work. If you want to have a confidentiality agreement signed first, please send them to me , I can signed NDA also. I am available for communication on Skype, Gtalk and on freelancer. My [Removed for encouraging offsite communication which is against our Terms and Conditions.] i am available more then 12 hours per day. If you have any question then please let me know. Thanks for considering my application for this project. Kind Regards,

€19 EUR en 1 día

5,0

(14 comentarios)

3,4

@satyajeetkeshari

Hello , Warm Greetings If looking for a good experienced web developer, then your are on right place. Development is my skill & passion. I am having more that 9 years experienced in web development of corporate websites and web applications with in IT companies. I have worked on wide range of websites using PHP mysql, wordpress, joomla, magento HTML, CSS, jQuery, SEO, JavaScript, Bootstrap, and PSD to HTML. I have done more that 30 projects on freelancer ... I believe in job completion and customers satisfaction Thanks & Regards! satyajeet kesharia

€9 EUR en 1 día

4,8

(21 comentarios)

3,6

@DataScraperNirod

Sir, I am a data entry expert. I need job. I have read your proposal and I think its very easy for me. If you choose me, then I will give you my best effort. Thanks Nirod Biswas

€21 EUR en 1 día