İptal Edildi

[login to view URL] xml format from an excel file -- 2

I am using [url removed, login to view] to upload customer info and print shipping labels. All our customer information is in an excel file. [url removed, login to view] supports batch uploading using their own xml format. What we need is to automatically (or just press one button) export the excel data into the [url removed, login to view] xml format, which can be uploaded into [url removed, login to view] software directly.

The technical difficulties (for me) are :

1) the xml file needs to have data which is defined as "list of lists" by excel. List of lists is not exportable to xml by excel.

2) automatically generate the xml file from the excel file. This could be achieved by a macro or a visual basic button? I already have one "print invoices" button with the excel file, I like to append the new function of generating the xml file to it. So at the end, I only need to click one button, all invoice will be printed (current existing function) AND the ready-to-use xml file will be created (to be done).

Updates: I am using Excel 2003. I also uploaded the xml format I need, and the excel file. In the uploaded excel file, all cells contain direct values. However in the actual excel file (which is too big to upload), all values are calculated from formulas.

Thank you

Beceriler: Excel, XML

Daha fazlasını gör: direct file upload, what is macro in excel, xml export, xml excel, Visual Basic Excel, macro to upload, export from excel, excel visual basic, xml invoice, xml excel format, batch batch excel file, excel 2014 macro, xml file excel, excel macro upload data, visual basic shipping, excel xml list lists export, stamps uploading xml, invoice format, com file upload, macro values, excel file exportable, macro formulas, macro excel format, excel macro data list, data list invoice excel

İşveren Hakkında:
( 33 değerlendirme ) chula vista, United States

Proje NO: #6497751

Bu iş için 2 freelancer ortalamada $244 teklif veriyor


Hi Bro, please provide me excel and XML file I will read the excel and change to XML Yasidy and rideshareusa are classified site developed in core php/mysql. having a good experience in classified sites so kindly chec Daha Fazla

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)