Завершен

Convert XML file to Excel (.xlsx)

I need a command line application to convert a bunch of xml file into .xlsx

The input file contains:

a <Definition> element: this is where the structure is defined

a <Records> element: containing the record that will become excel rows

The <Definition> element is composed by:

a <Dictionary> element: a pipe (|) delimited set of records whose first character is the "type" (only F and C type being relevant)

a <Mapping> element: contains the definition of Attributes f1, f2, f3,....fn fields

The application has to create a mapping between f1,f2,f3,...,fn anche the "real" field name

Let's do an example, let's consider the Field element

<Field Name="MCIDR" Attrib="f1"/>

The application

looks in Dictionary F record (F,SMOVC/MC,SBMovCont,I,1,,5,37,1,2,14/01/2020, 16.12.49)

gets the second element (dictionary recors are comma delimited list), i.s. SMOVC/MC

gets the field prefix, i.e. the string _after_ the forward slash (/), i.e. MC

strips the prefix from the Field Name, MCIDR --> IDR

finds in the dictionary the C record whose second element (remember dictionary records are comma delimited), e.g. C,IDR,IDRegis,0,L,4,1,9,0,0,

get the third element, i.e. IDRegis

Build an in memory structure (a dictionary?) mapping f1 --> IDRegis

Repeat for every <Field> element

IDRegis will become the Header of the first column (being associated to f1) in the output excel file

The application, after building the above association, will loop over <Record> elements and insert a row for each of the in the excel file

let's consider the following example:

<Record f1="35132" f2="1" f3="5148" f4="2008-00" f5="1" f6="ORD" f7="130501" f9="2008-12-31" f10="50" f11="150" f15="598" f16="50" f17="1" f18="E" f19="17107.64" f21="E" f23="17107.64" f27="1" f31="1" f33="8"/>

In the first column, whose header is IDRegis, the application will place 35132

As a last thing, the excel sheet name must be the third element of the Dictionary F record (SBMovCont in the above example)

type: command line application (Windows)

language: C# (preferred, I will evaluate other proposal)

input parameters:

path of a folder containing file with .sxdat extension

outcome:

an excel file for each .sxdat file contained in the input folder

attached you'll find

1. a couple of sample .sxdat file

2. a sample .xlsx output file

3. an image showing how to go from .sxdat to .xlsx

Навыки: XML, Excel, Программирование на C#, Обработка данных

Показать больше: macro convert dat file excel file, create xml file excel vba, convert dat file excel free, convert quickbooks file excel, convert xml file rss, generate xml file excel script, convert xml file mysql table, convert dat file excel file, convert word file excel, convert xml file rtf file, convert dat file excel format, convert xml file excel table

О работодателе:
( 1 отзыв ) Invorio, Italy

ID проекта: #26151748

Поручен:

(4 отзывов(-а))
3.6

32 фрилансеров(-а) готовы выполнить эту работу в среднем за €148

schoudhary1553

Hello, I can help you with your project - Convert XML file to Excel (.xlsx) I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already complet Больше

€220 EUR за 4 дней(-я)
(365 отзывов(-а))
8.1
gangabass

Thanks for a very detailed project description! I can provide you a C# CLI app that will work exactly like you want (read input params and generate output XLSX file) in less than 24 hours for just € 200. Roman

€200 EUR за 1 день
(245 отзывов(-а))
6.8
dvcontact

Hi, Would you like to see a quick demo of your XML file converted to xlsx before you award the project? You can consider it professionally done in a few hours. Rather than fill this proposal with a list of qualificati Больше

€200 EUR за 5 дней(-я)
(59 отзывов(-а))
6.5
RRajeshR

Hi, I'm interested to work on your project. I am a java developer and I can provide you the command line program which converts the xml data into xlsx file. I did similar projects to covert data from pdf to excel. Ple Больше

€150 EUR за 5 дней(-я)
(49 отзывов(-а))
6.4
vladang

Hello sir/madam.... i can make you C# console application (or Winform) to convert XML file to XLSX. I have revised your attached files and I can do that. Please, contact me to make deal.... Regards Vladimir

