In Progress

Develop template (HTML, PDF, EXCEL) for importing data from CSV

Title

Our aim is to create a template to repeatedly convert data from a csv file into a stocklist matrix.

The requirements

The process as following steps:

1. We create a csv file according to example "Sample [url removed, login to view]"

2. We want to run a file/program to pick up the data and convert into a file according to the layout as example "Sample [url removed, login to view]"

a. The colour and size information needs to be displayed in a matrix format.

b. We have to load 1 picture per item. If no picture then blank.

3. We want to calculate the totals per row in the matrix as well as the total qty at the end of the list as per example "Sample [url removed, login to view]"

4. We need to be able to save as pdf and print.

5. In the title: “AVAILABLE STOCK AS PER [url removed, login to view]” the date needs to be today’s date (systems date)

The document does not need to be a excel spreadsheet – we are open ofr other formats such as pdf or html as long as there is a print document function which allows up to print and distribute the document.

The following files are attached for further reference:

- Project description including Data Mapping.

- Sample CSV data file

- Sample Template

- Sample pictures

Skills: Excel, HTML, PDF, Visual Basic

See more: develop template, excel csv sample document, csv excel, pdf template csv, csv pdf template, spreadsheet in html, mapping document, html to spreadsheet, html spreadsheet example, html spreadsheet, html develop, html 5 pdf, html 5 date, formats in excel, develop a picture, c template function, c program template, csv spreadsheet, convert pdf to excel spreadsheet, template html 5, layout html 5, xlsx, template html, save to excel, save pdf

About the Employer:
( 10 reviews ) Noosa Heads, Australia

Project ID: #2513528

Awarded to:

Nhcuong

Hi, i can do it. I'm a programmer for years and very familiar with VBA for excel automation like what you need. I can write a macro you need only to run, it will: 1 prompt user to select an input csv file 2 read the More

$70 USD in 3 days
(19 Reviews)
4.8

22 freelancers are bidding on average $167 for this job

svet63

Actually, Excel is the best fit to code your template. Can do. Regards, Svet.

$250 USD in 3 days
(68 Reviews)
6.5
Risalat1

Let me do it for u..

$300 USD in 7 days
(63 Reviews)
6.5
srinichal

I can deliver the project to your requirements

$250 USD in 5 days
(43 Reviews)
6.2
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$250 USD in 30 days
(12 Reviews)
6.0
mrbrave

HI..... Please see PMB for how I will do this.

$200 USD in 2 days
(75 Reviews)
5.4
bouslimi1979

Please check PM. Thanks

$120 USD in 2 days
(33 Reviews)
5.3
pkcyber

Hi, You can use our skills for this project.

$70 USD in 2 days
(17 Reviews)
5.1
try67

Hi, I can create for you a custom-made script that will produce PDF files with the data from the CSV file. See my PM for more info...

$275 USD in 3 days
(8 Reviews)
4.6
HosElectro

Hi , im an experienced visual basic programmer for more than 7 years have a good command of scripting please check my pm

$100 USD in 5 days
(10 Reviews)
4.5
adim

Hello there, Lot of Excel experience here. I can help you with this job. Best regards, Adrian

$150 USD in 1 day
(11 Reviews)
4.3
ptbsolutions

hi i am experienced data analyst i can do it right way.

$110 USD in 5 days
(7 Reviews)
4.0
expertatwork

We are a team of experts in Excel VBA. Looking forward to work with you ! Please have a look at our message in your PMB.

$85 USD in 4 days
(16 Reviews)
3.6
vikashgadia

WE R EXCEL MACRO EXPERT FROM INDIA

$100 USD in 1 day
(14 Reviews)
3.5
sofina2006

Hello Sir, I can do it, but please read my message and do not hesitate to ask me for any question.

$75 USD in 2 days
(4 Reviews)
3.1
cheungkc

Hi I am proposing to provide a solution using Excel 2003 or 2007. I assume the user will be able to print direct from his/her own Excel application. I also assume the two price columns are blank to be filled in b More

$100 USD in 3 days
(7 Reviews)
3.0
sthakral

Hello, Looked at your requirements. I can easily do this within 48 hours of your allocating the work to me. Pls see PMB for further details.

$220 USD in 2 days
(1 Review)
1.9
bishalsaha

After analyzing your requirements list we could decipher that in a nutshell - you need a PHP champion. Thus we feel that we stand a good chance here, though its entirely up to you whether you consider us as someone who More

$100 USD in 5 days
(0 Reviews)
0.0
bokata26

I have a great skills in this programming area and I ready for work...

$150 USD in 3 days
(0 Reviews)
0.0
oasissoftwareinc

Hi, I have over 12 years of Experience in software design, development and implementation of various commercial applications in Client/Server environment, Web and ERP applications using C# 1.1/2.0/3.5, ASP.Net, VB.N More

$200 USD in 4 days
(0 Reviews)
0.0
aaronshawpro

Hi, I would like to work on the project for you. As I am new to the site I can give you a cheap rate but will deliver what you need. Cheers.

$100 USD in 7 days
(0 Reviews)
0.0