Fermé

Create an Excel Tool which converts to XML, calls a website and returns specific values from XML string

I am looking for an excel tool where a user can input 10 values, it is converted to XML where it then calls an external website, the XML is pasted in a submitted, what is returned is a XML string which then is converted back in to Excel with highlight on specific values returned from the XML.

I have an example of this file that DOESN'T WORK. And I am looking for something which is simple, not so many inputs and outputs.

Very basic XML to be created.

<?xml version="1.0" encoding="UTF-8"?><INDATA version = "G"><SCENARIO_NAME>Basic Test Scenario</SCENARIO_NAME>

<INVOICE>

<CALCULATION_DIRECTION>F</CALCULATION_DIRECTION>

<COMPANY_ID>502</COMPANY_ID>

<COMPANY_NAME>Groupon-Deal Centre</COMPANY_NAME>

<COMPANY_ROLE>B</COMPANY_ROLE>

<CURRENCY_CODE>USD</CURRENCY_CODE>

<DOCUMENT_TYPE></DOCUMENT_TYPE>

<EXTERNAL_COMPANY_ID>1010</EXTERNAL_COMPANY_ID>

<INVOICE_DATE>2018-07-12</INVOICE_DATE>

<INVOICE_NUMBER>GGG Basic Test Scenario</INVOICE_NUMBER>

<IS_AUDITED>false</IS_AUDITED>

<IS_REPORTED>false</IS_REPORTED>

<IS_REVERSED>false</IS_REVERSED>

<POINT_OF_TITLE_TRANSFER>I</POINT_OF_TITLE_TRANSFER>

<SHIP_FROM>

<COUNTRY>GB</COUNTRY></SHIP_FROM>

<SHIP_TO>

<COUNTRY>GB</COUNTRY></SHIP_TO>

<TRANSACTION_TYPE>GS</TRANSACTION_TYPE>

<LINE ID="1">

<COMMODITY_CODE>9101.99.00</COMMODITY_CODE>

<GROSS_AMOUNT>1000</GROSS_AMOUNT>

<LINE_NUMBER>1</LINE_NUMBER>

<QUANTITIES><QUANTITY><AMOUNT>1</AMOUNT>

<UOM>each</UOM>

</QUANTITY>

</QUANTITIES>

</LINE>

</INVOICE>

</INDATA>

Compétences : Excel, Visual Basic, XML

en voir plus : create excel database can posted forums, create excel file visual, create excel pivot table net, c# xml serialization element name, xmlserializer specified, xml serialization in c#, create xml from class object c#, xml serialization in the .net framework, xml serialization assemblies, c# deserialize xml string to list of objects, xml data annotations, xml, microsoft excel, problem utf create excel, create excel files mysql, create excel order status file, create excel chart csv, create excel pivottable, can excel web service calls, php create excel website

Concernant l'employeur :
( 0 commentaires ) United Kingdom

Nº du projet : #17402880

29 freelance font une offre moyenne de £414 pour ce travail

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(595 Commentaires)
8.3
schoudhary1553

Hi there, Warm Greetings We came along with your request for Create an Excel Tool which converts to XML, calls a website and returns specific values from XML string and we reviewed your project description. We'd Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(254 Commentaires)
7.5
seaanddream

Hi, my name is Selim. I read your "Create an Excel Tool which converts to XML, calls a website and returns specific values from XML string" project descriptions carefully before bidding. I checked the attached templ Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(256 Commentaires)
7.6
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(334 Commentaires)
7.2
asin1987

Dear Employer, I have read your job post and I will do the job for you. Please message me. Thanks and Regards, Ash

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(84 Commentaires)
6.6
archanaoswal

I know how to create xml file using Excel, submit the file to a website and parse the results. I have excellent command on MS Excel. I have completed complex projects in Excel before. For instance - Create a sch Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(50 Commentaires)
5.5
qprotex

Hello, My name is Miguel Febres and you can locate my resume and certifications in the following links: [login to view URL] [login to view URL] In my 10+ years of e Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(17 Commentaires)
5.5
SPARKtechBD

Good knowledge on conversion XML to CSV or Excel file. Basically I work on VB, VB.NET to build robust application. I am hard working freelancer and love to work for longterm basis and provide good support.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(10 Commentaires)
5.5
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(57 Commentaires)
5.4
sourabhg98

Hey there, This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer specializing in creating customized excel spreadsheets for businesses and people. Currently I am at the post of FORUM EXPERT Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(71 Commentaires)
5.1
dvcontact

Hi, After reading your project description about creating an Excel tool that will convert values into XML and collect data from external websites and then returns back as a convert Excel file, I feel like you have me Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(30 Commentaires)
5.4
prabakarm23

Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(54 Commentaires)
4.7
pointlogic

Hello, I have read project details and i have good knowledge about it and can do it well. Please message me so we can discuss. Thank you/.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(4 Commentaires)
4.4
sloker18

I am proficient with excel macro/VBA development, I can write the macro to exchange XML data with a URL, please kindly share the website info so I can have a better understanding of the scope of the work, if you are in Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(30 Commentaires)
4.4
supergana

Hi - I saw the file and the code behind it. I think a decent code has been written but its outdated. May be this was written sometime in early 2000s and never updated. Once its updated and compatibility brought in plac Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(21 Commentaires)
4.2
maximwang8661

nice to meet you. your project is very interesting to me. If you hire me, I can start working for you right now. And I will complete your project qualitatively and in time. I have a good experience in excel and exc Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(6 Commentaires)
3.2
JustBoris

Hello. Your example is in the form of a VBA macro. I'm developing the same macros for more than eight years (samples are in my portfolio). I can solve your task without problems. Regards, Boris

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(2 Commentaires)
3.3
pinakincode

Hello sir, We have check detail and as per that you need tool for XML file convert into Excel file. we are able to do your work. Kindly revert back if you find our profile suitable for this project. Looking for Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(3 Commentaires)
2.9
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(3 Commentaires)
2.4
letshappy

hello, i read the project and want to work on your project have more then 9 year experience in development

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 6 jours
(1 Évaluation)
2.6