€160 EUR за 5 дней(-я)
(134 отзывов(-а))
6.4
finecodervw

Hi, I have gone through all the 4 attachments i.e. 2 SXDAT files, [login to view URL] and sample xlsx file. I have also gone through the entire project description and have understood how only F and C type records are to be us Больше

€100 EUR за 2 дней(-я)
(57 отзывов(-а))
5.7
ashkanvb

Hi, This is a kind of work I have done a lot and I'm sure that I can deliver a very good application using C#. I am a Senior .Net Developer with 15+ years of experience in C#, a preferred freelancer and one of few pe Больше

€250 EUR за 2 дней(-я)
(15 отзывов(-а))
5.4
NewHorizons2016

Hello there, I am a professional software engineer from Europe and have developed Windows applications , using high=performance C and C++ for a very very long time. I offer various Data Convertors for various data for Больше

€200 EUR за 3 дней(-я)
(11 отзывов(-а))
5.5
narsim3128

NOTE : I HAVE EXPERTISE IN C#. I CAN COMPLETE THIS TASK IN QUICK TIME With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I ha Больше

€140 EUR за 3 дней(-я)
(53 отзывов(-а))
5.8
deepthi2889

Hi,  I am a Full stack developer in Microsoft technologies.  My area of expertise is web application development (asp.Net web forms, MVC, classic ASP), web services (SOAP & RESTFul), MySql & Sql Server as back end ( Больше

€250 EUR за 2 дней(-я)
(23 отзывов(-а))
5.5
tutulsoft

-- XML Expert ---------------- XML to Excel Conversion or XML to any media integration Expert is here ---- I did many job with XML , you can see also in my review. Last 15 years i am working with XML, Excel and Больше

€135 EUR за 4 дней(-я)
(11 отзывов(-а))
4.8
nemanjadj20

Hello? I have worked on Excel/Word/PPT/MACRO projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seeking. # create in Больше

€155 EUR за 3 дней(-я)
(10 отзывов(-а))
4.5
TeamDPS

hi sir am interested in your task. myself 6 years experienced developer. my aim to provide quality work to satisfied you. you can check my reviews for assurance of quality task. we can discuss more via chat.

€50 EUR за 2 дней(-я)
(15 отзывов(-а))
4.3
mdramindz

Hello, I want little discussion on the requirement. However, am individual full time freelancer with 10 years experience. You can see an example of one of those projects in my portfolio here: https://www.freelancer. Больше

€249 EUR за 12 дней(-я)
(13 отзывов(-а))
4.6
IshaqKN

Hi there, "command line application (Windows)" Yes sure. Python is better option since it's data processing task. Will take care of everything you mentioned. It will be completely standalone CLI app - only double-cli Больше

€100 EUR за 2 дней(-я)
(14 отзывов(-а))
4.0
rimiloca

Hi, how are you? I have just read the description, I can parase xml file and put the data to excel file. I am very familiar with c# FILE I/O function, I am sure I can do this project perfectly. Please contact me to Больше

€150 EUR за 2 дней(-я)
(3 отзывов(-а))
3.7
BeshoyMousaKhair

hi , it's not a difficult task for me and i can do it as required and on time , best regards ,

€150 EUR за 7 дней(-я)
(17 отзывов(-а))
3.7
ondergormez

Hello, I will do this for €45.00. Please check my portfolio items. You can see the generating excel file from the data grid. And I also have an XML file parser. Let's adapt these libraries to your project. Let's meet Больше

€45 EUR за 7 дней(-я)
(3 отзывов(-а))
1.9
Lightcanon

Hello, I think Python fits this task more than C# specially when dealing with XML and Excel. I am Python expert of + 5 years experience in Python. Command line tool to populate an Excel file based on XML on is easy for Больше

€150 EUR за 4 дней(-я)
(1 отзыв)
1.8
sergeychursin

Hello, I can make it in C# or PHP, whether you want I can do it perfect and quickly. As an Expert in this field. I can give you my word that I make it all match to your requirements. I have strong skills in Database m Больше

€60 EUR за 3 дней(-я)
(1 отзыв)
1.3