VB.NET Excel data importer - Compatible with MacOS

We are currently building a marketplace for photographers to sell their art.

In time they will be able to upload their photos directly through the web portal, but for now we're looking to implement a batch import solution.

The goal of this project is to facilitate the import via an excel file.

There is a preliminary step for the import, and then five functional steps :

0) The excel file is placed in a new, empty folder

1) The user clicks on step n°1 button: it creates a 'photos' folder next to the excel file

2) The photographer copies/pastes his files in the generated photo folder

3) The photographer clicks on step n°3 button: the photo folder is scanned

4) The photographer fills in metadata

5) The photographer clicks on step n°5 button: a zip archive is created.

Step n°1: simple directory creation. That's it.

Step n°2: no code whatsoever, photo files are copied into the directory

Step n°3: the scanning process is the most important one. It's where most of the VB code resides. Its job is to:

- scan a specific folder looking for photo files,

- extract size and resolution metadata

- filter out the photos that don't qualify (low res, wrong ratio)

- generate a table in excel, listing all the photos

- generate thumbnails for each photo, and position them at the right place in the table

Step 4:

The photographer would then fill in some metadata : tags, categories...

Some columns to be filled should have data validation, based on the other data tabs of the excel file.

It's quite straightforward:

- DATA-Categories tab lists all the categories

- when the user fills in a category, it should belong to the list within DATA-Categories tab

=> please see provided excel file, the validation is already in place for all columns

Step 5:

The last part of the project is a button that when clicked, would create a zip archive containing:

- the entire photo folder

- the filled excel file

Attached is a template for this excel file, one empty (before scan), one generated (after scan), and one filled (after the photographer's metadata input).

PLEASE IGNORE the text displayed when clicking the buttons, those are obsolete instructions.

Taidot: Excel, tietojärjestelmäarkkitehtuuri, VB.NET, Visual Basic

Näytä lisää: vb net send data internet, vb net save data, vb net parse data file, vs vba, write to excel file, for excel, excel automation, convert vba to online, excel macro, create excel file, read data from excel, excel, visual basic,, vb net fill data adobe life cycle pdf, vb net excel pdf, vb net excel file, vb net excel export csv, vb net excel class, vb net copy data webpage

Tietoa työnantajasta:
( 1 arvostelu ) Paris, France

Projektin tunnus: #17185318

Myönnetty käyttäjälle:


Hi, my name is Selim. I read your "VB.NET Excel data importer - Compatible with MacOS" project descriptions carefully before bidding. I checked the attached excel template & additional files as well... I got what you Lisää

€500 EUR 5 päivässä
(273 Arvostelua)

10 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello, I can help with you in your project Excel data importer. I have more than 5 years of experience in Excel, Software Architecture, VB.NET, Visual Basic. We have worked on several similar projects before! We ha Lisää

€750 EUR 10 päivässä
(309 arvostelua)
€588 EUR 4 päivässä
(97 arvostelua)

Hello Sir, I am an expert in .net and VBA programming and would like to work with you on this project. Thanks Aanvik

€588 EUR 7 päivässä
(56 arvostelua)

Hello. I have rich experience in VB.NET Excel and Macro scripts. will build good script for your Excel file. thanks. akio

€333 EUR 10 päivässä
(22 arvostelua)
€500 EUR 3 päivässä
(106 arvostelua)

HI,, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have the code f Lisää

€376 EUR 5 päivässä
(15 arvostelua)

if you want the tool can run on MacOS, I would like to use xamarin to build this app with c# language, it can deploy the tool in both window OS and MacOS. All feature will be implement with the fee in my bid, no extra Lisää

€333 EUR 10 päivässä
(45 arvostelua)

Hello, we are a team of software developers with years of experience we can provide the solutions and give the exact output according to your requirement.

€750 EUR 10 päivässä
(37 arvostelua)

Available Immediately | MS Excel Expert | MBA | Assured accuracy and minimum turnaround time | VBA Champion You can look at my jobs history and have completed project like these successfully. Looking forward for Lisää

€444 EUR 10 päivässä
(7 arvostelua)