Excel Timecode to Text Automation Script

In Progress

Hello,

I would like a script or some sort of an automation that converts an Excel spreadsheet like this:

Sequence0001 00:00:00:00

Sequence0001 00:00:03:02

Sequence0001 00:02:05:13

Sequence0001 00:04:01:20

Sequence0001 00:04:58:01

Sequence0001 00:05:14:24

Sequence0001 00:06:28:01

Sequence0001 00:06:42:16

Sequence0001 00:07:46:09

Sequence0001 00:09:41:20

to an html (or text) document like this:

<chart>

<!-- 1 -->

<timecode>00:00:00</timecode>

</chart>

<chart>

<!-- 2 -->

<timecode>00:00:03</timecode>

</chart>

<chart>

<!-- 3 -->

<timecode>00:02:05</timecode>

</chart>

<chart>

<!-- 4 -->

<timecode>00:04:01</timecode>

</chart>

<chart>

<!-- 5 -->

<timecode>00:04:58</timecode>

</chart>

<chart>

<!-- 6 -->

<timecode>00:05:14</timecode>

</chart>

<chart>

<!-- 7 -->

<timecode>00:06:28</timecode>

</chart>

<chart>

<!-- 8 -->

<timecode>00:06:42</timecode>

</chart>

<chart>

<!-- 9 -->

<timecode>00:07:46</timecode>

</chart>

<chart>

<!-- 10 -->

<timecode>00:09:41</timecode>

</chart>

I look forward to hearing from you.

Thanks,

Arran

Skills: Data Processing, Excel, HTML

See more: html automation excel, timecode excel, automation excel html, excel timecode script, spreadsheet script, sort excel, script automation, excel to html, excel html, excel 7, excel $2-30, c text processing, c automation, automation c, excelchart, timecode, excel data automation, automation excel spreadsheet, html chart script, script text processing, spreadsheet automation excel, data automation html, excel forward, text document, chart script

Project ID: #1414621

Awarded to:

ZeusMan

Looking forward to working with you...

£30 GBP in 0 days
(56 Reviews)
5.7

19 freelancers are bidding on average £31 for this job

danielgpratidya

Hi, your application is available in pmb.

£30 GBP in 0 days
(83 Reviews)
5.7
vserv

I can provide a simple solution. Pls see your messages.

£30 GBP in 0 days
(57 Reviews)
5.6
gangabass

I can do this for you. See PM for details.

£30 GBP in 0 days
(71 Reviews)
5.4
torajiv

VBA analyst with over 10year experience at your service - more details in PM Thanks

£30 GBP in 1 day
(28 Reviews)
4.6
ExactSystems

Please see solution on PMB. regards

£45 GBP in 1 day
(5 Reviews)
4.6
chriskerpini

Excel-VBA expert, 10 years experience. Your script is ready, having the source file I will made (maybe) a few adjustments, and in 1 hour you would have the script. Kind regards.

£30 GBP in 0 days
(14 Reviews)
4.5
Barns

It is an easy job. I have provided the details in PMB. We have a 100% project completion rate over 17 projects with excellent client feedbacks. Regards, Arijit

£30 GBP in 1 day
(18 Reviews)
4.5
psprongs

I can extract the sequence into a text document using a simple VBA code in a couple of hours. I have worked on similar code before.Thank you.

£30 GBP in 0 days
(10 Reviews)
4.5
microk

********* DONE ************ Check PM to see how it works...

£30 GBP in 0 days
(19 Reviews)
4.3
FLtowhid

Please see my PM.

£30 GBP in 2 days
(4 Reviews)
3.8
dilshz

Work is done.. Just a matter of time to apply it to the whole set of data. simple work.will take only 2 hours. Just accept.. Accuracy 100%

£30 GBP in 0 days
(3 Reviews)
2.5
ahmedsobherfan

Hello, sir i can do it in one hour payment after job completion by escrow Regards

£30 GBP in 0 days
(2 Reviews)
1.0
subha1975

Sir, I have complete this job within a hour and give 100% quality. The price cost of £20

£30 GBP in 1 day
(0 Reviews)
0.0
KNMi386

Check PMB please.

£33 GBP in 1 day
(0 Reviews)
0.0
eIDEA

Work is completed.. 100% accuracy is achieved. with the panel of excel experts this is just nothing.. accept the bid ill send you the script within 10 mins.

£30 GBP in 0 days
(0 Reviews)
0.0
rodolfo000

I already have a couple of similar scripts like the one that you ask, I can deliver a result in 2 or 3 hours

£30 GBP in 0 days
(0 Reviews)
0.0
kevindelhi

Straightaway i can give you an excel macro which takes the data a create an text file in the format which you want.

£30 GBP in 0 days
(0 Reviews)
0.0
wyf23

simple formated text convert job, it's ms -excel file? convert to csv-file would be easier,PM me about the detail.I'm a chinese new comer,thanks.

£30 GBP in 0 days
(0 Reviews)
0.0